You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2014/12/29 00:30:13 UTC
[jira] [Updated] (DRILL-1633) Querying A Non-Existent File While
Using Wildcard Throws Parsing Error
[ https://issues.apache.org/jira/browse/DRILL-1633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Nadeau updated DRILL-1633:
----------------------------------
Fix Version/s: Future
> 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
> Fix For: Future
>
>
> 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}
> It'd be good to have something like "File does not exist."
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)