Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-1656

Multiple wildcards(*) are not supported

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.6.0
    • Fix Version/s: 0.7.0
    • Component/s: Execution - Flow
    • Labels:
      None

      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)
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              haozhu Hao Zhu
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: