[DRILL-1130] Leading / in a select query should be rooted from the workspace rather than from the file system

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Assignee: Steven Phillips
• Reporter: Norris Lee
• Created: 10/Jul/14 23:15
• Updated: 27/Nov/18 10:20
• Resolved: 27/Jul/14 18:51

Description

Lets assume I have a file system with this structure: /opt/drill/touchstone/integer.json
and I have a workspace "optdrill" rooted at /opt/drill
If I execute

select * from `dfs.optdrill`.`touchstone/integer.json`
or
select * from `dfs.optdrill`.`./touchstone/integer.json`

then the query runs perfectly fine.
However, if I lead it with just a slash;

select * from `dfs.optdrill`.`/touchstone/integer.json

Then the query fails because it is looking for the file "/touchstone/integer.json" rather than "/opt/drill/touchstone/integer.json"
The expectation is that it should always be rooted at the schema, which is consistent with the show files fix in DRILL-879

Issue Links

• is related to: DRILL-6863 Drop table is not working if path within workspace starts with '/'