doris报错 too many filtered rows

报错场景

1

[starcross@app1 FLink-test-LT]$ curl --location-trusted -u root:aba -T 'data_2022-04-11.csv' -H "label:testdoris201" -H "column_separator:," -XPUT http://10.22.33.69:8030/api/os/ws/_stream_load

报错内容：

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18


{
    "TxnId": 831311,
    "Label": "testdoris201",
    "Status": "Fail",
    "Message": "too many filtered rows",
    "NumberTotalRows": 1,
    "NumberLoadedRows": 0,
    "NumberFilteredRows": 1,
    "NumberUnselectedRows": 0,
    "LoadBytes": 1050,
    "LoadTimeMs": 85,
    "BeginTxnTimeMs": 0,
    "StreamLoadPutTimeMs": 1,
    "ReadDataTimeMs": 0,
    "WriteDataTimeMs": 57,
    "CommitAndPublishTimeMs": 0,
    "ErrorURL": "http://192.168.1.6:8040/api/_load_error_log?file=__shard_32/error_log_insert_stmt_b84753506aa7e6e9-434467e6d4a8a49e_b84753506aa7e6e9_434467e6d4a8a49e"
}

解决办法：

这是因为导入的列数和实际表的列数不一致造成的。

报错：

1
2
3
4
5
6
7
8


show partitions from ods.remote,这是因为没有创建partition。`ANALYSIS_ERROR]errCode = 2, detailMessage = data cannot be inserted into table with empty partition. Use SHOW PARTITIONS FROM ods_remote to see the currently partitions of this table.`





 ✘ Network doris-docker_doris_net  Error                                0.0s
failed to create network doris-docker_doris_net: Error response from daemon: Pool overlaps with other one on this address space

这是因为 network 交叉的原因。删除多余的 network 即可。