Hive SQL 操作示例

1、Create/Drop/Alter Database
CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] database_name
  [COMMENT database_comment]
  [LOCATION hdfs_path]
  [WITH DBPROPERTIES (property_name=property_value, ...)];
ABSTRACT SYNTAX TREE:
  (TOK_CREATEDATABASE db_name)


DROP (DATABASE|SCHEMA) [IF EXISTS] database_name [RESTRICT|CASCADE];
ABSTRACT SYNTAX TREE:
  (TOK_DROPDATABASE db_name TOK_IFEXISTS)




ALTER (DATABASE|SCHEMA) database_name SET DBPROPERTIES (property_name=property_value, ...);   -- (Note: SCHEMA added in Hive 0.14.0)
ALTER (DATABASE|SCHEMA) database_name SET OWNER [USER|ROLE] user_or_role;
hive0.14版本以后才支持


USE database_name
ABSTRACT SYNTAX TREE:
  (TOK_SWITCHDATABASE huanggang)


2、Create/Drop/Truncate Table
CREATE [TEMPORARY] [EXTERNAL] TABLE [IF NOT EXISTS] [db_name.]table_name   -- (Note: TEMPORARY available in Hive 0.14.0 and later)
  [(col_name data_type [COMMENT col_comment], ...)]
  [COMMENT table_comment]
  [PARTITIONED BY (col_name data_type [COMMENT col_comment], ...)]
  [CLUSTERED BY (col_name, col_name, ...) [SORTED BY (col_name [ASC|DESC], ...)] INTO num_buckets BUCKETS]
  [SKEWED BY (col_name, col_name, ...) ON ([(col_value, col_value, ...), ...|col_value, col_value, ...])
     [STORED AS DIRECTORIES]    -- (Note: