You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "MUFEED USMAN (JIRA)" <ji...@apache.org> on 2014/11/04 12:08:34 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 ]
MUFEED USMAN updated DRILL-1633:
--------------------------------
Description:
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."
was:
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}
> 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}
> It'd be good to have something like "File does not exist."
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)