Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org/apache/hadoop/hbase/

!!!!!!!Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org/apache/hadoop/hbase/HBaseConfiguration!!!!!!!!
**hive表关联HBase时候遇到的错误建表语句如下:**
	create external table ext_calllogs_in_hbase(id string, caller string,callee string,time string,dur string) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,info:caller,info:callee,info:time,info:dur") TBLPROPERTIES ("hbase.table.name" = "phone:log");
**遇到的错误:**
	18/12/07 13:45:29 [main]: ERROR exec.DDLTask: java.lang.NoClassDefFoundError: org/apache/hadoop/hbase/HBaseConfiguration
at org.apache.hadoop.hive.hbase.HBaseStorageHandler.setConf(HBaseStorageHandler.java:279)
at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:73)
at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133)
at org.apache.hadoop.hive.ql.metadata.HiveUtils.getStorageHandler(HiveUtils.java:304)
at org.apache.hadoop.hive.ql.metadata.Table.getStorageHandler(Table.java:305)
at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:4090)
at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:286)
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:155)
at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:85)
at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1554)
at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1321)
at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1139)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:962)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:952)
at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:269)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:221)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:431)
at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:800)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:694)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:633)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.util.RunJar.main(RunJar.java:212)

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org/apache/hadoop/hbase/HBaseConfiguration

**解决方案:**
导入Hive连接操作HBase的jar包:
	cp hbase-common-0.98.6-cdh5.3.6.jar  /home/hadoop/install/hive-0.13.1-cdh5.3.6/lib/
	cp hbase-client-0.98.6-cdh5.3.6.jar /home/hadoop/install/hive-0.13.1-cdh5.3.6/lib/
	cp hbase-server-0.98.6-cdh5.3.6.jar /home/hadoop/install/hive-0.13.1-cdh5.3.6/lib/
	cp hbase-protocol-0.98.6-cdh5.3.6.jar /home/hadoop/install/hive-0.13.1-cdh5.3.6/lib/
	cp hbase-it-0.98.6-cdh5.3.6.jar /home/hadoop/install/hive-0.13.1-cdh5.3.6/lib/
	cp htrace-core-2.04.jar /home/hadoop/install/hive-0.13.1-cdh5.3.6/lib/
	cp hbase-hadoop2-compat-0.98.6-cdh5.3.6.jar /home/hadoop/install/hive-0.13.1-cdh5.3.6/lib/
	cp hbase-hadoop-compat-0.98.6-cdh5.3.6.jar /home/hadoop/install/hive-0.13.1-cdh5.3.6/lib/
**启动hive后台服务:**
	bin/hive --service metastore &
	bin/hive --service hiveserver2 &
**修改/etc/profile:**
	export HBASE_HOME=/home/hadoop/install/hbase-0.98.6-cdh5.3.6/
	export HIVE_HOME=/home/hadoop/install/hive-0.13.1-cdh5.3.6/
  • 1
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值