CREATE [DATABASE | SCHEMA] [IF NOT EXISTS] db_name
  [COMMENT db_comment]
  [WITH DBPROPERTIES (property_name=property_value, ...)];

DROP [DATABASE | SCHEMA] [IF EXISTS] db_name [RESTRICT|CASCADE];

DESCRIBE DATABASE [EXTENDED] db_name;

SHOW [DATABASES | SCHEMAS] [LIKE regex_expression];

CREATE TABLE [IF NOT EXISTS] [db_name.]table_name 
  [(col_name1 col_type1 [COMMENT col_comment1], ...)]
  USING file_format 
  [OPTIONS (path 'obs_path', key1=val1, key2=val2, ...)] 
  [PARTITIONED BY (col_name1, col_name2, ...)]
  [COMMENT table_comment]
  [AS select_statement];

CREATE [EXTERNAL] TABLE [IF NOT EXISTS] [db_name.]table_name 
  [(col_name1 col_type1 [COMMENT col_comment1], ...)]
  [COMMENT table_comment] 
  [PARTITIONED BY (col_name2 col_type2, [COMMENT col_comment2], ...)] 
  [ROW FORMAT row_format]
  [STORED AS file_format] 
  LOCATION 'obs_path'
  [AS select_statement];

row_format:
  : SERDE serde_cls [WITH SERDEPROPERTIES (key1=val1, key2=val2, ...)]
  | DELIMITED [FIELDS TERMINATED BY char [ESCAPED BY char]]
      [COLLECTION ITEMS TERMINATED BY char]
      [MAP KEYS TERMINATED BY char]
      [LINES TERMINATED BY char]
      [NULL DEFINED AS char]

CREATE TABLE [IF NOT EXISTS] [db_name.]table_name 
  [(col_name1 col_type1 [COMMENT col_comment1], ...)]
  USING file_format 
  [OPTIONS (key1=val1, key2=val2, ...)] 
  [PARTITIONED BY (col_name1, col_name2, ...)]
  [COMMENT table_comment]
  [AS select_statement];

CREATE TABLE [IF NOT EXISTS] [db_name.]table_name 
  [(col_name1 col_type1 [COMMENT col_comment1], ...)]
  [COMMENT table_comment] 
  [PARTITIONED BY (col_name2 col_type2, [COMMENT col_comment2], ...)] 
  [ROW FORMAT row_format]
  STORED AS file_format 
  [TBLPROPERTIES (key1=val1, key2=val2, ...)]
  [AS select_statement];

row_format:
  : SERDE serde_cls [WITH SERDEPROPERTIES (key1=val1, key2=val2, ...)]
  | DELIMITED [FIELDS TERMINATED BY char [ESCAPED BY char]]
      [COLLECTION ITEMS TERMINATED BY char]
      [MAP KEYS TERMINATED BY char]
      [LINES TERMINATED BY char]
      [NULL DEFINED AS char]

DROP TABLE [IF EXISTS] [db_name.]table_name;

SHOW TABLES [IN | FROM db_name] [LIKE regex_expression];

SHOW CREATE TABLE table_name;

SHOW TBLPROPERTIES table_name [('property_name')];

SHOW COLUMNS {FROM | IN} table_name [{FROM | IN} db_name];

SHOW PARTITIONS [db_name.]table_name
  [PARTITION partition_specs];

DESCRIBE [EXTENDED|FORMATTED] [db_name.]table_name;

ALTER TABLE [db_name.]table_name ADD COLUMNS (col_name1 col_type1 [COMMENT col_comment1], ...);

ALTER TABLE table_name ADD [IF NOT EXISTS]
  PARTITION partition_specs1
  [LOCATION 'obs_path1']
  PARTITION partition_specs2
  [LOCATION 'obs_path2'];

ALTER TABLE table_name
  PARTITION partition_specs
  RENAME TO PARTITION partition_specs;

ALTER TABLE [db_name.]table_name
  DROP [IF EXISTS]
  PARTITION partition_spec1[,PARTITION partition_spec2,...];

ALTER TABLE table_name
  PARTITION partition_specs
  SET LOCATION obs_path;

ALTER TABLE table_name
 [PARTITION partition_specs]
 SET SERDE serde
 [WITH SERDEPROPERTIES (property_name=property_value,...)];

MSCK REPAIR TABLE table_name;
ALTER TABLE table_name RECOVER PARTITIONS;

