[DRILL-1656] Multiple wildcards(*) are not supported

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.6.0
• Fix Version/s: 0.7.0
• Component/s: Execution - Flow
• Assignee: Unassigned
• Reporter: Hao Zhu
• Created: 07/Nov/14 02:37
• Updated: 09/Dec/14 17:47
• Resolved: 12/Nov/14 04:14

Description

Drill can not query the directories using multiple wild cards.
eg:

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)