my metastore is like this <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://192.168.1.40:3306/hive</value> </property> <property> <name>javax.jdo.option.ConnectionDriverName</name> <value>com.mysql.jdbc.Driver</value> <description>Driver class name for a JDBC metastore</description> </property>
<property> <name>javax.jdo.option.ConnectionUserName</name> <value>hive</value> </property> <property> <name>javax.jdo.option.ConnectionPassword</name> <value>hive123!@#</value> </property> <property> <name>hive.metastore.warehouse.dir</name> <value>/user/${user.name}/hive-warehouse</value> <description>location of default database for the warehouse</description> </property> ------------------ ???????? ------------------ ??????: "Wang, Daoyuan";<daoyuan.w...@intel.com>; ????????: 2015??5??5??(??????) ????3:22 ??????: "??"<980548...@qq.com>; "luohui20001"<luohui20...@sina.com>; ????: "user"<user@spark.apache.org>; ????: RE: ??????spark Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient How did you configure your metastore? Thanks, Daoyuan From: ?? [mailto:980548...@qq.com] Sent: Tuesday, May 05, 2015 3:11 PM To: luohui20001 Cc: user Subject: ??????spark Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient hi luo, thanks for your reply in fact I can use hive by spark on my spark master machine, but when I copy my spark files to another machine and when I want to access the hive by spark get the error "Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient" , I have copy hive-site.xml to spark conf directory and I have the authenticated to access hive metastore warehouse; Thanks , Best regards! ------------------ ???????? ------------------ ??????: "luohui20001";<luohui20...@sina.com>; ????????: 2015??5??5??(??????) ????9:56 ??????: "??"<980548...@qq.com>; "user"<user@spark.apache.org>; ????: ??????spark Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient you may need to copy hive-site.xml to your spark conf directory and check your hive metastore warehouse setting, and also check if you are authenticated to access hive metastore warehouse. -------------------------------- Thanks&Best regards! ???? San.Luo ----- ???????? ----- ????????"??" <980548...@qq.com> ????????"user" <user@spark.apache.org> ??????spark Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient ??????2015??05??05?? 08??49?? hi all, when i use submit a spark-sql programe to select data from my hive database I get an error like this: User class threw exception: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient ,what's wrong with my spark configure ,thank any help !