thanks jeanlyn itworks
------------------ ???????? ------------------
??????: "jeanlyn";<oujianl...@jd.com>;
????????: 2015??5??5??(??????) ????3:40
??????: "??"<980548...@qq.com>;
????: "Wang, Daoyuan"<daoyuan.w...@intel.com>; "user"<user@spark.apache.org>;
????: Re: spark Unable to instantiate
org.apache.hadoop.hive.metastore.HiveMetaStoreClient
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
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 !
