Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

qlikView HiveODBC/Phoenix

qlikView HiveODBC/Phoenix

Contributor

Hi,

As am facing some issues with Phoenix ODBC, am trying to use Hive ODBc(on phoenix data) from qlik view. its just select statement only.

but am getting fallowing exception from qlikview Script:

Error message from server: Error while compiling statement: FAILED: RuntimeException org.apache.hadoop.hive.ql.metadata.HiveException: Error in loading storage handler.org.apache.phoenix.hive.PhoenixStorageHandler select * from table name

2 REPLIES 2

Re: qlikView HiveODBC/Phoenix

Contributor

can you please post the whole stack trace of the error message? it seems like you omitted some meaningful parts

Re: qlikView HiveODBC/Phoenix

@vnandigam

It seems like you haven't updated the classpath to include the Phoenix jars. Have you updated your hive-env to include them:

HIVE_AUX_JARS_PATH=<path to jar>

https://phoenix.apache.org/hive_storage_handler.html