Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cloudera Impala ODBC read failed

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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

8 Replies
rbecher
MVP
MVP

Hi Venkat,

the Version Compatibility list says for QlikView:

QlikView: 11.2

CDH 4.2+

Impala ODBC 2.5.13


- Ralf

Astrato.io Head of R&D
Not applicable
Author

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
MVP
MVP

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.

Astrato.io Head of R&D
Not applicable
Author

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
MVP
MVP

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.

Astrato.io Head of R&D
Not applicable
Author

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
Partner - Contributor III
Partner - Contributor III

Hi,

where did you find this compability list ?

regards

rbecher
MVP
MVP

Cloudera Website...

Astrato.io Head of R&D