Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-3118

add "SHOW TBLPROPERTIES tblname;" and "SHOW COLUMNS (FROM|IN) table_name [(FROM|IN) db_name]" support

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • None
    • 1.1.0
    • SQL
    • None

    Description

      The "SHOW TBLPROPERTIES tblname;" and "SHOW COLUMNS (FROM|IN) table_name [(FROM|IN) db_name]" syntax had been disabled.
      SHOW COLUMNS shows all the columns in a table including partition columns.
      SHOW TBLPROPERTIES shows Table Properties.
      They all describe a hive table.
      spark-sql> SHOW COLUMNS in test;
      SHOW COLUMNS in test;
      java.lang.RuntimeException:
      Unsupported language features in query: SHOW COLUMNS in test
      TOK_SHOWCOLUMNS
      TOK_TABNAME
      test
      spark-sql> SHOW TBLPROPERTIES test;
      SHOW TBLPROPERTIES test;
      java.lang.RuntimeException:
      Unsupported language features in query: SHOW TBLPROPERTIES test
      TOK_SHOW_TBLPROPERTIES
      test

      Attachments

        Activity

          People

            Unassigned Unassigned
            wangxj Wang Xingjie
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 12h
                12h
                Remaining:
                Remaining Estimate - 12h
                12h
                Logged:
                Time Spent - Not Specified
                Not Specified