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

["Mehant Baid (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mehant Baid updated DRILL-601:
------------------------------

    Attachment: DRILL-601.patch

Updated patch to use TimeStamp vector for modificationTime and accessTime fields

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