Member since
04-05-2018
14
Posts
1
Kudos Received
0
Solutions
04-10-2018
12:19 PM
Hi, Even after doing the steps as stated in the doc, problem continued. I managed to find the workaround by commenting out hive-env template section about HIVE_AUX_JARS_PATH and adding command below. export HIVE_AUX_JARS_PATH=/usr/hdp/current/phoenix-client/phoenix-hive.jar I dont know why script didnt work, will try to find out when I have time.
... View more
04-09-2018
10:38 AM
Is there any suggestion?
... View more
04-05-2018
04:59 PM
Hi, On hdp 2.6.4 when I try to create a hive external table with following command. I get org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException Cannot find class 'org.apache.phoenix.hive.PhoenixStorageHandler' CREATE EXTERNAL TABLE loadprofile(
key STRING,
k_0_0_0 INT,
k_0_9_1_2 STRING,
k_0_9_5 INT,
k_0_8_4 INT,
r_date STRING,
a DOUBLE,
b DOUBLE,
c DOUBLE,
d DOUBLE,
e DOUBLE,
f DOUBLE,
g_1 DOUBLE,
g_2 DOUBLE,
g_3 DOUBLE,
h_1 DOUBLE,
h_2 DOUBLE,
h_3 DOUBLE)
STORED BY 'org.apache.phoenix.hive.PhoenixStorageHandler'
TBLPROPERTIES (
"phoenix.table.name" = "loadprofile",
"phoenix.zookeeper.quorum" = "iqb.hdp1.com,iqb.hdp2.com,iqb.hdp3.com",
"phoenix.zookeeper.znode.parent" = "/hbase-unsecure",
"phoenix.zookeeper.client.port" = "2181",
"phoenix.rowkeys" = "key",
"phoenix.column.mapping" = "key:key,k_0_0_0:k_0_0_0,k_0_9_1_2:k_0_9_1_2,k_0_9_5:k_0_9_5,k_0_8_4:k_0_8_4,r_date:date,a:a,b:b,c:c,d:d,e:e,f:f,g_1:g_1,g_2:g_2,g_3:g_3,h_1:h_1,h_2:h_2,h_3:h_3"
); Do i need to install PhoenixStorageHandler manually. If so, how can i do that?
... View more
Labels:
- Labels:
-
Apache HBase
-
Apache Hive
-
Apache Phoenix