topic Re: Cloudera Impala ODBC read failed in QlikView

Cloudera Impala ODBC read failed

Mon, 26 Jan 2026 16:26:21 GMT

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

Re: Cloudera Impala ODBC read failed

rbecher — Fri, 11 Jul 2014 18:55:03 GMT

Hi Venkat,

the Version Compatibility list says for QlikView:

QlikView: 11.2

CDH 4.2+

Impala ODBC 2.5.13

- Ralf

Re: Cloudera Impala ODBC read failed

Fri, 11 Jul 2014 20:59:37 GMT

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

Re: Cloudera Impala ODBC read failed

rbecher — Fri, 11 Jul 2014 21:22:40 GMT

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.

Re: Cloudera Impala ODBC read failed

Mon, 14 Jul 2014 23:08:21 GMT

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

Re: Cloudera Impala ODBC read failed

rbecher — Tue, 15 Jul 2014 10:26:50 GMT

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.

Re: Cloudera Impala ODBC read failed

Tue, 15 Jul 2014 19:33:55 GMT

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

Re: Cloudera Impala ODBC read failed

bertrand_herard — Fri, 12 Dec 2014 14:43:37 GMT

Hi,

where did you find this compability list ?

regards

Re: Cloudera Impala ODBC read failed

rbecher — Fri, 12 Dec 2014 14:49:27 GMT

Cloudera Website...