注意lsql的嵌套:
insert into table s_y_s_t_loadjson select '{lsql表名称}', '{lsql表分区名}', '{筛选条件}', CL_JSON( 'a1',a1, 'a2',a2, 'a3',a3 ) from ( select a1,a2,a3 from xxx_lsql where partition = 'xxxx' ) tmp;