Hi Sharath, Sorry for the trouble. Could you try after adding the following to your core-site.xml of HDFS on all nodes and restart?
Replace <DrillbitUser> with userName of the user who is running the Drillbit process. <property> <name>hadoop.proxyuser.<DrillbitUser>.hosts</name> <value>*</value> </property> <property> <name>hadoop.proxyuser.<DrillbitUser>.groups</name> <value>*</value> </property> This seems to be a regression from one of the impersonation changes we added in 0.9.0 Thanks Venki On Thu, May 7, 2015 at 4:55 AM, Sharath Akinapally < [email protected]> wrote: > Hi, > > I recently moved drill from 0.8.0 to 0.9.0. Since then, I am unable to > query on json files present in hadoop file system(hdfs). > > I had registered a storage plugin named hadoop in drill. I had all my files > in /user/hadoop in hdfs. > > > But from drill when I query "show files in hadoop.`/user/hadoop/`;" gives > me following error > > Query failed: SYSTEM ERROR: Failure handling SQL. > Error: exception while executing query: Failure while executing query. > (state=,code=0) > > And when I do query "select * from hadoop.`/user/hadoop/donuts.json`;" > gives me the following error > > Query failed: PARSE ERROR: From line 1, column 15 to line 1, column 20: > Table 'hadoop./home/hadoop/donuts.json' not found > > I also noticed that web interface of apache drill(<ip-address>:8047) is > unable to load js and css files. > > Same queries works fine when I use apache drill 0.8.0. > > So are there any extra things I should configure in drill 0.9.0 or am I > missing something? > > It would be great if anyone help me with this issue. > > Thanks, > -- > Regards, > Sharath Akinapally, >
