[
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
[email protected]
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)
