4.5.7 导出到其他分区

注意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;
Copyright © lucene.xin 2020 all right reserved修改时间: 2021-07-22 18:08:02

results matching ""

    No results matching ""