If it's a multi node drillbit cluster, do you have this path/mount available on all drillbit nodes ?
Get Outlook for Android<https://aka.ms/ghei36> From: Surneni Tilak Sent: Thursday, May 31, 7:06 AM Subject: RE: How to Start Drill Service From Linux Non-root user To: [email protected] I am able to create table in tmp work space. Best regards, _________________________ Tilak Surneni -----Original Message----- From: Divya Gehlot [mailto:[email protected]] Sent: Thursday, May 31, 2018 3:58 PM To: [email protected] Subject: Re: How to Start Drill Service From Linux Non-root user can you try creating table in tmp workspace ? On 31 May 2018 at 20:51, Surneni Tilak wrote: > Hi Divya, > > I am getting below error message. > > org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: > IOException: Mkdirs failed to create /mapr/nscprod01.ericsson.com/ > NSC-TEST/stk/tpcdsView/web_returns (exists=false, > cwd=file:/usr/local/drill/bin) > > > Best regards, > _________________________ > Tilak Surneni > > -----Original Message----- > From: Divya Gehlot [mailto:[email protected]] > Sent: Thursday, May 31, 2018 12:45 PM > To: [email protected] > Subject: Re: How to Start Drill Service From Linux Non-root user > > It worked for me as I am also non root user and login drill through AD . > And able to write whereever I would like to on data disk just to need > give permission to that directory . > It’s sounds strange that it doesn’t work for you . > > Thanks, > Divya > > On Thu, 31 May 2018 at 6:03 PM, Surneni Tilak > > wrote: > > > Hi Divya, > > > > I am writing to local file system, So I should use file:/// ; But I > > tried the option that you have mentioned it's not working. > > > > > > > > Best regards, > > _________________________ > > Tilak Surneni > > > > -----Original Message----- > > From: Divya Gehlot [mailto:[email protected]] > > Sent: Thursday, May 31, 2018 11:15 AM > > To: [email protected] > > Subject: Re: How to Start Drill Service From Linux Non-root user > > > > From the plugin information it looks like you are using mapr cluster . > > Can you change below : > > "connection": "maprfs:///", > > > > Everything else looks good. > > > > > > Thanks, > > Divya > > > > > > On 31 May 2018 at 16:42, Surneni Tilak > wrote: > > > > > Hi Sorabh, > > > > > > Please find the attached storage plugin information. I am changing > > > my workspace correctly which I have verified from web UI before > > > running my query. > > > I am using the workspace tpcdsView as mentioned in the storage > > > plugin; where I would like to create the table and the Query user > > > has write permissions to this path. Here I am trying to write to > > > NFS > mount path. > > > > > > Query that I am running: > > > > > > create table stk.tpcdsView.`web_returns` as select * from > > > stk.`/mapr/ > > > nscprod01.ericsson.com/NSC-TEST/stk/tpcdsView/web_returns_csv1000` > > > v1 > > 000> > > > limit 20; > > > > > > Best regards, > > > _________________________ > > > Tilak Surneni > > > > > > > > > -----Original Message----- > > > From: Sorabh Hamirwasia [mailto:[email protected]] > > > Sent: Wednesday, May 30, 2018 10:47 PM > > > To: [email protected] > > > Subject: Re: How to Start Drill Service From Linux Non-root user > > > > > > Hi Surneni, > > > > > > Can you please share few informations: > > > > > > 1) Please share the query and filesystem storage plugin configuration. > > > > > > 2) What is your current workspace while executing the query ? > > > > > > > > > Thanks, > > > Sorabh > > > > > > ________________________________ > > > From: Surneni Tilak > > > Sent: Wednesday, May 30, 2018 2:05:22 AM > > > To: [email protected] > > > Subject: RE: How to Start Drill Service From Linux Non-root user > > > > > > 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://urldefense.proofpoint.com/v2/url?u=https-3A__drill. > > > apache.org_docs_configuring-2Duser-2Dimpersonation_&d=DwIFAg&c= > > > cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOt > > > hF2jlYxvhTlQg&m=VrfIufa_MkFm_STgyQ6vmPg4Q2t7qg5XJAbl0P81aEc&s= > > > TDtmyeNYPwL2neemZUvA5egF9btnkoH5_jJUoqfu7zQ&e= > > > > > > > > > > > > Thanks, > > > Sorabh > > > > > > ________________________________ > > > From: Surneni Tilak > > > 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 > > > > > > > > >
