topic Re: Issue direct discovery with Hive in QlikView

Issue direct discovery with Hive

Thu, 23 Jul 2015 15:02:55 GMT

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.

Re: Issue direct discovery with Hive

satishkurra — Sun, 20 Sep 2015 19:14:07 GMT

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

Re: Issue direct discovery with Hive

matteogm — Thu, 04 Feb 2016 11:12:35 GMT

Hi Mickael,

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

Thank,

Matteo

Re: Issue direct discovery with Hive

Fri, 15 Jul 2016 16:34:05 GMT

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

Re: Issue direct discovery with Hive

Mon, 08 Aug 2016 12:48:19 GMT

Hi,

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

Regards,

Vincent

Re: Issue direct discovery with Hive

Tue, 09 Aug 2016 13:58:44 GMT

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