[IMPALA-3149] Bind variable issue in ODBC

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Not A Problem
• Affects Version/s: Impala 2.2, Impala 2.3.0
• Fix Version/s: Not Applicable
• Component/s: Clients
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Jiri Novak
• Created: 07/Mar/16 11:38
• Updated: 15/Nov/18 01:10
• Resolved: 15/Nov/18 01:10

Description

For some reason Cloudera Impal does not recognize bind variable in HAVING clause.
If we execute the following simple query using .Net and ADO.Net

SELECT COUNT(address.address_id) 
, address.country
FROM quest_stage.address address 
GROUP BY address.country 
HAVING (COUNT(address.address_id) > ?)

It returns the following error
Error:

[Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : AnalysisException: Syntax error in line 5:
HAVING (COUNT(address.address_id) > ?)
^
Encountered: Unexpected character
Expected: CASE, CAST, EXISTS, FALSE, IF, INTERVAL, NOT, NULL, TRUE, IDENTIFIER

Bind variable works correctly in WHERE clause. Also the query returns correct result if we use a number instead of the bind variable.