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

improve show files functionnality

    XMLWordPrintableJSON

    Details

    • Type: Wish
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.15.0
    • Fix Version/s: None
    • Component/s: Storage - Other
    • Labels:
      None

      Description

      For instant, it's possible to show files/directories in a particular directory with the command

      SHOW files FROM tmp.`mypath`;
      

      It would be certainly very useful to improve this functionality with :

      • possibility to list recursively
      • possibility to use at least wildcard
        SHOW files FROM tmp.`mypath/*/test/*/*a*`;
        
      • possibility to use the result like a table
        SELECT p.* FROM (SHOW files FROM tmp.`mypath`) AS p WHERE ...
        

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              benj641 benj
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: