XMLWordPrintableJSON

    Details

      Description

      As part of schema provisioning project, it will be handy for the user to see if table has schema and its content.
      Command syntax:

      describe schema for table dfs.tmp.`text_table`

      By default schema will be output in JSON format (format schema is stored in .drill.schema file):

      {
        "table" : "dfs.tmp.`text_table`",
        "schema" : {
          "columns" : [
            {
              "name" : "id",
              "type" : "INT",
              "mode" : "OPTIONAL"
            }
          ]
        },
        "version" : 1
      }
      

      JSON format can be indicated explicitly:

      describe schema for table dfs.tmp.`text_table` as json

      Other formats:
      STATEMENT - schema will be output in the form of CREATE SCHEMA statement.
      describe schema for table dfs.tmp.`text_table` as statement

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: