Norris Lee created DRILL-1130:
---------------------------------
Summary: Leading / in a select query should be rooted from the
workspace rather than from the file system
Key: DRILL-1130
URL: https://issues.apache.org/jira/browse/DRILL-1130
Project: Apache Drill
Issue Type: Bug
Reporter: Norris Lee
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
{code}
select * from `dfs.optdrill`.`touchstone/integer.json`
or
select * from `dfs.optdrill`.`./touchstone/integer.json`
{code}
then the query runs perfectly fine.
However, if I lead it with just a slash;
{code}
select * from `dfs.optdrill`.`/touchstone/integer.json
{code}
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|https://issues.apache.org/jira/browse/DRILL-879]
--
This message was sent by Atlassian JIRA
(v6.2#6252)
