1、从本地load(适用于textfile表)
load data local inpath '/home/hadoop/cData.txt' overwrite into table dm_user_info partition ( spark_load_date = '20190312');
2、从hdfs中load(适用于carbondata表)
load data inpath '/home/hadoop/cData.txt' overwrite into table dm_user_info partition ( spark_load_date = '20190312');
3、从其他的表insert
insert into behavior_info select * from behavior_info_test where process_datestr=20210423;
4、直接insert一条
insert into behavior_info select "name","test1","test2";