spark中load数据

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";