Re: CTAS AccessControlException

2018-07-03 Thread Divya Gehlot
Thanks Abhishek! Will check and update on it On Mon, 2 Jul 2018 at 23:57, Abhishek Girish wrote: > Hey Divya, > > Here is one way to check if all nodes have the same UID/GID: > > clush -a 'cat /etc/passwd | grep -i user1' > Node1: user1:x:5000:5000::/home/user1:/bin/bash > Node2:

Re: CTAS AccessControlException

2018-07-02 Thread Abhishek Girish
Hey Divya, Here is one way to check if all nodes have the same UID/GID: clush -a 'cat /etc/passwd | grep -i user1' Node1: user1:x:5000:5000::/home/user1:/bin/bash Node2: user1:x:5000:5000::/home/user1:/bin/bash Node3: user1:x:6000:6000::/home/user1:/bin/bash You can update the UID and GID

Re: CTAS AccessControlException

2018-07-02 Thread Divya Gehlot
Hi Abhishek, Thanks for the prompt response ! Yes I have Big Data Cluster and Apache Drill is part of it and security is plain authentication and connected through AD . And Recently I have added 3 more nodes to the cluster. How do I ensure that all the nodes have same UID + GID , which you

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: 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

Re: CTAS AccessControlException

2018-06-30 Thread Kunal Khatua
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 6/29/2018 3:42:17 AM, Divya Gehlot wrote: Hi, At times I am getting error whlile CTAS and it doesn't happen all the time like next run for 18 hours it will

CTAS AccessControlException

2018-06-29 Thread Divya Gehlot
Hi, At times I am getting error whlile CTAS and it doesn't happen all the time like next run for 18 hours it will create the table . Here are the details : ls -ltr /path/to/directory/parquetfiles/2018_06_29 total 9 drwxrwxr-x 2 1 Jun 28 12:05 00 drwxrwxr-x 2 1 Jun 28 13:05 01 Error Logs :