George Chow created DRILL-763:
---------------------------------
Summary: 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
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)
