Question 1:
Question:
{"status":"FAILED","msg":"There is no 100-continue header"}
reason:
This prompt appears because the CSV file is empty. In fact, it will not be affected.
Solution:
Add a request header to the command
-H "expect:100-continue"
curl –location-trusted -u root: -H “column_separator:|” -H “columns:__op=‘upsert’” -H “expect:100-continue” -T /home/zw/insert_sr_file/ip_basic.csv http://127.0.0.1:8030/api/zw/ip_basic/_stream_load
Question 2:
Question
There is data in the CSV file, but the error
CSV data

reason:
This error occurs because the corresponding data in the file does not correspond to the table field
Solution:
Receipt can be performed according to the fields specified in columns
usage:
-H "columns:pid,ip_val,area_id......"
Syntax use case:
curl --location-trusted -u root: \
-H "column_separator:|" \
-H "columns:pid,ip_val,area_id,udate,ftime,utime,ip,bip,cip,oui,mac,cname,user,depart,comp,place,os,os_sub,os_version,host_name,detail,m_type,m_sub_type,bip_val,cip_val,is_asset,is_controlled,source,domain,network_type,insert_unixtime,country_code,__op='upsert'" \
-T /home/zw/insert_sr_file/ip_basic.csv \
http://172.16.130.184:8030/api/zw/ip_basic/_stream_load
Question 3
problem
all partitions have no load data
reason
Caused by an empty file
solve
Don’t take it seriously. It won’t prompt if it’s not an empty file. Not affect
Read More:
- [Solved] Doris Error: too many filtered rows
- [Solved] Doris Error: Label Already Exists
- [Solved] MongoDB Error: TypeError: Object of type ObjectId is not JSON serializable
- Error in *** : subscript out of bounds [How to Solve]
- ElementUI Error in callback for watcher “data”: “Error: [ElTable] prop row-key is required”
- How to Fix HTTP Error 500: the default page enter their own routing can’t find a result
- Error generic_INTERNAL_Error (65536) processing [How to Solve]
- [Solved] Canoe CAPL Error: “the test module is not assigned or invalid”
- [Solved] Stream Error: stream has already been operated upon or closed
- PostgreSQL insert data error: column “XXX” does not exist solution
- [Solved] curl error while loading shared libraries libcrypto.so.1.0.0
- How to Solve Show() error caused by empty data
- Hive 3.1.2 startup error reporting and resolution of guava version conflict
- failed to obtain in-memory shard lock [How to Solve]
- Sqoop Error: Can‘t parse input data: ‘\N‘ [How to Solve]
- [Solved] MariaDB Add Datas Error: SQL error [1366] [22007]: (cIncorrect string value: ‘\xE5\xBC\xA0\xE4\xB8\x89’ for column
- ERROR: dependencies ‘curl’, ‘openssl’ are not available for package ‘httr’
- [Solved] C++ Error: terminate called after throwing an instance of ‘char const‘
- Java handles special characters in URL
- Error: uncaughtexception: cannot find module ‘internal / util / types’