LOAD DATA INPATH 'folder_path' INTO TABLE [db_name.]table_name
  OPTIONS(property_name=property_value, ...);

TRUNCATE TABLE tablename [PARTITION (partcol1=val1, partcol2=val2 ...)];

INSERT OVERWRITE DIRECTORY path
  USING file_format
  [OPTIONS(key1=value1)]
  select_statement;

INSERT INTO DLI_TABLE
  SELECT field1,field2...
  [FROM DLI_TEST]
  [WHERE where_condition]
  [LIMIT num]
  [GROUP BY field]
  [ORDER BY field] ...;

SELECT * FROM table_name LIMIT number;

CREATE TABLE [IF NOT EXISTS] UQUERY_OPENTSDB_TABLE_NAME
  USING OPENTSDB OPTIONS (
  'host' = 'xx;xx',
  'metric' = 'METRIC_NAME',
  'tags' = 'TAG1,TAG2');

INSERT INTO TABLE TABLE_NAME SELECT * FROM DLI_TABLE;

INSERT INTO TABLE TABLE_NAME VALUES(XXX);

SELECT * FROM table_name LIMIT number;

CREATE TABLE [IF NOT EXISTS] TABLE_NAME
  USING DWS OPTIONS (
  'url'='xx',
  'dbtable'='db_name_in_DWS.table_name_in_DWS',
  'passwdauth' = 'xxx',
  'encryption' = 'true');

SELECT * FROM table_name LIMIT number;

CREATE TABLE [IF NOT EXISTS] TABLE_NAME
  USING JDBC OPTIONS (
  'url'='xx',
  'driver'='DRIVER_NAME',
  'dbtable'='db_name_in_RDS.table_name_in_RDS',
  'user'='YOUR_RDS_USER_NAME',
  'password'='YOUR_PASS_WORD');

SELECT * FROM table_name LIMIT number;

CREATE TABLE [IF NOT EXISTS] TABLE_NAME(
  FIELDNAME1 FIELDTYPE1,
  FIELDNAME2 FIELDTYPE2)
  USING CSS OPTIONS (
  'es.nodes'='xx',
  'resource'='type_path_in_CSS',
  'pushdown'='true',
  'strict'='false',
  'batch.size.entries'= '1000',
  'batch.size.bytes'= '1mb',
  'es.nodes.wan.only' = 'true',
  'es.mapping.id' = 'FIELDNAME');

SELECT * FROM table_name LIMIT number;

SELECT * FROM table_name LIMIT number;

CREATE TABLE [IF NOT EXISTS] TABLE_NAME(
    FIELDNAME1 FIELDTYPE1,
    FIELDNAME2 FIELDTYPE2)
  USING MONGO OPTIONS (
  'url'='IP:PORT[,IP:PORT]/[DATABASE][.COLLECTION][AUTH_PROPERTIES]',
  'database'='xx',
  'collection'='xx',
  'passwdauth' = 'xxx',
  'encryption' = 'true'
);

SELECT * FROM table_name LIMIT number;

CREATE [OR REPLACE] VIEW view_name AS select_statement;

DROP VIEW [IF EXISTS] [db_name.]view_name;

EXPLAIN [EXTENDED | CODEGEN] statement;

CREATE ROLE [db_name].role_name;

DROP ROLE [db_name].role_name;

GRANT ([db_name].role_name,...) TO (user_name,...);

REVOKE ([db_name].role_name,...) FROM (user_name,...);

SHOW [ALL] ROLES [user_name];

GRANT (privilege,...) ON (resource,..) TO ((ROLE [db_name].role_name) | (USER user_name)),...);

REVOKE (privilege,...) ON (resource,..) FROM ((ROLE [db_name].role_name) | (USER user_name)),...);

SHOW GRANT ((ROLE [db_name].role_name) | (USER user_name)) ON resource;

SHOW PRINCIPALS ROLE;

CREATE [TEMPORARY] FUNCTION [db_name.]function_name AS class_name
  [USING resource,...]

resource: 
  : (JAR|FILE|ARCHIVE)file_uri

DROP [TEMPORARY] FUNCTION [IF EXISTS] [db_name.] function_name;

DESCRIBE FUNCTION [EXTENDED] [db_name.] function_name;

SHOW [USER|SYSTEM|ALL] FUNCTIONS ([LIKE] regex | [db_name.] function_name);