Hi Sorabh, Thanks for your response. I am asking about running queries as Query user and I have enabled user impersonation. But when I am trying to create a table from query user in the path where the query user has full permissions it's not getting created and facing the below error. So I would like to know while creating tables will drill try to create the tables as process user or logged in user ?
Error Message While creating Table: org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: IOException: Mkdirs failed to create /mapr/my.dev.cluster/data/stk/tpcdsParquet/web_returns (exists=false, cwd=file:/usr/local/drill/bin) When I browsed regarding the above error message I found other people got similar kind of error message because of space issue, So I tried to write only few records even then same error is repeating. Please help. Best regards, _________________________ Tilak Surneni -----Original Message----- From: Sorabh Hamirwasia [mailto:[email protected]] Sent: Wednesday, May 30, 2018 12:32 AM To: [email protected] Subject: Re: How to Start Drill Service From Linux Non-root user Hi Surneni, With respect to using the service specific to a particular user other than root, do you mean executing queries as a query user rather than Drill process user ? If yes then you need to enable impersonation for that on Drillbit side [1]. Later when you connect using client tool (like sqlline) provide the username with which you want Drill to execute query using user (like user=testUser) parameter in connection url. [1]: https://drill.apache.org/docs/configuring-user-impersonation/ Thanks, Sorabh ________________________________ From: Surneni Tilak <[email protected]> Sent: Thursday, May 24, 2018 3:01:02 AM To: [email protected] Subject: How to Start Drill Service From Linux Non-root user Hi Team, May I know how to start drill service from a user which should not be root. What are the privileges that a non-root user should fulfill to start drill service. If I start the service as a root user then how to use the service specific to a particular user other than root. Best regards, Tilak
