You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2014/07/27 20:51:46 UTC

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

    [ https://issues.apache.org/jira/browse/DRILL-1130?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14075702#comment-14075702 ] 

Jacques Nadeau commented on DRILL-1130:
---------------------------------------

Fixed by caa8b78 or earlier.

> 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)