Doris导入csv文件数据

1. csv数据准备

1,张三,男,2023-03-22

2,李四,女,2023-03-22

3,王五,男,2023-03-22

4,赵六,男,2023-03-22

将数据写入csv local_file_load.csv文件 并放到服务器192.168.xx.xx的/data/palo_test_data/目录下

2. 创建doris目标表：

drop table if exists chengt.local_file_load;

create table chengt.local_file_load(

        idvarchar(200),

        namevarchar(200),

        sexvarchar(200),

        datevarchar(200)

)DISTRIBUTED BYHASH(id)

PROPERTIES (

"replication_allocation" = "tag.location.default:3", -- 副本数

"in_memory"= "false",

"storage_format"= "V2"

) ;

select * from chengt.local_file_load

3.1执行导入命令

[root@localhostpalo_test_data]# curl --location-trusted -u root:doris用户密码 -H"label:csvload1" -H "column_separator:," -T/data/palo_test_data/local_file_load.csv http://doris访问服务器IP:http_port/api/chengt/local_file_load/_stream_load​

Linux打印信息如下：

{

    "TxnId": 7,

    "Label": "csvload1",

    "Status": "Success",

    "Message": "OK",

    "NumberTotalRows": 4,

    "NumberLoadedRows": 4,

    "NumberFilteredRows": 0,

    "NumberUnselectedRows": 0,

    "LoadBytes": 97,

    "LoadTimeMs": 987,

    "BeginTxnTimeMs": 53,

    "StreamLoadPutTimeMs": 479,

    "ReadDataTimeMs": 0,

    "WriteDataTimeMs": 125,

    "CommitAndPublishTimeMs": 324

}

导入doris后表中数据：

其他-doris默认服务端口