Getting error while loading data from Impala database

[mayankraoka]

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

[sunny_talwar]

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

[mayankraoka]

Hi Sunny:

Here is my query:

LOAD `item_id`,

    `item_desc`;

SQL SELECT *

FROM IMPALA.`hbase_poc`.`dim_item`;

Regards,

Mayank

[Clever_Anjos]

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`;

[crusader_]

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

[mayankraoka]

Hi Clever,

Checked this query is working fine in database.

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

Regards,

Mayank

[mayankraoka]

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

[crusader_]

Hi Mayank,

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

/Andrei

[mayankraoka]

Yes I have checked force 32 bit.

[awhitfield]

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