我想通过hive cli从hbase读取数据。我用以下命令启动Hive
bin/hive --auxpath /usr/local/hive/lib/hive-hbase-handler-0.14.0.jar , /usr/local/hive/lib/hbase-common-0.98.8-hadoop2.jar , /usr/local/hive/lib/zookeeper-3.4.6.jar , /usr/local/hive/lib/guava-11.0.2.jar , /usr/local/hive/lib/hbase-protocol-0.98.8-hadoop2.jar , /usr/local/hive/lib/hbase-server-0.98.8-hadoop2.jar -hiveconf hbase hbase.master=masternode:60000 hive.root.logger=INFO,console hbase.zookeeper.quorum=localhost:2181
我运行以下查询
hive> CREATE TABLE table1(key int, value string)
> STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
> WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:name")
> TBLPROPERTIES ("hbase.table.name" = "emp2");
但我收到这个错误
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.org/apache/hadoop/hbase/client/HBaseAdmin
有什么问题吗?谢谢您!
1条答案
按热度按时间hiz5n14c1#
我已经解决了这个问题,在命令行中将hbase-client-0.98.8-hadoop2.jar添加到类路径。不过,我现在有个例外
它之所以有效,是因为我在类路径中添加了htrace-core-2.04.jar。