[DRILL-7004] improve show files functionnality

• Type: Wish
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.15.0
• Component/s: Storage - Other
• Assignee: Unassigned
• Reporter: benj
• Created: 25/Jan/19 15:08
• Updated: 03/Oct/19 07:13

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 ...