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

2015-05-05 Thread ??
thanks  jeanlyn itworks




--  --
??: "jeanlyn";;
: 2015??5??5??(??) 3:40
??: "??"<980548...@qq.com>; 
: "Wang, Daoyuan"; "user"; 
: 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  
 
javax.jdo.option.ConnectionURL
jdbc:mysql://192.168.1.40:3306/hive



javax.jdo.option.ConnectionDriverName
com.mysql.jdbc.Driver
Driver class name for a JDBC metastore



javax.jdo.option.ConnectionUserName
hive
 


javax.jdo.option.ConnectionPassword
hive123!@#



hive.metastore.warehouse.dir   
 
/user/${user.name}/hive-warehouse
location of default database for the 
warehouse






--  --
??: "Wang, Daoyuan";;
: 2015??5??5??(??) 3:22
??: "??"<980548...@qq.com>; "luohui20001"; 
: "user"; 
: 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";;


????: 2015??5??5??(??) 9:56


??: "??"<980548...@qq.com>; "user"; 


: ??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" 
??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 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  
>  
> javax.jdo.option.ConnectionURL
> jdbc:mysql://192.168.1.40:3306/hive
> 
> 
> 
> javax.jdo.option.ConnectionDriverName
> com.mysql.jdbc.Driver
> Driver class name for a JDBC metastore
> 
> 
> 
> javax.jdo.option.ConnectionUserName
> hive
>  
> 
> 
> javax.jdo.option.ConnectionPassword
> hive123!@#
> 
> 
> 
> hive.metastore.warehouse.dir 
>
> /user/${user.name}/hive-warehouse
> location of default database for the 
> warehouse
> 
> 
> 
> 
> --  --
> ??: "Wang, Daoyuan";;
> ????: 2015??5??5??(??) 3:22
> ??: "??"<980548...@qq.com>; "luohui20001"; 
> : "user"; 
> : 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";mailto:luohui20...@sina.com>>;
> 
> : 2015??5??5??(??) 9:56
> 
> ??: "??"<980548...@qq.com <mailto:980548...@qq.com>>; 
> "user"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" 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 ??
my metastore is like this  
 
javax.jdo.option.ConnectionURL
jdbc:mysql://192.168.1.40:3306/hive



javax.jdo.option.ConnectionDriverName
com.mysql.jdbc.Driver
Driver class name for a JDBC metastore



javax.jdo.option.ConnectionUserName
hive
 


javax.jdo.option.ConnectionPassword
hive123!@#



hive.metastore.warehouse.dir   
 
/user/${user.name}/hive-warehouse
location of default database for the 
warehouse






--  --
??: "Wang, Daoyuan";;
: 2015??5??5??(??) 3:22
??: "??"<980548...@qq.com>; "luohui20001"; 
????: "user"; 
: 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";;
 
  
: 2015??5??5??(??) 9:56
 
  
??: "??"<980548...@qq.com>;  "user"; 
 
  
????: ??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" 
 ??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";mailto:luohui20...@sina.com>>;
发送时间: 2015年5月5日(星期二) 上午9:56
收件人: "鹰"<980548...@qq.com<mailto:980548...@qq.com>>; 
"user"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" 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 !


??????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";;
: 2015??5??5??(??) 9:56
??: "??"<980548...@qq.com>; "user"; 

: ??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" 
??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 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.



 
Thanks&Best regards!
罗辉 San.Luo

- 原始邮件 -
发件人:"鹰" <980548...@qq.com>
收件人:"user" 
主题: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 !