drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Arina Ielchiieva (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-4514) Add describe schema <schema_name> command
Date Wed, 15 Jun 2016 09:16:09 GMT

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

Mime
View raw message