High John, Looks like this might be as simple as including the necessary '.' between 'dfs' and the file location. So your query should be:
select * from dfs.`/user/jmill383/data/newWARCDataset.csv` limit 100; Best, Nathan On Mon, Feb 1, 2016 at 11:12 AM, JOHN MILLER <[email protected]> wrote: > *Greetings* > > > *I am having a problem getting the system to recognize my dfs.root schema > referenced for hadoop. Please advise if u can assist with the > problem....execution results and plugin are below* > > *John M* > > > > > > [Error Id: d5380d42-8838-4d0b-b1b6-f65eb965521d on > localhost.localdomain:31010] (state=,code=0) > 0: jdbc:drill:drillbit=localhost> select * from dfs > `/user/jmill383/data/newWARCDataset.csv` limit 100; > Error: VALIDATION ERROR: From line 1, column 15 to line 1, column 17: Table > 'dfs' not found
