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

时间:2024-03-03 10:05:32
[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 }