[IMPALA-3690] Query parameters with Impala ODBC driver

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Cannot Reproduce
• Affects Version/s: Kudu_Impala
• Component/s: Clients
• Labels: impala
• Assignee: Syed A. Hashmi
• Reporter: Prasanna
• Created: 07/Jun/16 15:25
• Updated: 15/Aug/16 22:36
• Resolved: 15/Aug/16 22:36

Description

Query parameters with Impala ODBC driver not working
example

OdbcCommand command = DbConnection.CreateCommand();
command.CommandText = "INSERT INTO Test VALUES(?, ?)";
command.Parameters.Add("name", OdbcType.VarChar).Value = "PSUN";
command.Parameters.Add("code", OdbcType.VarChar).Value = "EMP001";
command.ExecuteNonQuery();

when executed getting below error

ERROR [HY000] [Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : AnalysisException: Syntax error in line 1:\n...Test VALUES(?, ?)\n ^\nEncountered: Unexpected character\nExpected: CASE, CAST, EXISTS, FALSE, IF, INTERVAL, NOT, NULL, TRUNCATE, TRUE, IDENTIFIER\n\nCAUSED BY: Exception: Syntax error\n