Versions Compared

Old Version 103

changes.mady.by.user Lefty Leverenz

Saved on

compared with

New Version 104

changes.mady.by.user Thejas Nair

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: removing schema kewyord from alter-db prop; sql std auth not needed for alter-db set owner

...

Alter Database

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

ALTER DATABASE database_name SET OWNER [USER|ROLE] user_or_role;   (Note: Only available with SQL standard based authorization, Hive 0.13.0 and later)

No other metadata about a database can be changed. The database owner can be changed if SQL standard based authorization is enabled (HIVE-6440). 

Currently the SCHEMA keyword cannot be used as an alternative for DATABASE (see HIVE-6601).

...