select into outfile(doris)

 

1.导出全表

SELECT id,name1,name2,name3,name4,name5,name6,name7,name8,name9,name10,create_time,update_time
FROM tb_hxl
INTO OUTFILE "file:///tmp/export_tb_hxl/tb_hxl_"
FORMAT AS csv
PROPERTIES (
    "column_separator" = "€",
    "line_delimiter" = "\n"
);

 

2.带条件导出

SELECT id,name1,name2,name3,name4,name5,name6,name7,name8,name9,name10,create_time,update_time
FROM tb_hxl where id=1
INTO OUTFILE "file:///tmp/export_tb_hxl/tb_hxl_"
FORMAT AS csv
PROPERTIES (
    "column_separator" = "€",
    "line_delimiter" = "\n"
);

 

3.关联导出

SELECT a.id,a.name1,a.name2,a.name3,a.name4,a.name5,a.name6,a.name7,a.name8,a.name9,a.name10,a.create_time,a.update_time
FROM tb_hxl a
inner join tb_hxl b on a.id=b.id where a.id<=10
INTO OUTFILE "file:///tmp/export_tb_hxl/tb_hxl_"
FORMAT AS csv
PROPERTIES (
    "column_separator" = "€",
    "line_delimiter" = "\n"
);