drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "MUFEED USMAN (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1633) Querying A Non-Existent File While Using Wildcard Throws Parsing Error
Date Tue, 04 Nov 2014 11:05:33 GMT
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)

Mime
View raw message