drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hao Zhu (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1656) Multiple wildcards(*) are not supported
Date Wed, 12 Nov 2014 18:13:33 GMT

    [ https://issues.apache.org/jira/browse/DRILL-1656?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14208372#comment-14208372
] 

Hao Zhu commented on DRILL-1656:
--------------------------------

Fixed in latest build 0.7:
{code}
$ cat git.properties 
#Generated by Git-Commit-Id-Plugin
#Tue Nov 11 23:59:17 EST 2014
git.commit.id.abbrev=1e21045
git.commit.user.email=altekrusejason@gmail.com
git.commit.message.full=Drill-1688\: Complex parquet reader fails to read wide records.\n
git.commit.id=1e21045bfdab8fde8fc7d3d3a4182ddd4d2e41f3
git.commit.message.short=Drill-1688\: Complex parquet reader fails to read wide records.
git.commit.user.name=Jason Altekruse
git.build.user.name=Unknown
git.commit.id.describe=drill-1.0.0-m1-943-g1e21045
git.build.user.email=Unknown
git.branch=1e21045bfdab8fde8fc7d3d3a4182ddd4d2e41f3
git.commit.time=11.11.2014 @ 22\:27\:41 EST
git.build.time=11.11.2014 @ 23\:59\:17 EST
git.remote.origin.url=git\://git.apache.org/incubator-drill
{code}

{code}
0: jdbc:drill:zk=local>  select * from dfs.tmp.`drilltest/abc/201409*`;
+------------+------------+
|  columns   |    dir0    |
+------------+------------+
| ["1","2","3"] | 20140901   |
| ["1","2","3"] | 20140902   |
| ["4","5","6"] | 20140902   |
| ["7","8","9"] | 20140903   |
+------------+------------+
4 rows selected (0.218 seconds)
0: jdbc:drill:zk=local>  select * from dfs.tmp.`drilltest/ab?/201409*`;
+------------+------------+------------+
|  columns   |    dir0    |    dir1    |
+------------+------------+------------+
| ["1","2","3"] | abc        | 20140901   |
| ["1","2","3"] | abc        | 20140902   |
| ["4","5","6"] | abc        | 20140902   |
| ["7","8","9"] | abc        | 20140903   |
+------------+------------+------------+
4 rows selected (0.117 seconds)
0: jdbc:drill:zk=local>  select * from dfs.tmp.`drilltest/ab[b-c]/201409*`;
+------------+------------+
|  columns   |    dir0    |
+------------+------------+
| ["1","2","3"] | 20140901   |
| ["1","2","3"] | 20140902   |
| ["4","5","6"] | 20140902   |
| ["7","8","9"] | 20140903   |
+------------+------------+
4 rows selected (0.088 seconds)
0: jdbc:drill:zk=local>  select * from dfs.tmp.`drill*/ab[b-c]/201409*`;
+------------+------------+------------+------------+
|  columns   |    dir0    |    dir1    |    dir2    |
+------------+------------+------------+------------+
| ["1","2","3"] | drilltest  | abc        | 20140901   |
| ["1","2","3"] | drilltest  | abc        | 20140902   |
| ["4","5","6"] | drilltest  | abc        | 20140902   |
| ["7","8","9"] | drilltest  | abc        | 20140903   |
+------------+------------+------------+------------+
4 rows selected (0.099 seconds)

{code}

> Multiple wildcards(*) are not supported
> ---------------------------------------
>
>                 Key: DRILL-1656
>                 URL: https://issues.apache.org/jira/browse/DRILL-1656
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Flow
>    Affects Versions: 0.6.0
>            Reporter: Hao Zhu
>
> Drill can not query the directories using multiple wild cards.
> eg:
> {code}
> 0: jdbc:drill:> select * from `abc/201409*`;
> +------------+------------+
> |  columns   |    dir0    |
> +------------+------------+
> | ["4","4","4"] | 20140903   |
> | ["3","3","3"] | 20140902   |
> | ["2","2","2"] | 20140901   |
> | ["1","1","1"] | 20140901   |
> +------------+------------+
> 4 rows selected (0.213 seconds)
> 0: jdbc:drill:> select * from `ab*/201409*`;
> Query failed: Failure while parsing sql. Unsupported selection path: /mapr/demo.mapr.com/data/ab*/201409*
[0006b50e-ef6b-475d-8488-2fc237d39517]
> Error: exception while executing query: Failure while trying to get next result batch.
(state=,code=0)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message