Created 03-23-2017 12:02 PM
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
Created 03-23-2017 03:56 PM
can you please post the whole stack trace of the error message? it seems like you omitted some meaningful parts
Created 03-27-2017 03:18 PM
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>