本文简单讲一下hive的增删改查操作吧！ come on baby!
1.建表 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], … [constraint_specification])] [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, …) – (Note: Available in Hive 0.10.0 and later)] ON ((col_value, col_value, …), (col_value, col_value, …), …) [STORED AS DIRECTORIES] [ [ROW FORMAT row_format] [STORED AS file_format] | STORED BY ‘storage.handler.class.name’ [WITH SERDEPROPERTIES (…)] – (Note: Available in Hive 0.6.0 and later) ] [LOCATION hdfs_path] [TBLPROPERTIES (property_name=property_value, …)] – (Note: Available in Hive 0.6.0 and later) [AS select_statement]; – (Note: Available in Hive 0.5.0 and later; not supported for external tables)
CREATE [TEMPORARY] [EXTERNAL] TABLE [IF NOT EXISTS] [db_name.]table_name LIKE existing_table_or_view_name [LOCATION hdfs_path];
data_type primitive_type | array_type | map_type | struct_type | union_type – (Note: Available in Hive 0.7.0 and later) primitive_type TINYINT | SMALLINT | INT | BIGINT | BOOLEAN | FLOAT | DOUBLE | DOUBLE PRECISION – (Note: Available in Hive 2.2.0 and later) | STRING | BINARY – (Note: Available in Hive 0.8.0 and later) | TIMESTAMP – (Note: Available in Hive 0.8.0 and later) | DECIMAL – (Note: Available in Hive 0.11.0 and later) | DECIMAL(precision, scale) – (Note: Available in Hive 0.13.0 and later) | DATE – (Note: Available in Hive 0.12.0 and later) | VARCHAR – (Note: Available in Hive 0.12.0 and later) | CHAR – (Note: Available in Hive 0.13.0 and later) array_type ARRAY < data_type > map_type MAP < primitive_type, data_type > struct_type STRUCT < col_name : data_type [COMMENT col_comment], …> union_type UNIONTYPE < data_type, data_type, … > – (Note: Available in Hive 0.7.0 and later) row_format 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] – (Note: Available in Hive 0.13 and later) | SERDE serde_name [WITH SERDEPROPERTIES (property_name=property_value, property_name=property_value, …)] file_format: SEQUENCEFILE | TEXTFILE – (Default, depending on hive.default.fileformat configuration) | RCFILE – (Note: Available in Hive 0.6.0 and later) | ORC – (Note: Available in Hive 0.11.0 and later) | PARQUET – (Note: Available in Hive 0.13.0 and later) | AVRO – (Note: Available in Hive 0.14.0 and later) | JSONFILE – (Note: Available in Hive 4.0.0 and later) | INPUTFORMAT input_format_classname OUTPUTFORMAT output_format_classname constraint_specification: [, PRIMARY KEY (col_name, …) DISABLE NOVALIDATE ] [, CONSTRAINT constraint_name FOREIGN KEY (col_name, …) REFERENCES table_name(col_name, …) DISABLE NOVALIDATE
2.删表 drop table table_name; 3.删分区 alter table table_name drop partition(ds=’’); 4.修改字段类型描述信息 alter table table_name change columns(col int string comment ‘描述信息’); 5.修改数据内容 insert overwrite table table_name select … from tab; 6.新增数据 insert into table table_name select … from tab; 7.查询 select * from table; （这个大家都知道吧，就不废话了）
