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

Parse DDL command: "DESCRIBE DATABASE" and "ALTER DATABASE SET DBPROPERTIES"

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 2.0.0
    • 2.0.0
    • SQL
    • None

    Description

      Based on the Hive DDL document https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL

      The syntax of DDL command for ALTER DATABASE is

      ALTER (DATABASE|SCHEMA) database_name SET DBPROPERTIES (property_name=property_value, ...)
      

      ALTER DATABASE is to add new (key, value) pairs into DBPROPERTIES

      The syntax of DDL command for DESCRIBE DATABASE is

      DESCRIBE DATABASE [EXTENDED] db_name
      

      DESCRIBE DATABASE shows the name of the database, its comment (if one has been set), and its root location on the filesystem. When extended is true, it also shows the database's properties

      Attachments

        Issue Links

          Activity

            People

              smilegator Xiao Li
              smilegator Xiao Li
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: