SHOW FILES

The SHOW FILES command provides a quick report of the file systems that are visible to Drill for query purposes. This command is unique to Apache Drill. Starting in Drill 1.15, the INFORMATION_SCHEMA includes a FILES table that you can query. See Querying the INFORMATION_SCHEMA.

Syntax

The SHOW FILES command supports the following syntax.

SHOW FILES [ FROM filesystem.directory_name | IN filesystem.directory_name ];

The FROM or IN clause is required if you do not specify a default file system first. You can do this with the USE command. FROM and IN are synonyms.

The directory name is optional. (If the directory name is a Drill reserved word, you must use back ticks around the name.)

The command returns standard Linux stat information for each file or directory, such as permissions, owner, and group values. This information is not specific to Drill.

Examples

The following example returns information about directories and files in the local (dfs) file system.

0: jdbc:drill:> use dfs;

|------|---------------------------------|
| ok   | summary                         |
|------|---------------------------------|
| true | Default schema changed to 'dfs' |
|------|---------------------------------|
1 row selected (0.318 seconds)

0: jdbc:drill:> show files;
|------------|-------------|--------|--------|-------|-------|-------------|-----------------------|-------------------------|
| name       | isDirectory | isFile | length | owner | group | permissions | accessTime            | modificationTime        |
|------------|-------------|--------|--------|-------|-------|-------------|-----------------------|-------------------------|
| user       | true        | false  | 1      | abcd  | abcd  | rwxr-xr-x   | 2014-07-30 21:37:06.0 | 2014-07-31 22:15:53.193 |
| backup.tgz | false       | true   | 36272  | root  | root  | rw-r--r--   | 2014-07-31 22:09:13.0 | 2014-07-31 22:09:13.211 |
| JSON       | true        | false  | 1      | root  | root  | rwxr-xr-x   | 2014-07-31 15:22:42.0 | 2014-08-04 15:43:07.083 |
| scripts    | true        | false  | 3      | root  | root  | rwxr-xr-x   | 2014-07-31 22:10:51.0 | 2014-08-04 18:23:09.236 |
| temp       | true        | false  | 2      | root  | root  | rwxr-xr-x   | 2014-08-01 20:07:37.0 | 2014-08-01 20:09:42.595 |
| hbase      | true        | false  | 10     | abcd  | abcd  | rwxr-xr-x   | 2014-07-30 21:36:08.0 | 2014-08-04 18:31:13.778 |
| tables     | true        | false  | 0      | root  | root  | rwxrwxrwx   | 2014-07-31 22:14:35.0 | 2014-08-04 15:42:43.415 |
| CSV        | true        | false  | 4      | root  | root  | rwxrwxrwx   | 2014-07-31 17:34:53.0 | 2014-08-04
...

The following example shows the files in a specific directory in the dfs file system:

0: jdbc:drill:> show files in dfs.CSV;

|--------------------|-------------|--------|--------|-------|-------|-------------|-----------------------|-------------------------|
| name               | isDirectory | isFile | length | owner | group | permissions | accessTime            | modificationTime        |
|--------------------|-------------|--------|--------|-------|-------|-------------|-----------------------|-------------------------|
| customers.csv      | false       | true   | 62011  | root  | root  | rw-r--r--   | 2014-08-04 18:30:39.0 | 2014-08-04 18:30:39.314 |
| products.csv.small | false       | true   | 34972  | root  | root  | rw-r--r--   | 2014-07-31 23:58:42.0 | 2014-07-31 23:59:16.849 |
| products.csv       | false       | true   | 34972  | root  | root  | rw-r--r--   | 2014-08-01 06:39:34.0 | 2014-08-04 15:58:09.325 |
| products.csv.bad   | false       | true   | 62307  | root  | root  | rw-r--r--   | 2014-08-04 15:58:02.0 | 2014-08-04 15:58:02.612 |
|--------------------|-------------|--------|--------|-------|-------|-------------|-----------------------|-------------------------|
4 rows selected (0.165 seconds)