Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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
Valued Contributor II

Re: Issue direct discovery with Hive

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
New Contributor II

Re: Issue direct discovery with Hive

Hi Mickael,

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

Thank,

Matteo

Not applicable

Re: Issue direct discovery with Hive

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

Re: Issue direct discovery with Hive

Hi,

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

Regards,

Vincent

Not applicable

Re: Issue direct discovery with Hive

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

Community Browser