[
https://issues.apache.org/jira/browse/DRILL-1656?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14205102#comment-14205102
]
Jacques Nadeau commented on DRILL-1656:
---------------------------------------
Problem somewhere here in FileSelection:
String[] s = p.toUri().getPath().split("/");
String newPath = StringUtils.join(ArrayUtils.subarray(s, 0, s.length -
1), "/");
Preconditions.checkState(!newPath.contains("*") &&
!newPath.contains("?"), String.format("Unsupported selection path: %s", p));
return new FileSelection(Lists.newArrayList(status), newPath);
> 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
> Assignee: Jacques Nadeau
>
> 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)
