Versions Compared

Old Version 213

changes.mady.by.user Lefty Leverenz

Saved on

compared with

New Version 214

changes.mady.by.user Shannon Ladymon

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Added info on current_database() to Use Database

...

Reserved keywords are permitted as identifiers if you quote them as described in Supporting Quoted Identifiers in Column Names (version 0.13.0 and later, see HIVE-6013). Most of the keywords are reserved through HIVE-6617 in order to reduce the ambiguity in grammar (version 1.2.0 and later). There are two ways if the user still would like to use those reserved keywords as identifiers: (1) use quoted identifiers, (2) set hive.support.sql11.reserved.keywords=false. 

Create/Drop/Alter/Use Database

Create Database

Code Block
CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] database_name
  [COMMENT database_comment]
  [LOCATION hdfs_path]
  [WITH DBPROPERTIES (property_name=property_value, ...)];

...

No other metadata about a database can be changed.  

Use Database

Code Block
languagetext
USE database_name;
USE DEFAULT;

USE sets the current database for all subsequent HiveQL statements. To revert to the default database, use the keyword "default" instead of a database name. To check which database is currently being used: SELECT current_database() (as of Hive 0.13.0).

USE database_name was added in Hive 0.6 (HIVE-675).

...