?????? spark Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
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
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
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
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
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
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
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 !