Hive常用的命令有哪些？

#将查询的结果导出到本地
insert overwrite local directory '/export/servers/exporthive' select * from score;
#将查询的结果格式化导出到本地：
insert overwrite local directory '/export/servers/exporthive' row format delimited fields terminated by '\t' collection items terminated by '#' select * from student;
#将查询的结果导出到HDFS上(没有local)：
insert overwrite directory '/export/servers/exporthive' row format delimited fields terminated by '\t' collection items terminated by '#' select * from score;
#export导出到HDFS上
export table score to '/export/exporthive/score';

#直接向分区表中插入数据：
insert into table score partition(month ='202107') values ('001','002','100');
#通过load方式加载数据：
load data local inpath '/export/servers/hivedatas/score.csv' overwrite into table score partition(month='201806');
#通过查询方式加载数据：
insert overwrite table score2 partition(month = '202106') select s_id,c_id,s_score from score1;
#查询语句中创建表并加载数据：
create table score2 as select * from score1;
#在创建表是通过location指定加载数据的路径：
create external table score6 (s_id string,c_id string,s_score int) row format delimited fields terminated by ',' location '/myscore';
#export导出与import 导入 hive表数据
create table techer2 like techer; --依据已有表结构创建表
export table techer to '/export/techer';
import table techer2 from '/export/techer';

truncate table score6;

drop table score5;

drop database myhive2 cascade;

drop database myhive2;

alter table table_name add partition (dt='2021-11-30');

alter table table_name drop partition(dt='2021-11-30');

alter table table_name change old_column new_column string comment 'comm_text';

alter table table_name add columns(columns_values bigint comment 'comm_text');

create table new_table_name like table_name;

alter table old_table_name rename to new_table_name;

#字段分隔符：
row format delimited fields terminated by '\t'
#行分隔符：
row format delimited lines terminated by '\n'
#文件格式为文本型存储：
stored as textfile

insert overwrite local directory '/tmp/text' select a.* from table_name a order by 1;

insert overwrite table table_name partition(dt) select * from table_name;

load data local inpath '/xxx/test.txt' overwrite into table dm.table_name;

show partitions table_name;

desc table_name;

show tables like '*name*';