Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Impala ODBC not returning data when WITH clause in SQL

SOLVED Go to solution

Impala ODBC not returning data when WITH clause in SQL

Contributor

Hi.

 

I've been facing an issue with the Cloudera Impala ODBC Driver when runing a simple query like:

WITH
    totals AS
    (
       SELECT * FROM dual
    )    
SELECT
    *
FROM totals;

 

The dual table contains 1 record only but it always returns no record when connected through ODBC while the the same Query with JDBC connection returns 1 record.

 

Any idea ?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Impala ODBC not returning data when WITH clause in SQL

Contributor

Issuse has been fixed by replacing ODBC version 2.5.22 by 2.5.36

1 REPLY 1
Highlighted

Re: Impala ODBC not returning data when WITH clause in SQL

Contributor

Issuse has been fixed by replacing ODBC version 2.5.22 by 2.5.36