Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4514

Add describe schema <schema_name> command

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • Future
    • 1.8.0
    • None

    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
      } |
      +--------+------------+
      

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            arina Arina Ielchiieva
            arina Arina Ielchiieva
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment