[
https://issues.apache.org/jira/browse/DRILL-763?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mehant Baid updated DRILL-763:
------------------------------
Attachment: DRILL-763.patch
> 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
> Attachments: DRILL-763.patch
>
>
> 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)
