topic Re: Getting error while loading data from Impala database in QlikView

Getting error while loading data from Impala database

mayankraoka — Mon, 06 Jun 2016 13:55:36 GMT

Hi Team,

I have installed 32 bit driver for Impala and connection testing it is successful. But getting below error while reloading the app.

SQL##f - SqlState: S1010, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Function sequence error

TEST:

SQL

SELECT 1 FROM brand_dim

Qklikview Version: 11.2 SR12.

Can anyone help me how to resolve the above error?

Regards,

Mayank

Re: Getting error while loading data from Impala database

sunny_talwar — Mon, 06 Jun 2016 14:00:47 GMT

SELECT 1? Is 1 a column name here? or do you want to do SELECT *?

Re: Getting error while loading data from Impala database

mayankraoka — Mon, 06 Jun 2016 14:03:22 GMT

Hi Sunny:

Here is my query:

LOAD `item_id`,

`item_desc`;

SQL SELECT *

FROM IMPALA.`hbase_poc`.`dim_item`;

Regards,

Mayank

Re: Getting error while loading data from Impala database

Clever_Anjos — Mon, 06 Jun 2016 14:06:11 GMT

Please check if

SELECT *

FROM IMPALA.`hbase_poc`.`dim_item`;

returns item_id and item_desc, remembering that QV is case sensitive

Try this too

LOAD item_id,

item_desc;

SQL SELECT

item_id,

item_desc

FROM IMPALA.`hbase_poc`.`dim_item`;

Re: Getting error while loading data from Impala database

crusader_ — Mon, 06 Jun 2016 14:09:03 GMT

Hi,

Have you tried to retrieve data by another tool?

Also check your Impala driver version...

Do you have enough privileges to execute this query?

Have you tried to

SQL SELECT

`item_id`,

`item_desc`

FROM IMPALA.`hbase_poc`.`dim_item`; ?

Andrei

Re: Getting error while loading data from Impala database

mayankraoka — Tue, 07 Jun 2016 07:12:58 GMT

Hi Clever,

Checked this query is working fine in database.

The query you mentioned is again failed with the same error.

Regards,

Mayank

Re: Getting error while loading data from Impala database

mayankraoka — Tue, 07 Jun 2016 07:14:16 GMT

Hi Andrei,

Thanks for your reply.

The query you mentioned is also giving me the same error.The same query is working fine with qlikview version 12.

The version of Impala driver is v2.5.28.1008(32bit)

Regards,

Mayank

Re: Getting error while loading data from Impala database

crusader_ — Tue, 07 Jun 2016 08:26:04 GMT

Hi Mayank,

Sorry for stupid question but have you checked "Force 32 bit" while creating ODBC connection string?

/Andrei

Re: Getting error while loading data from Impala database

mayankraoka — Tue, 07 Jun 2016 08:31:50 GMT

Yes I have checked force 32 bit.

Re: Getting error while loading data from Impala database

awhitfield — Tue, 07 Jun 2016 11:07:15 GMT

Hi Mayank,

have you checked out the following thread?

https://groups.google.com/a/cloudera.org/forum/#!topic/impala-user/alL7-tr-Wmw

It seems to refer to the same issue

Andy

Re: Getting error while loading data from Impala database

mayankraoka — Tue, 07 Jun 2016 12:48:37 GMT

Hi Andrew,

I saw that link But the solution is still not provided over there as well.

Regards,

Mayank

Re: Getting error while loading data from Impala database

mayankraoka — Tue, 07 Jun 2016 12:56:28 GMT

Hi Guys,

It seems my issue is resolved Now.I have Installed different driver and it is working.

Thanks all for your support and time.

Regards,

Mayank