[DRILL-601] Need a SHOW FILES query to allow browsing of the file system.

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Assignee: Mehant Baid
• Reporter: Parth Chandra
• Created: 30/Apr/14 01:27
• Updated: 31/Jul/14 06:32
• Resolved: 09/Jun/14 06:49

Description

SHOW FILES [

{FROM | IN}

db_name] [LIKE 'pattern' | WHERE expr]

Where -

db_name is schema name.

pattern is path with wildcards . The wildcard character is ‘%’

where are other conditions.

Example:

SHOW FILES IN dfs.`/myfiles/logs` LIKE 'happy%' WHERE isDirectory = true;

The columns returned are

name VARCHAR
isDirectory BOOLEAN
isFile BOOLEAN
isSymlink BOOLEAN
length BIGINT
owner VARCHAR
group VARCHAR
modificationTime TIMESTAMP
accessTime TIMESTAMP
permissions VARCHAR

The syntax mirrors the show tables command