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
}