StarRocks 进行 streamload 导入本地数据 NULL value in non-nullable column

[root@jhmk03 tpch-data]# curl  -v  --http0.9 --location-trusted -u root:123456 -H "label:or                                                           ders" \
>     -H "Expect:100-continue" \
>     -H "column_separator:|" \
>     -H "strict_mode: true" \
>     -T orders.tbl -XPUT \
>     http://192.168.153.103:8030/api/tpch_test/orders/_stream_load
*   Trying 192.168.153.103:8030...
* Connected to 192.168.153.103 (192.168.153.103) port 8030 (#0)
* Server auth using Basic with user 'root'
> PUT /api/tpch_test/orders/_stream_load HTTP/1.1
> Host: 192.168.153.103:8030
> Authorization: Basic cm9vdDoxMjM0NTY=
> User-Agent: curl/7.79.1
> Accept: */*
> label:orders
> Expect:100-continue
> column_separator:|
> strict_mode: true
> Content-Length: 170452161
>
* Mark bundle as not supporting multiuse
< HTTP/1.1 307 Temporary Redirect
< content-length: 0
< location: http://192.168.153.103:8050/api/tpch_test/orders/_stream_load
< content-type: text/html
< connection: keep-alive
<
* Closing connection 0
* Issue another request to this URL: 'http://192.168.153.103:8050/api/tpch_test/orders/_strea                                                           m_load'
*   Trying 192.168.153.103:8050...
* Connected to 192.168.153.103 (192.168.153.103) port 8050 (#1)
* Server auth using Basic with user 'root'
> PUT /api/tpch_test/orders/_stream_load HTTP/1.1
> Host: 192.168.153.103:8050
> Authorization: Basic cm9vdDoxMjM0NTY=
> User-Agent: curl/7.79.1
> Accept: */*
> label:orders
> Expect:100-continue
> column_separator:|
> strict_mode: true
> Content-Length: 170452161
>
* Mark bundle as not supporting multiuse
< HTTP/1.1 100 Continue
* We are completely uploaded and fine
* Mark bundle as not supporting multiuse
< HTTP/1.1 200 OK
< Date: Sat, 02 Mar 2024 06:03:11 GMT
< Content-Length: 543
< Content-Type: text/html; charset=ISO-8859-1
<
{
    "TxnId": 10,
    "Label": "orders",
    "Status": "Fail",
    "Message": "too many filtered rows",
    "NumberTotalRows": 1500000,
    "NumberLoadedRows": 0,
    "NumberFilteredRows": 1500000,
    "NumberUnselectedRows": 0,
    "LoadBytes": 170452161,
    "LoadTimeMs": 1734,
    "BeginTxnTimeMs": 1,
    "StreamLoadPlanTimeMs": 9,
    "ReadDataTimeMs": 1071,
    "WriteDataTimeMs": 1723,
    "CommitAndPublishTimeMs": 0,
    "ErrorURL": "http://192.168.153.103:8050/api/_load_error_log?file=error_log_b24da9984b83f                                                           879_4213ffe647fafe8a"
* Connection #1 to host 192.168.153.103 left intact
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71

原因是：字段列顺序不一致

1|36901|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among
1

curl  -v  --http0.9 --location-trusted -u root:123456 -H "label:orders" \
    -H "Expect:100-continue" \
    -H "column_separator:|" \
    -H "strict_mode: true" \
    ## 添加导入字段顺序
    -H "columns: O_ORDERKEY, O_CUSTKEY, O_ORDERSTATUS, O_TOTALPRICE, O_ORDERDATE, O_ORDERPRIORITY, O_CLERK, O_SHIPPRIORITY, O_COMMENT" \
    -T orders.tbl -XPUT \
    http://192.168.153.103:8030/api/tpch_test/orders/_stream_load  
1
2
3
4
5
6
7
8