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

["Parth Chandra (JIRA)" <ji...@apache.org>]

Parth Chandra created DRILL-601:
-----------------------------------

             Summary: Need a SHOW FILES query to allow browsing of the file system. 
                 Key: DRILL-601
                 URL: https://issues.apache.org/jira/browse/DRILL-601
             Project: Apache Drill
          Issue Type: New Feature
            Reporter: Parth Chandra


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





--
This message was sent by Atlassian JIRA
(v6.2#6252)