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
Hi,

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*
{"id":"1","city":["nyc","la"]}
{"id":"2","city":["la"]}
{"id":"3","city":["nyc"]}
{"id":"4","city":["la","nyc"]}

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


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

Or

*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

Thanks,
Kathir

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