drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (DRILL-763) SHOW FILES does not support a period inside a quoted schema name.
Date Mon, 19 May 2014 23:15:40 GMT

     [ https://issues.apache.org/jira/browse/DRILL-763?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jacques Nadeau reassigned DRILL-763:
------------------------------------

    Assignee: Mehant Baid

> SHOW FILES does not support a period inside a quoted schema name.
> -----------------------------------------------------------------
>
>                 Key: DRILL-763
>                 URL: https://issues.apache.org/jira/browse/DRILL-763
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: George Chow
>            Assignee: Mehant Baid
>
> This is an amalgam of DRILL-601 and DRILL-623.
> The three queries below are equivalent but the third form fails.
> {code}
> 0: jdbc:drill:zk=local> show files in dfs.`/opt/drill`;
> +------------+-------------+------------+------------+------------+------------+
> |    name    | isDirectory |   isFile   |   length   |   owner    |   group    |
> +------------+-------------+------------+------------+------------+------------+
> | node-new-maprh | true        | false      | 4096       | root       | root   |
> | node-new-maprh-05-13 | true        | false      | 4096       | root       |  |
> | drillbit.out | false       | true       | 4921       | root       | root     |
> | node-new-maprh-05-14 | true        | false      | 4096       | root       |  |
> | drill-scripts | true        | false      | 4096       | root       | root    |
> | node-new-maprh-05-12 | true        | false      | 4096       | root       |  |
> +------------+-------------+------------+------------+------------+------------+
> 6 rows selected (0.311 seconds)
> 0: jdbc:drill:zk=local> show files in `dfs`.`default`.`/opt/drill`;
> +------------+-------------+------------+------------+------------+------------+
> |    name    | isDirectory |   isFile   |   length   |   owner    |   group    |
> +------------+-------------+------------+------------+------------+------------+
> | node-new-maprh | true        | false      | 4096       | root       | root   |
> | node-new-maprh-05-13 | true        | false      | 4096       | root       |  |
> | drillbit.out | false       | true       | 4921       | root       | root     |
> | node-new-maprh-05-14 | true        | false      | 4096       | root       |  |
> | drill-scripts | true        | false      | 4096       | root       | root    |
> | node-new-maprh-05-12 | true        | false      | 4096       | root       |  |
> +------------+-------------+------------+------------+------------+------------+
> 6 rows selected (0.131 seconds)
> 0: jdbc:drill:zk=local> show files in `dfs.default`.`/opt/drill`;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id:
"477dd971-71bc-4bc0-a1d0-fcea4726526a"
> endpoint {
>   address: "ubuntu"
>   user_port: 31013
>   control_port: 31014
>   data_port: 31015
> }
> error_type: 0
> message: "Failure while parsing sql. < ValidationException:[ Schema not an instance
of file system schema ]"
> ]
> Error: exception while executing query (state=,code=0)
> {code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message