[
https://issues.apache.org/jira/browse/DRILL-4514?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arina Ielchiieva updated DRILL-4514:
------------------------------------
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:
{code:sql}
DESCRIBE SCHEMA dfs.tmp;
{code}
{noformat}
+------------+
| properties |
+------------+
| {
"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
} |
+------------+
{noformat}
Current implementation covers only dfs schema.
For all other "<INFORMATION UNAVAILABLE>" will be returned.
was:
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:
{noformat}
DESCRIBE SCHEMA xdf.proc;
+---------------------+----------------------------+
| name | location |
+---------------------+----------------------------+
| xdf.proc | maprfs://dl.data/processed |
+---------------------+----------------------------+
{noformat}
Current implementation covers only dfs schema.
For all other "<INFORMATION UNAVAILABLE>" will be returned.
> Add describe schema <schema_name> command
> -----------------------------------------
>
> Key: DRILL-4514
> URL: https://issues.apache.org/jira/browse/DRILL-4514
> Project: Apache Drill
> Issue Type: New Feature
> Affects Versions: Future
> Reporter: Arina Ielchiieva
> Assignee: Arina Ielchiieva
>
> 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:
> {code:sql}
> DESCRIBE SCHEMA dfs.tmp;
> {code}
> {noformat}
> +------------+
> | properties |
> +------------+
> | {
> "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
> } |
> +------------+
> {noformat}
> Current implementation covers only dfs schema.
> For all other "<INFORMATION UNAVAILABLE>" will be returned.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
