鸿爸爸

#!/bin/bashbizdate=$1for (( i = 0;i < 10;i ++ )) ; do hour="0${i}" hive -v -e" ALTER TABLE dmp_ods.table_name ADD PARTITION(bizdate='${bizdate}',bizhour='${hour}',log_type='access'); ALTER TABLE dmp_ods.table_name ADD PARTITION(b

创建内部表通过，分割create table t13(id int,name string,subject string)row format delimited fields terminated by ‘,’;LOAD DATA LOCAL INPATH ‘/root/t13.txt’ into table t13;– collect_set 和 炸裂explode演示selec...

CREATE TABLE t_2(id int,skuid string,price float,amount int)partitioned by (day string,city string)row format delimited fields terminated by ‘,’;LOAD DATA LOCAL INPATH ‘/root/t2.1’ into TABLE t_2 P...