Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue direct discovery with Hive

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.

5 Replies
satishkurra
Specialist II
Specialist II

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

matteogm
Partner - Contributor III
Partner - Contributor III

Hi Mickael,

Did you solve your problem? Could you access to Hive through direct discovery?

Thank,

Matteo

Not applicable
Author

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

Not applicable
Author

Hi,

I faced the problem with QlikSense server 2.2.4 . Did you find any solution regarding this ?

Regards,

Vincent

Not applicable
Author

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