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

Add describe schema <schema_name> command

    XMLWordPrintableJSON

    Details

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

      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

            People

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

              Dates

              • Created:
                Updated:
                Resolved: