无法从hbase馈送配置单元中的表

mdfafbf1  于 2021-07-13  发布在  Hbase
关注(0)|答案(1)|浏览(480)

在hdp3.1.x上,我创建了一个链接到hbase的表,其中的选项存储在 org.apache.hadoop.hive.hbase.HBaseStorageHandler . 当执行select时,它工作正常。当我试图从中填充一个表时,它会因为错误而崩溃

create table test as select * from hbase_xxx;

INFO  : Completed executing command(queryId=hive_20210205161427_a49ca7bc-0637-4c19-9a62-6657376373a1); Time taken: 74.951 seconds

Error: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. 
Vertex failed, vertexName=Map 1, vertexId=vertex_1611574680060_3923_1_00, diagnostics=[Vertex vertex_1611574680060_3923_1_00 [Map 1] killed/failed due to:ROOT_INPUT_INIT_FAILURE, Vertex Input: raw_eff_ann_ent initializer failed, vertex=vertex_1611574680060_3923_1_00 [Map 1], 
org.apache.hadoop.hbase.client.RetriesExhaustedException: Can't get the location for replica 0

在查看yarn日志时,它似乎试图从具有 localhost:2181 ... 失败了

2021-02-05 11:22:41,921 [WARN] [ReadOnlyZKClient-localhost:2181@0x48730f2c] |zookeeper.ReadOnlyZKClient|: 0x48730f2c to localhost:2181 failed for get of /hbase/hbaseid, code = CONNECTIONLOSS, retries = 1

select上的同一个日志显示zookeeper\u quorum连接字符串到zookeeper并成功
有什么想法吗?

kmynzznz

kmynzznz1#

我从支持中得到了回报;您必须强制hbase-site.xml进入hive env的模板这就是解决方案

Add the below:
export HIVE_AUX_JARS_PATH=${HIVE_AUX_JARS_PATH}:/etc/hbase/conf/hbase-site.xml 
to your Advanced hive-env->hive-env template, before this statement export METASTORE_PORT={{hive_metastore_port}}

相关问题