) - (Note: SCHEMA added in Hive 0.14.0)ĪLTER (DATABASE|SCHEMA) database_name SET OWNER user_or_role - (Note: Hive 0.13.0 and later SCHEMA added in Hive 0.14.0)ĪLTER (DATABASE|SCHEMA) database_name SET LOCATION hdfs_path - (Note: Hive 2.2.1, 2.4.0 and later)ĪLTER (DATABASE|SCHEMA) database_name SET MANAGEDLOCATION hdfs_path - (Note: Hive 4.0.0 and later)
Drop DatabaseĪLTER (DATABASE|SCHEMA) database_name SET DBPROPERTIES (property_name=property_value. REMOTE databases were added in Hive 4.0.0 ( HIVE-24396) for support for Data connectors. It can be used with to have it point to a directory outside the warehouse root directory to have a tenant based common root where quotas and other policies can be set. Its recommended that MANAGEDLOCATION be within so all managed tables have a common root where common governance policies. LOCATION now refers to the default directory for external tables and MANAGEDLOCATION refers to the default directory for managed tables. MANAGEDLOCATION was added to database in Hive 4.0.0 ( HIVE-22995).
The WITH DBPROPERTIES clause was added in Hive 0.7 ( HIVE-1836). CREATE DATABASE was added in Hive 0.6 ( HIVE-675). The uses of SCHEMA and DATABASE are interchangeable – they mean the same thing. ADD, ADMIN, AFTER, ANALYZE, ARCHIVE, ASC, BEFORE, BUCKET, BUCKETS, CASCADE, CHANGE, CLUSTER, CLUSTERED, CLUSTERSTATUS, COLLECTION, COLUMNS, COMMENT, COMPACT, COMPACTIONS, COMPUTE, CONCATENATE, CONTINUE, DATA, DATABASES, DATETIME, DAY, DBPROPERTIES, DEFERRED, DEFINED, DELIMITED, DEPENDENCY, DESC, DIRECTORIES, DIRECTORY, DISABLE, DISTRIBUTE, ELEM_TYPE, ENABLE, ESCAPED, EXCLUSIVE, EXPLAIN, EXPORT, FIELDS, FILE, FILEFORMAT, FIRST, FORMAT, FORMATTED, FUNCTIONS, HOLD_DDLTIME, HOUR, IDXPROPERTIES, IGNORE, INDEX, INDEXES, INPATH, INPUTDRIVER, INPUTFORMAT, ITEMS, JAR, KEYS, KEY_TYPE, LIMIT, LINES, LOAD, LOCATION, LOCK, LOCKS, LOGICAL, LONG, MAPJOIN, MATERIALIZED, METADATA, MINUS, MINUTE, MONTH, MSCK, NOSCAN, NO_DROP, OFFLINE, OPTION, OUTPUTDRIVER, OUTPUTFORMAT, OVERWRITE, OWNER, PARTITIONED, PARTITIONS, PLUS, PRETTY, PRINCIPALS, PROTECTION, PURGE, READ, READONLY, REBUILD, RECORDREADER, RECORDWRITER, REGEXP, RELOAD, RENAME, REPAIR, REPLACE, REPLICATION, RESTRICT, REWRITE, RLIKE, ROLE, ROLES, SCHEMA, SCHEMAS, SECOND, SEMI, SERDE, SERDEPROPERTIES, SERVER, SETS, SHARED, SHOW, SHOW_DATABASE, SKEWED, SORT, SORTED, SSL, STATISTICS, STORED, STREAMTABLE, STRING, STRUCT, TABLES, TBLPROPERTIES, TEMPORARY, TERMINATED, TINYINT, TOUCH, TRANSACTIONS, UNARCHIVE, UNDO, UNIONTYPE, UNLOCK, UNSET, UNSIGNED, URI, USE, UTC, UTCTIMESTAMP, VALUE_TYPE, VIEW, WHILE, YEARĪLL, ALTER, AND, ARRAY, AS, AUTHORIZATION, BETWEEN, BIGINT, BINARY, BOOLEAN, BOTH, BY, CASE, CAST, CHAR, COLUMN, CONF, CREATE, CROSS, CUBE, CURRENT, CURRENT_DATE, CURRENT_TIMESTAMP, CURSOR, DATABASE, DATE, DECIMAL, DELETE, DESCRIBE, DISTINCT, DOUBLE, DROP, ELSE, END, EXCHANGE, EXISTS, EXTENDED, EXTERNAL, FALSE, FETCH, FLOAT, FOLLOWING, FOR, FROM, FULL, FUNCTION, GRANT, GROUP, GROUPING, HAVING, IF, IMPORT, IN, INNER, INSERT, INT, INTERSECT, INTERVAL, INTO, IS, JOIN, LATERAL, LEFT, LESS, LIKE, LOCAL, MACRO, MAP, MORE, NONE, NOT, NULL, OF, ON, OR, ORDER, OUT, OUTER, OVER, PARTIALSCAN, PARTITION, PERCENT, PRECEDING, PRESERVE, PROCEDURE, RANGE, READS, REDUCE, REVOKE, RIGHT, ROLLUP, ROW, ROWS, SELECT, SET, SMALLINT, TABLE, TABLESAMPLE, THEN, TIMESTAMP, TO, TRANSFORM, TRIGGER, TRUE, TRUNCATE, UNBOUNDED, UNION, UNIQUEJOIN, UPDATE, USER, USING, UTC_TMESTAMP, VALUES, VARCHAR, WHEN, WHERE, WINDOW, WITHĪdded: AUTOCOMMIT, ISOLATION, LEVEL, OFFSET, SNAPSHOT, TRANSACTION, WORK, WRITEĪdded: COMMIT, ONLY, REGEXP, RLIKE, ROLLBACK, STARTĪdded: ABORT, KEY, LAST, NORELY, NOVALIDATE, NULLS, RELY, VALIDATEĪdded: CACHE, CONSTRAINT, FOREIGN, PRIMARY, REFERENCESĪdded: DETAIL, DOW, EXPRESSION, OPERATOR, QUARTER, SUMMARY, VECTORIZATION, WEEK, YEARS, MONTHS, WEEKS, DAYS, HOURS, MINUTES, SECONDSĪdded: DAYOFWEEK, EXTRACT, FLOOR, INTEGER, PRECISION, VIEWSĬREATE (DATABASE|SCHEMA) database_name