Re: Array data type in Where Clause

Thanks Andries. On Saturday, August 20, 2016, Andries Engelbrecht wrote: > UDFs should perform similar to native functions, pending on how well they > are written. > > You will likely need a UDF for this requirement, maybe someone else has a > different solution using the existing functions. > >

Re: Array data type in Where Clause

UDFs should perform similar to native functions, pending on how well they are written. You will likely need a UDF for this requirement, maybe someone else has a different solution using the existing functions. --Andries > On Aug 19, 2016, at 4:16 PM, Kathiresan S > wrote: > > Awesome, th

Re: Array data type in Where Clause

Awesome, thanks! This solves my exact match (and wildcard matches) requirements. I also have a requirement to apply standard conditions like <,<=,>,>=, etc. on numbers in an array For eg. I need something like *repeated_contains(array, 5, '>')* and this should return true if the array has any ele

Re: Array data type in Where Clause

Use REPEATED_CONTAINS. http://drill.apache.org/docs/repeated-contains/ --Andries > On Aug 19, 2016, at 3:15 PM, Kathiresan S > wrote: > > Hi, > > We have a json where one of the columns is of type array (of Strings) and > we would like to

Array data type in Where Clause

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