MUFEED USMAN created DRILL-1633:
-----------------------------------
Summary: Querying A Non-Existent File While Using Wildcard Throws
Parsing Error
Key: DRILL-1633
URL: https://issues.apache.org/jira/browse/DRILL-1633
Project: Apache Drill
Issue Type: Improvement
Components: Client - JDBC
Affects Versions: 0.7.0
Reporter: MUFEED USMAN
For the content below,
{code}
0: jdbc:drill:zk=n67:5181> show files;
+------------+-------------+------------+------------+------------+------------+-------------+------------+------------------+
| name | isDirectory | isFile | length | owner | group
| permissions | accessTime | modificationTime |
+------------+-------------+------------+------------+------------+------------+-------------+------------+------------------+
| file11.csv | false | true | 8 | root | root
| rwxr-xr-x | 2014-11-04 16:30:01.0 | 2014-11-04 16:30:01.087 |
| blo | true | false | 3 | root | root
| rwxr-xr-x | 2014-11-04 15:11:15.0 | 2014-11-04 15:12:16.421 |
| file1.csv | false | true | 8 | root | root
| rwxr-xr-x | 2014-11-04 16:30:01.0 | 2014-11-04 16:30:01.092 |
| file2.csv | false | true | 8 | root | root
| rwxr-xr-x | 2014-11-04 16:30:01.0 | 2014-11-04 16:30:01.095 |
+------------+-------------+------------+------------+------------+------------+-------------+------------+------------------+
{code}
Error being thrown to the console is misleading.
{code}
0: jdbc:drill:zk=n67:5181> select * from dfs.root.`file1.csv`;
+------------+
| columns |
+------------+
| ["1","2","3","4"] |
+------------+
1 row selected (0.101 seconds)
0: jdbc:drill:zk=n67:5181> select * from dfs.root.`file1*.csv`;
+------------+
| columns |
+------------+
| ["1","2","3","4"] |
| ["1","2","3","4"] |
+------------+
2 rows selected (0.127 seconds)
0: jdbc:drill:zk=n67:5181> select * from dfs.root.`file3*.csv`;
Query failed: Failure while parsing sql.
Error: exception while executing query: Failure while executing query.
(state=,code=0)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
