drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kathiresan S <kathiresanselva...@gmail.com>
Subject Array data type in Where Clause
Date Fri, 19 Aug 2016 22:15:05 GMT

We have a json where one of the columns is of type array (of Strings) and
we would like to run a query to get the rows where any of the values in the
array matches the given value.

*(Eg): cities.json*

*Query we would like to run (something like below)*

*select id from cp.`cities.json` where any[city] = 'la'*


*select id from cp.`cities.json` where city contains 'la'*

which is expected to return rows 1,2 & 4

Is there any way we can get this done without using FLATTEN?

Drill version that we use : 1.6.0


  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message