Presto: not support "in array"

Created on 27 Apr 2018  路  1Comment  路  Source: prestodb/presto

select id from table where id in array[1,2,3];

mismatched input 'in' expecting {<EOF>, 'AND', 'EXCEPT', 'GROUP', 'HAVING', 'INTERSECT', 'LIMIT', 'OR', 'ORDER', 'UNION'}

picture sjhmt

Most helpful comment

Hi, @UPEMPEROR.
You can rewrite a query with func contains.
https://prestodb.io/docs/current/functions/array.html

Select id from table where contains(ARRAY[1,2,3], id) ;
picture yuokada on 4 May 2018
👍3

>All comments

Hi, @UPEMPEROR.
You can rewrite a query with func contains.
https://prestodb.io/docs/current/functions/array.html

Select id from table where contains(ARRAY[1,2,3], id) ;
yuokada picture yuokada on 4 May 2018
👍3
Was this page helpful?
0 / 5 - 0 ratings

Related issues

aminalaee picture aminalaee  路  3Comments
KishorBaindoor picture KishorBaindoor  路  3Comments
aandis picture aandis  路  4Comments
haozhun picture haozhun  路  4Comments
yaxxie picture yaxxie  路  4Comments