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 !
>
