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 <[email protected]> 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` > 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 <[email protected]> > 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 <[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 > >
