Re: [HANGOUT] [new link] Topics for October 02 2018

2018-10-11 Thread Pritesh Maker
Divya - anyone is welcome to join the hangout! Aman will be sharing the slides shortly. We use Google Hangouts which doesn't have the option to record the session. On Thu, Oct 11, 2018 at 1:06 AM Divya Gehlot wrote: > Can we have the recordings of the talk for the benefit of the other drill >

Re: Failed to create schema tree when running Drill View Query

2018-10-11 Thread Kunal Khatua
There is another possible explanation of why this is happening.  The `createFullRootSchema` seems to be called as part of the initial schema creation required for a query, and that means initialization of the backend storage plugins for the new nodes. You might need to disable some of the

Re: Kafka Plugin in Drill 1.14

2018-10-11 Thread Divya Gehlot
It worked :) Thanks Arina ! On Mon, 8 Oct 2018 at 15:37, Arina Yelchiyeva wrote: > Did you run older Drill versions on Windows before? Bootstap plugins are > loaded when there is no stored plugins configs on your environment. > Check if you have drill/sys.storage_plugins folder on your system.

Re: Failed to create schema tree when running Drill View Query

2018-10-11 Thread Divya Gehlot
Hi Abhishek, Thanks for the response with clarifications ! When I jumped into the logs .. May be I should provide some additional information regarding the Drill cluster before sharing more information what I found in the logs I have 6 nodes cluster where the 3 nodes are old and 3 are newly added

Re: Drill Log file plugin not working in Drill 1.14

2018-10-11 Thread Divya Gehlot
Hi Arina, Just to clarify If I create the pull request it will automatically gets publish to https://drill.apache.org/docs/logfile-plugin/ , there is no need update the docs? Thanks, Divya On Mon, 8 Oct 2018 at 15:40, Arina Yelchiyeva wrote: > Hi Divya, > > You can create PR for docs

Re: ERROR is reading parquet data after create table

2018-10-11 Thread Divya Gehlot
Hi , Can somebody clarify on the number of tasks, What I understood from Herman is if you have 29 parquet files than Drill actually creates 29 tasks . Herman , Can I know you are running drill on embedded mode or distributed mode. I am running Drill in production for multiple sources and I do

Re: ERROR is reading parquet data after create table

2018-10-11 Thread Herman Tan
I am running in single instance embedded mode under windows. On Thu, 11 Oct 2018, 3:26 PM Divya Gehlot, wrote: > Hi , > Can somebody clarify on the number of tasks, What I understood from Herman > is if you have 29 parquet files than Drill actually creates 29 tasks . > > Herman , Can I know you

Performance issue while fetching the latest data in multi directory hierarchy env

2018-10-11 Thread Divya Gehlot
Hi, I have data in below hierarchy Date\ Hour of the day \ 04 08 12 . 60 I used the query like below Select * from `schema_name`.`./path/to/directory/` where dir0 = MAXDIR( `schema_name`.`./path/to/directory/`) and its taking 3-5 minutes

Re: Performance issue while fetching the latest data in multi directory hierarchy env

2018-10-11 Thread Divya Gehlot
apologies on MAXDIR syntax The correct syntax is MAXDIR( 'schema_name','./path/to/directory/') On Thu, 11 Oct 2018 at 15:40, Divya Gehlot wrote: > Hi, > I have data in below hierarchy > Date\ >Hour of the day \ > 04 > 08 > 12 >. > 60

Re: [HANGOUT] [new link] Topics for October 02 2018

2018-10-11 Thread Divya Gehlot
Can we have the recordings of the talk for the benefit of the other drill users in the community or it is a closed affair ? Thanks, Divya On Sat, 29 Sep 2018 at 05:13, Karthikeyan Manivannan wrote: > Hi, > > We will have a Drill Hangout on October 2 2018 at 10 AM Pacific Time. > Please

Drill UDFs doc

2018-10-11 Thread Divya Gehlot
Hi, Can anybody guide me to the page/git hub repo where all the Drill UDFs are available so that users can check it first before writing their own. Appreciate the help ! Thanks, Divya

Re: Drill Log file plugin not working in Drill 1.14

2018-10-11 Thread Arina Yelchiyeva
All PRs first undergo code review, even doc updates. Then PRs are merged by the Apache committer. Kind regards, Arina On Thu, Oct 11, 2018 at 10:17 AM Divya Gehlot wrote: > Hi Arina, > > Just to clarify If I create the pull request it will automatically gets > publish to

Re: Drill UDFs doc

2018-10-11 Thread Arina Yelchiyeva
Build-in functions are located in the java-exec module. Some are generated using freemarker, some are located in the org.apache.drill.exec.store.hive package. Currently to get full list of the UDFs, you need to turn on trace logging and check the logs [1]. The good news, currently Kunal is working