Re: Performace issue

Thnks a lot Kunal. I am looking into that. I have one observation. With out flatten also, i tried to run a query of size 5MB, it is taking 5GB of heap? how do i control heap? Are there any settings i can modify. i am reading a lot, but nothing is working for me. It would be helpful how to control

Re: Performace issue

This is a good starting point for understanding LATERAL-UNNEST and how it compares to the FLATTEN operator. https://drill.apache.org/docs/lateral-join/ On 2/11/2019 9:03:42 PM, PRAVEEN DEVERACHETTY wrote: Thanks Kunal. i am not getting how to use lateral-unrest as dataset does not have child r

Re: Performace issue

Thanks Kunal. i am not getting how to use lateral-unrest as dataset does not have child rows. All data is in array of json objects(as mentioned below). There are two json objects separated by comma and enclosed in squre bracket. [{"Location":"100","FirstName":"test1"},{"Location":"100","FirstName":

Re: Slack workspace for Drill discussions

I found a way to create an invite link which is open to all and never expires. Once we decide on the workspace, we can probably add it to

Re: Slack workspace for Drill discussions

Sent from my iPhone > On Feb 11, 2019, at 18:30, Abhishek Girish wrote: > > Hey folks, > > There have been some questions on a Slack workspace for Drill - it's > popular for multiple open source projects and I think we should encourage > active participation as well. The previous Slac

Slack workspace for Drill discussions

Hey folks, There have been some questions on a Slack workspace for Drill - it's popular for multiple open source projects and I think we should encourage active participation as well. The previous Slack workspace for Apache Drill has been idle for ~3 years and we've been unable to invite new users

Re: How to add an index

Thanks for the reply. Currently the json files (dfs plugin) doesn't support usage of indexes. Thanks, On Sun, Feb 10, 2019 at 12:58 PM Krishnanand Khambadkone wrote: > I am querying raw json files directly from the file system (dfs) > > Sent from my iPhone > > > On Feb 10, 2019, at 12:19 PM, ha