Support Questions

Find answers, ask questions, and share your expertise

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