Discussion Board for collaboration related to QlikView App Development.
I try to use direct discovery with hive database.
My connection is with Cloudera ODBC driver for apache hive.
The "basic" load is ok:
SQL SELECT *
But with direct query i have this issue:
SQL##f - SqlState: S1000, ErrorCode: 35, ErrorMsg: [Cloudera][HiveODBC] (35) Error from server: error code: '0' error message: 'ExecuteStatement finished with operation state: ERROR_STATE'.
DIMENSION codemode, codenature
I don't know how resolve this...
Do you have the below defined variables in your edit script??
SET DirectCacheSeconds= 15;
SET DirectStringQuoteChar = '"';
SET DirectIdentifierQuoteChar = '';
SET DirectConnectionMax= 4;
SET DirectTableBoxListThreshold= 100000;
Did you solve your problem? Could you access to Hive through direct discovery?
I'm facing similar issue when i connect to hive using Microsoft ODBC for hive from qlik view.
Let me know if you were able to find a solution.
I faced the problem with QlikSense server 2.2.4 . Did you find any solution regarding this ?
I'm facing similar issue when i connect to hive using Microsoft ODBC for hive from qlik Sense.