Re: spark Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient

2015-05-05 Thread jeanlyn 
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??53:32 980548...@qq.com ??
 
 my metastore is like this  
  property
 namejavax.jdo.option.ConnectionURL/name
 valuejdbc:mysql://192.168.1.40:3306/hive/value
 /property
 
 property
 namejavax.jdo.option.ConnectionDriverName/name
 valuecom.mysql.jdbc.Driver/value
 descriptionDriver class name for a JDBC metastore/description
 /property
 
 property
 namejavax.jdo.option.ConnectionUserName/name
 valuehive/value
 /property 
 
 property
 namejavax.jdo.option.ConnectionPassword/name
 valuehive123!@#/value
 /property
 
 property
 namehive.metastore.warehouse.dir/name 

 value/user/${user.name}/hive-warehouse/value
 descriptionlocation of default database for the 
 warehouse/description
 /property
 
 
 
 --  --
 ??: Wang, Daoyuan;daoyuan.w...@intel.com;
 : 2015??5??5??(??) 3:22
 ??: ??980548...@qq.com; luohui20001luohui20...@sina.com; 
 : useruser@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; 
 useruser@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.
 
 
 
 
  
 
 Thanksamp;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 !

RE: 回复：spark Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient

2015-05-05 Thread Wang, Daoyuan 
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.commailto:luohui20...@sina.com;
发送时间: 2015年5月5日(星期二) 上午9:56
收件人: 鹰980548...@qq.commailto:980548...@qq.com; 
useruser@spark.apache.orgmailto: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.



Thanksamp;Best regards!
罗辉 San.Luo

- 原始邮件 -
发件人：鹰 980548...@qq.commailto:980548...@qq.com
收件人：user user@spark.apache.orgmailto: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 !

??????RE: ??????spark Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient

2015-05-05 Thread ?? 
my metastore is like this  
 property
namejavax.jdo.option.ConnectionURL/name
valuejdbc:mysql://192.168.1.40:3306/hive/value
/property

property
namejavax.jdo.option.ConnectionDriverName/name
valuecom.mysql.jdbc.Driver/value
descriptionDriver class name for a JDBC metastore/description
/property

property
namejavax.jdo.option.ConnectionUserName/name
valuehive/value
/property 

property
namejavax.jdo.option.ConnectionPassword/name
valuehive123!@#/value
/property

property
namehive.metastore.warehouse.dir/name   
 
value/user/${user.name}/hive-warehouse/value
descriptionlocation of default database for the 
warehouse/description
/property





--  --
??: Wang, Daoyuan;daoyuan.w...@intel.com;
: 2015??5??5??(??) 3:22
??: ??980548...@qq.com; luohui20001luohui20...@sina.com; 
: useruser@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;  useruser@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.
 
 
  

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

??????spark Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient

2015-05-05 Thread ?? 
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; useruser@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.




 

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

?????? spark Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient

2015-05-05 Thread ?? 
thanks  jeanlyn itworks




--  --
??: jeanlyn;oujianl...@jd.com;
: 2015??5??5??(??) 3:40
??: ??980548...@qq.com; 
: Wang, Daoyuandaoyuan.w...@intel.com; useruser@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??53:32 980548...@qq.com ??

my metastore is like this  
 property
namejavax.jdo.option.ConnectionURL/name
valuejdbc:mysql://192.168.1.40:3306/hive/value
/property

property
namejavax.jdo.option.ConnectionDriverName/name
valuecom.mysql.jdbc.Driver/value
descriptionDriver class name for a JDBC metastore/description
/property

property
namejavax.jdo.option.ConnectionUserName/name
valuehive/value
/property 

property
namejavax.jdo.option.ConnectionPassword/name
valuehive123!@#/value
/property

property
namehive.metastore.warehouse.dir/name   
 
value/user/${user.name}/hive-warehouse/value
descriptionlocation of default database for the 
warehouse/description
/property





--  --
??: Wang, Daoyuan;daoyuan.w...@intel.com;
: 2015??5??5??(??) 3:22
??: ??980548...@qq.com; luohui20001luohui20...@sina.com; 
: useruser@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; useruser@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.






 


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

spark Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient

2015-05-04 Thread ?? 
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 !

回复：spark Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient

2015-05-04 Thread luohui20001 
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.



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