Have you config the SPARK_CLASSPATH with the jar of mysql in spark-env.sh?For example (export SPARK_CLASSPATH+=:/path/to/mysql-connector-java-5.1.18-bin.jar)
> ?? 2015??5??5????????3:32???? <980548...@qq.com> ?????? > > 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 > > ?0?2 <> > 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 <mailto:luohui20...@sina.com>>; > > ????????: 2015??5??5??(??????) ????9:56 > > ??????: "??"<980548...@qq.com <mailto:980548...@qq.com>>; > "user"<user@spark.apache.org <mailto: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 <mailto:980548...@qq.com>> > ????????"user" <user@spark.apache.org <mailto: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 ! >