Cloudera Impala ODBC read failed

[#1]

I am running a complex query from Qlikview and it fails with message - ODBC read failed.  Same query runs in couple of minutes from Impala-shell on Hadoop cluster. 

Less complex Impala queries are running well from Qlikview.

Any idea how to resolve this?

I am running

Qlikview: 11.20

Impala:  1.3.1-cdh5

ODBC: 2.5.15 downloaded from Cloudera website

Regards,

Venkat Ankam

[rbecher]

Hi Venkat,

the Version Compatibility list says for QlikView:

QlikView: 11.2

CDH 4.2+

Impala ODBC 2.5.13

- Ralf

[#3]

Ralf,

Thanks for your response.  

I have installed the ODBC 2.5.13 and tested it.  But, result is same "ODBC Read Failed".

Any idea how to debug further?

Regards,

Venkat

[rbecher]

I was wrong. On my site only the 32bit Hive ODBC driver v2.5.5 works with Impala. You can use it for Impala with default port 21050.

[#5]

Installed 32bit ODBC and ran into an issue.  My Administrator is able to see to 32Bit ODBC, But I am not able to.  I tried the option of checking "Force 32Bit"

Any idea how a user on Qlikvew access a 32Bit ODBC driver?

Regards,

Venkat

[rbecher]

You did all right by checking Force 32bit. So, this seems to be an installation or user rights policy issue, not a QlikView issue.. You should be able to create and use a 32bit ODBC data source. You can use QlikView menu "Tools" in script editor to get to the 32bit ODBC Admin dialog.

[#7 · Accepted solution]

Ralf,

Finally I got this to working. 

Issue was not with 32 Bit or 64 Bit ODBC driver.  Following two issues were corrected in SQL and all went fine in 64 bit and also 32 bit.

1) There were two column names from  with same name. Added an alias to one column name.

2) I was concatenating two columns.  Added an alias to this one as well. 

Regards,

Venkat Ankam

[bertrand_herard]

Hi,

where did you find this compability list ?

regards

[rbecher]

Cloudera Website...