Support Questions

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

qlikView HiveODBC/Phoenix



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 select * from table name



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


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>

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