Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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 *
FROM HIVE.default.exportcopy;
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'.
Direct Query
DIMENSION codemode, codenature
measure
valeur
From HIVE.default.exportcopy
I don't know how resolve this...
Thanks,
Mickaël.
Do you have the below defined variables in your edit script??
SET DirectCacheSeconds= 15;
SET DirectStringQuoteChar = '"';
SET DirectIdentifierQuoteChar = '[]';
SET DirectConnectionMax= 4;
SET DirectTableBoxListThreshold= 100000;
SET DirectDistinctSupport=false;
SET DirectIdentifierQuoteStyle=’ANSI’;
Thanks
Satish
Hi Mickael,
Did you solve your problem? Could you access to Hive through direct discovery?
Thank,
Matteo
Hi Mickael,
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.
Thanks,
Manasa
Hi,
I faced the problem with QlikSense server 2.2.4 . Did you find any solution regarding this ?
Regards,
Vincent
Hi Mickael,
I'm facing similar issue when i connect to hive using Microsoft ODBC for hive from qlik Sense.
Let me know if you were able to find a solution.
Thanks.
Regards
Christophe