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

JoshiRamesh — Sat, 09 Oct 2021 07:01:08 GMT

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

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

jAnshula — Thu, 29 Feb 2024 15:47:06 GMT

Hi @JoshiRamesh In your query the Question Mark (?) symbol is this a value for deliveryconstructuid.

Can you put it in double quotes and check if it works for you

Example

SELECT * FROM my_table
WHERE array_contains(my_array_col, "value1")

This query will return all rows from “my_table” where “my_array_col” contains “value1”

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

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

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