Hi,
I am using HDP 2.5.3.0 version.
I have created schema in phoenix and under that schema I have created table.
After creating table in phoenix, I have tried to created external table on hive. But while creating table I am getting following error.
Failed with exception java.io.IOException:java.lang.RuntimeException: org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined. tableName=ACCOUNT1
DDL:-
CREATE EXTERNAL TABLE account1 (
acct_no Int ,
acct_descr string
)
ROW FORMAT SERDE
'org.apache.phoenix.hive.PhoenixSerDe'
STORED BY 'org.apache.phoenix.hive.PhoenixStorageHandler'
TBLPROPERTIES (
"phoenix.table.name" = "account1",
"phoenix.zookeeper.quorum"="<ZKNODE>",
"phoenix.zookeeper.znode.parent" = "/hbase-unsecure",
"phoenix.zookeeper.client.port" = "2181",
"phoenix.rowkeys" = "acct_no",
"phoenix.column.mapping" = "acct_no:acct_no, acct_descr:acct_descr");
Tried following steps also to resolve the issue.
1)jar uf /usr/hdp/current/hive-server2/auxlib/phoenix-4.7.0.2.5.6.0-40-client.jar /etc/hive/conf/hive-site.xml
2) jar uf /usr/hdp/current/hive-server2/auxlib/phoenix-4.7.0.2.5.6.0-40-client.jar /etc/hbase/conf/hbase-site.xml
3) jar uf /usr/hdp/current/hive-server2/auxlib/phoenix-hive-4.7.0.2.5.3.0-37.jar /etc/hbase/conf/hbase-site.xml
4) jar uf /usr/hdp/current/hive-server2/auxlib/phoenix-hive-4.7.0.2.5.3.0-37.jar /etc/hive/conf/hive-site.xml
5) jar -uf /usr/hdp/2.5.6.0-40/phoenix/phoenix-4.7.0.2.5.6.0-40-client.jar /etc/hive/conf/hive-site.xml
6) jar -uf /usr/hdp/2.5.6.0-40/phoenix/phoenix-4.7.0.2.5.6.0-40-client.jar /etc/hbase/conf/hbase-site.xml
7) Edit Ambari->Hive->Configs->Advanced->Custom hive-site->Add Property..., add the following properties based on your HBase configurations(you can search in Ambari->HBase->Configs):
custom hive-site.xml
hbase.zookeeper.quorum= ZKNODEt
zookeeper.znode.parent=/hbase-unsecure
phoenix.schema.mapSystemTablesToNamespace=true
phoenix.schema.isNamespaceMappingEnabled=true
😎 Restart Hive via Ambari
9) Copy jar to /usr/hdp/current/hive-server2/auxlib from
/usr/hdp/2.5.6.0-40/phoenix/phoenix-4.7.0.2.5.6.0-40-hive.jar
/usr/hdp/2.5.6.0-40/phoenix/phoenix-hive-4.7.0.2.5.6.0-40-sources.jar
download jar phoenix-hive-4.7.0.2.5.3.0-37.jar
HIVE_AUX_JARS_PATH=/usr/hdp/current/hive-server2/auxlib
10)phoenix.schema.mapSystemTablesToNamespace=true
phoenix.schema.isNamespaceMappingEnabled=true
Please help on this. Need urgent help.
