[DRILL-4514] Add describe schema <schema_name> command - ASF JIRA

Voters

Watch issue

Watchers

Link

Clone

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: New Feature
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: Future
Fix Version/s: 1.8.0
Component/s: None
Labels:
- doc-impacting

Description

Add describe database <db_name> command which will return directory associated with a database on the fly.

Syntax:
describe database <db_name>
describe schema <schema_name>

Output:

 DESCRIBE SCHEMA dfs.tmp;

+--------+------------+
| schema | properties |
+--------+------------+
| dfs.tmp | {
  "type" : "file",
  "enabled" : true,
  "connection" : "file:///",
  "config" : null,
  "formats" : {
    "psv" : {
      "type" : "text",
      "extensions" : [ "tbl" ],
      "delimiter" : "|"
    },
    "csv" : {
      "type" : "text",
      "extensions" : [ "csv" ],
      "delimiter" : ","
    },
    "tsv" : {
      "type" : "text",
      "extensions" : [ "tsv" ],
      "delimiter" : "\t"
    },
    "parquet" : {
      "type" : "parquet"
    },
    "json" : {
      "type" : "json",
      "extensions" : [ "json" ]
    },
    "avro" : {
      "type" : "avro"
    },
    "sequencefile" : {
      "type" : "sequencefile",
      "extensions" : [ "seq" ]
    },
    "csvh" : {
      "type" : "text",
      "extensions" : [ "csvh" ],
      "extractHeader" : true,
      "delimiter" : ","
    }
  },
  "location" : "/tmp",
  "writable" : true,
  "defaultInputFormat" : null
} |
+--------+------------+