I'm trying to use the Hive StorageHandler for Pheonix, but getting this error: Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:No suitable driver found for jdbc:phoenix:ip-10-113-98-203.ec2.internal:2181:/hbase-unsecure;) (state=08S01,code=1) I know that Hive and Phoenix are working on the cluster (which is HDP2.5). This test shows that DNS is working, a valid Zookeeper server, and the ZNode for Hbase zookeeper-client -server ip-10-113-98-203.ec2.internal:2181 ls / | tail -1 [registry, hiveserver2, zookeeper, hbase-unsecure, rmstore] I add the jars in the hive script like this: -- hadoop fs -copyFromLocal /usr/hdp/current/phoenix-client/phoenix-hive.jar /user/etl/hive_libs ADD JAR hdfs:///user/etl/hive_libs/phoenix-hive.jar; ADD JAR hdfs:///user/etl/hive_libs/phoenix-client.jar; Using this example (https://phoenix.apache.org/hive_storage_handler.html) and replacing the the hostname and ZNode per above gives the command that fails. createtablephoenix_table ( s1 string, i1 int, f1 float, d1 double ) STORED BY'org.apache.phoenix.hive.PhoenixStorageHandler' TBLPROPERTIES ( "phoenix.table.name" = "phoenix_table", "phoenix.zookeeper.quorum" = "ip-10-113-98-203.ec2.internal", "phoenix.zookeeper.znode.parent" = "/hbase-unsecure", "phoenix.zookeeper.client.port" = "2181", "phoenix.rowkeys" = "s1, i1", "phoenix.column.mapping" = "s1:s1, i1:i1, f1:f1, d1:d1", "phoenix.table.options" = "SALT_BUCKETS=10, DATA_BLOCK_ENCODING='DIFF'" ); Does anyone who uses the Hive StorageHandler have an idea about this?
... View more
