yutoacts commented on a change in pull request #34718: URL: https://github.com/apache/spark/pull/34718#discussion_r759994496
########## File path: docs/sql-ref-syntax-ddl-alter-database.md ########## @@ -21,25 +21,47 @@ license: | ### Description -You can alter metadata associated with a database by setting `DBPROPERTIES`. The specified property -values override any existing value with the same property name. Please note that the usage of -`SCHEMA` and `DATABASE` are interchangeable and one can be used in place of the other. An error message -is issued if the database is not found in the system. This command is mostly used to record the metadata -for a database and may be used for auditing purposes. +`ALTER DATABASE` statement changes the properties or location of a database. Please note that the usage of +`DATABASE`, `SCHEMA` and `NAMESPACE` are interchangeable and one can be used in place of the others. An error message +is issued if the database is not found in the system. -### Syntax +### ALTER PROPERTIES +`ALTER DATABASE SET DBPROPERTIES` statement changes the properties associated with a database. +The specified property values override any existing value with the same property name. +This command is mostly used to record the metadata for a database and may be used for auditing purposes. + +#### Syntax ```sql -ALTER { DATABASE | SCHEMA } database_name - SET DBPROPERTIES ( property_name = property_value [ , ... ] ) +ALTER { DATABASE | SCHEMA | NAMESPACE } database_name + SET { DBPROPERTIES | PROPERTIES } ( property_name = property_value [ , ... ] ) ``` -### Parameters +#### Parameters * **database_name** Specifies the name of the database to be altered. +### ALTER LOCATION +`ALTER DATABASE SET LOCATION` statement changes the default parent-directory where new tables will be added +for a database. Please note that it does not move the contents of the database's current directory to the newly +specified location or change the locations associated with any tables/partitions under the specified database +(available in Hive 3.0.0 and later). Review comment: Thanks for the review. I mentioned the Hive version here because the usability of the `ALTER DATABASE SET LOCATION` command depends on the version of the Hive metastore and it is not available on 2.3.9. I will add the Spark version here (Spark 3.0.0 and later) but I think it's still good for users to write about Hive. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org