[
https://issues.apache.org/jira/browse/DRILL-1130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau resolved DRILL-1130.
-----------------------------------
Resolution: Fixed
> 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
> Assignee: Steven Phillips
> Fix For: 0.4.0
>
>
> 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)
