Skip to first unread message
ritch...@abrs.com.hk
Oct 10, 2018, 11:07:37 AM10/10/18
to Machine Intelligence and Data Science WonderCorp
FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
It could be due to the default setting:/**user/hive/warehouse** (in the hive-site.xml) is not properly created or permission granted. (**pls note this is **user**, not **usr**)
which may be the culprit if you are doing a manual setup!
1) You may first check out the hive-site.xml (located at $HIVE_HOME/conf in my case is /usr/local/hive/conf) if you want, but which is the initially set default anyway
2) check if the path in Hadoop using: *hadoop fs -ls /user/hive/warehouse* exists or not?
3) create the Hadoop folder by using: *hadoop fs -mkdir /usr/hive/wawrehouse* if non-existing, take a look at the access right using Hadoop fs -ls ...............
4) use *Hadoop fs -chmod g+w /usr/.................* to grant the needed right
**Reference** (from hive-site.xml):
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive/warehouse</value>
<description>location of default database for the warehouse</description>
</property>
Reply all
Reply to author
Forward
0 new messages