oolmoshe opened a new issue, #12502:
URL: https://github.com/apache/druid/issues/12502
Trying to build a query with an array as a parameter for a IN statement
### Affected Version
0.22.1
### Description
Trying to execute this query using SQL API found that is not allowed to have
an array as a parameter, used in this case to filter with an IN statement:
`"query":"select * from table where param1 IN
(?)","resultFormat":"array","header":true,"context":{"sqlOuterLimit":101},"parameters":[{"type":
"VARCHAR", "value": ["value1","value2","value3"]}]}`
We have try as a VARCHAR because if what we understand in the documentation,
but this is what we got:
`{"error":"Unknown exception","errorMessage":"cannot convert [value1,
value2, value3] (class java.util.ArrayList) to
STRING","errorClass":"java.lang.IllegalArgumentException","host":null}%`
But there aren't a parameter type for ARRAY objects.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
