Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

matteoacn
Contributor III
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