qlikView HiveODBC/Phoenix

[#1]

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]

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

[#3]

@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