Re: Right outer join fails

Hi Sudheesh, I've filed a JIRA issue for this(DRILL-4912 ), and linked it to DRILL-1248 Thanks, Kathir On Mon, Sep 26, 2016 at 4:49 PM, Sudheesh Katkam wrote: > Hi Kathir, > > I tried simple

Re: Right outer join fails

Hi Kathir, I tried simple filter conditions with aliases. This query did not return any result: select city[0] as cityalias from dfs.tmp.`data.json` where cityalias = 1; But, this query works fine: select city[0] as cityalias from dfs.tmp.`data.json` where city[0] = 1; So I suppose aliases are

Re: Right outer join fails

Hi Sudheesh, There is another related issue around this. For the same data I've used for DRILL-4890 , below query doesn't return any result (which is supposed to return one row) select city[0] as cityalias from dfs.tmp.`data.json` a join (select

Re: Right outer join fails

​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 Eclipse > and run t

Re: Right outer join fails

Hi Sudheesh, Thanks for checking this out. I do get the same error what you get, when i run Drillbit on my Eclipse and run the same query from WebUI pointing to my local instance, and on top of this error, i do get the "QueryDataBatch was released twice" error as well. But, in drillbit.log of one

Re: Right outer join fails

Hi Kathir, I tried the same query in embedded mode, and I got a different error. java.lang.IndexOutOfBoundsException: index: 0, length: 8 (expected: range(0, 0)) at io.netty.buffer.DrillBuf.checkIndexD(DrillBuf.java:123) at io.netty.buffer.DrillBuf.chk(DrillBuf.java:147) a

Re: Right outer join fails

​Hi, Additional info on this. Array column ('city' in the example) is the issue. 1. When i select the just the first occurrence of the array column, the query works fine select a.name,a.city[0],b.name from dfs.tmp.`data.json` a right join dfs.tmp.`cities.json` b on a.city[0]=b.id Result Jim 1 S