Need help in Apache Drill

2018-07-01 Thread dony.natrajan
Hi there, Hope you're doing good. I need suggestion on performance issues which I'm facing in Apache Drill. Apache Drill version - 1.12.0 DB - MongoDB Details: 1. For us, it took 9.530 seconds for 1 M records within Apache Drill. 2. Hence, the response time to load

Re: unit tests

2018-07-01 Thread Padma Penumarthy
turned out to be a firewall issue. Thanks everyone for all the suggestions and help. Thanks Padma On Sun, Jul 1, 2018 at 3:27 PM, Padma Penumarthy wrote: > Already tried that with no luck. > > Thanks > Padma > > > > On Sun, Jul 1, 2018 at 3:21 PM, Vitalii Diravka > wrote: > >> Hi Padma, >>

Default schema error

2018-07-01 Thread Divya Gehlot
Hi, I am getting a default schema error Error: VALIDATION ERROR: Schema [.default] is not valid with respect to either root schema or current default schema. Current default schema: No default schema selected [Error Id: 9bea38af-6a82-4d71-a937-25169905fcac on :31010] (state=,code=0) All of

Re: CTAS AccessControlException

2018-07-01 Thread Abhishek Girish
Hey Divya, I have a suspicion: There is chance you have a distributed Drill environment and not all of the nodes have the same user (with same UID + GID). And your dataset isn't large like you mentioned, so not all Drillbits are always involved in the query execution. So you might intermittently

Re: CTAS AccessControlException

2018-07-01 Thread Divya Gehlot
Hi, When I checked the error in Profile section of the ran query : Apache Drill "error": "SYSTEM ERROR: Drill Remote Exception\n\n", "verboseError": "SYSTEM ERROR: Drill Remote Exception\n\n\n\n", When I turned on Verbose true I could see the below error when I run the query :

Re: unit tests

2018-07-01 Thread Padma Penumarthy
Already tried that with no luck. Thanks Padma On Sun, Jul 1, 2018 at 3:21 PM, Vitalii Diravka wrote: > Hi Padma, > > Looks like you have wrong some hostname or ip in your /etc/hosts. > Please find out more here [1], Sorabh has already answered a similar > question :) > > [1] >

Re: unit tests

2018-07-01 Thread Vitalii Diravka
Hi Padma, Looks like you have wrong some hostname or ip in your /etc/hosts. Please find out more here [1], Sorabh has already answered a similar question :) [1] https://lists.apache.org/thread.html/%3che1pr07mb33068e59f257a4d78f29304d84...@he1pr07mb3306.eurprd07.prod.outlook.com%3E Kind regards

unit tests

2018-07-01 Thread Padma Penumarthy
I am getting the following error while trying to run unit tests on my mac. Anyone has any idea what might be wrong ? 15:02:01.479 [Client-1] ERROR o.a.d.e.rpc.ConnectionMultiListener - Failed to establish connection java.util.concurrent.ExecutionException:

Re: CTAS AccessControlException

2018-07-01 Thread Divya Gehlot
Hi , The data is not huge it hardly takes a minute to create the table . Thanks , Divya On Sat, 30 Jun 2018 at 3:17 PM, Kunal Khatua wrote: > What is the entire stack trace? I'm wonderinf if there is an internal > timeout that is occuring for long running CTAS in a secure setup. > > On