[
https://issues.apache.org/jira/browse/DRILL-601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mehant Baid updated DRILL-601:
------------------------------
Attachment: (was: DRILL-601.patch)
> 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
> Assignee: Mehant Baid
> Attachments: DRILL-601.patch
>
>
> 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)
