导入文件大小
导入文件时间格式
导入方式1. 用以下导入方式报错，导入失败：
sdbimprt --hosts=localhost:11810 --type=csv --file=/home/sdbadmin/export_data/2019090102.csv --fields="apname string, currentapname string, downbyte double, downpacketnum double, mac string, result string, ssid string, time timestamp, upbyte double, uppacketnum double" -c log -l log20190901 --timestampfmt="YYYY/MM/DD HH:mm:ss" -n 9999
parsed records: 0
parse failure: 822093
sharding records: 0
sharding failure: 0
imported records: 0
import failure: 0
导入方式2. 将2019090102.csv文件删除了一部分，只保留了8921行，全部导入成功：
sdbimprt --hosts=localhost:11810 --type=csv --file=/home/sdbadmin/export_data/2019090102.csv --fields="apname string, currentapname string, downbyte double, downpacketnum double, mac string, result string, ssid string, time timestamp, upbyte double, uppacketnum double" -c log -l log20190901 --timestampfmt="YYYY/MM/DD HH:mm:ss"
parsed records: 8921
parse failure: 0
sharding records: 8921
sharding failure: 0
imported records: 8
导入方式1报错信息
[sdbadmin@sdbserver1 export_data]$ more sdbimport.log.2020-04-08-11:27:57
2020-04-08-11.27.55.193673 Level:ERROR
PID:26581 TID:26589
Function:_parseFieldValue Line:3960
File:SequoiaDB/engine/tools/import/impCSVRecordParser.cpp
Message:
failed to parse field value, type=timestamp, value=[2019-09-01 22:40:10,0,0]
2020-04-08-11.27.55.193850 Level:ERROR
PID:26581 TID:26589
Function:parseRecord Line:4717
File:SequoiaDB/engine/tools/import/impCSVRecordParser.cpp
Message:
failed to parse field, rc=-6
问题1：
导入方式1报错信息中，对应的csv文件中的原版格式是
GZ-1F-08, SW-GZ1F-21, 0, 0,b0-bbbbb, Success, aaaaa, 2019/9/1 22:40:10, 0, 0
依据报错, 不知怎么会在导出的检测中变成：
value=[2019-09-01 22:40:10,0,0]
问题2：
请问sdbimprt对导入文件大小和导入的行数分别有什么限制吗？
问题3：
我的以下写法是否有误？
file=/home/sdbadmin/export_data/2019090102.csv --fields="apname string, currentapname string, downbyte double, downpacketnum double, mac string, result string, ssid string, time timestamp, upbyte double, uppacketnum double" -c log -l log20190901 --timestampfmt="YYYY/MM/DD HH:mm:ss" -n 9999
-n 9999 代表--insertnum 但看起来没有起到作用
