drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Norris Lee (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1130) Leading / in a select query should be rooted from the workspace rather than from the file system
Date Thu, 10 Jul 2014 23:17:04 GMT
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)

Mime
View raw message