Re: Right outer join fails

2016-09-28 Thread Kathiresan S
makes it return no > result. > > > > Any idea, is this a known issue (is there any JIRA issue already tracked > > for this) or should a separate JIRA issue be filed for this? > > > > *Files used for testing:* > > > > *Json file 1: data.json* > > > > { &

Re: Right outer join fails

2016-09-21 Thread Kathiresan S
son file 2: cities.json* {id:1,name:"Sendurai"} {id:2,name:"NYC"} Thanks, Kathir On Wed, Sep 14, 2016 at 8:23 AM, Kathiresan S wrote: > ​Hi Sudheesh, > > I've filed a JIRA for this > > https://issues.apache.org/jira/browse/DRILL-4890​ > > Thanks,

Re: Right outer join fails

2016-09-14 Thread Kathiresan S
​Hi Sudheesh, I've filed a JIRA for this https://issues.apache.org/jira/browse/DRILL-4890​ Thanks, Kathir On Wed, Sep 14, 2016 at 8:09 AM, Kathiresan S wrote: > Hi Sudheesh, > > Thanks for checking this out. > I do get the same error what you get, when i run Drillbit on my

Re: Right outer join fails

2016-09-14 Thread Kathiresan S
; I am not aware of any workarounds; this seems like a bug to me. Can you > open a ticket <https://issues.apache.org/jira/browse/DRILL>? > > Thank you, > Sudheesh > > > On Sep 13, 2016, at 7:10 AM, Kathiresan S > wrote: > > > > ​Hi, > > > > Add

Re: Right outer join fails

2016-09-13 Thread Kathiresan S
around for this issue would be highly appreciated Thanks, Kathir ​ On Sat, Sep 10, 2016 at 9:56 PM, Kathiresan S wrote: > Hi, A Query with right outer join fails while the inner and left outer > joins work for the same data. I've replicated the issue with some simple > data here

Right outer join fails

2016-09-10 Thread Kathiresan S
Hi, A Query with right outer join fails while the inner and left outer joins work for the same data. I've replicated the issue with some simple data here and this happens in both 1.6.0 and 1.8.0 *Json file 1: data.json* { "name": "Jim","city" : [1,2]} *Json file 2: cities.json* {id:1,name:"Sen

Re: Array data type in Where Clause

2016-08-21 Thread Kathiresan S
sting functions. > > --Andries > > > > > > On Aug 19, 2016, at 4:16 PM, Kathiresan S > wrote: > > > > Awesome, thanks! This solves my exact match (and wildcard matches) > > requirements. > > > > I also have a requirement to apply standard con

Re: Array data type in Where Clause

2016-08-19 Thread Kathiresan S
> Use REPEATED_CONTAINS. > http://drill.apache.org/docs/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

Array data type in Where Clause

2016-08-19 Thread Kathiresan S
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",

Drill Physical Plan

2016-06-25 Thread Kathiresan S
Hi, I'm trying out drill (1.6.0) over a custom storage (based on cassandra). I've implemented/extended below and the simple select queries (involving one table) started working fine (I've referred the patch available in DRILL-92 as well) AbstractSchema AbstractGroupScan StoragePluginOptimizerRule