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

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

Re: Fetch queries status from drill prompt

There is an open JIRA DRILL-4258 Once that is fixed/implemented you can query from sys.queries or sys.statements to know about all SQL statements that are in different states. Khurram On Fri, Aug 19, 2016 at 4:45 PM, Anup Tiwari