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
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>