Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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

Contributor

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

@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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.