Impala ODBC not returning data when WITH clause in SQL

MasterOfPuppets — Fri, 16 Sep 2022 11:07:56 GMT

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 ?

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

MasterOfPuppets — Wed, 22 Feb 2017 14:51:08 GMT

Issuse has been fixed by replacing ODBC version 2.5.22 by 2.5.36

question Re: Impala ODBC not returning data when WITH clause in SQL in Archives of Support Questions (Read Only)

Impala ODBC not returning data when WITH clause in SQL

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