Support Questions
Find answers, ask questions, and share your expertise

ERROR [42000] [Hortonworks][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query

New Contributor

C#- i am using below parameterized query for getting the data from hive

Query- select * from builds_changelogs where array_contains(deliveryconstructuid,?)

Parameter-

OdbcParameter paramdc = new OdbcParameter("@deliveryconstructuid", OdbcType.NVarChar);
paramdc.Value = "1E4272C7D9E64DF8B3DADA3D056F35A1";

 

When i am executing the query it is throwing below error-

ERROR [42000] [Hortonworks][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: ParseException line 1:48 cannot recognize input near '?' 'and' 'array_contains' in expression specification

 

 

 

0 REPLIES 0