You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by GitBox <gi...@apache.org> on 2021/07/17 02:00:14 UTC
[GitHub] [iotdb] MeatZun opened a new issue #3587: 使用 export-csv 导出数据后，再用import-csv导入，数据导入失败
MeatZun opened a new issue #3587:
URL: https://github.com/apache/iotdb/issues/3587
**Describe the bug**
A clear and concise description of what the bug is.
**To Reproduce**
Steps to reproduce the behavior:
1 使用 export-csv.sh -h 127.0.0.1 -p 6667 -u root -pw root -td ./ -tf yyyy-MM-dd\ HH:mm:ss
2 输入select * from root 导出csv数据，导出成功
3 使用./tools/import-csv.sh -h 127.0.0.1 -p 6667 -u root -pw root -f ~/dump021.csv 导入到目标IOTDB
导入失败。
导出的csv数据：
Time,root.BeltScale.330.MD1640,root.BeltScale.330.MD1724,root.BeltScale.330.MD1732,root.BeltScale.330.MD1700,root.BeltScale.330.MD1716,root.BeltScale.330.MD1708,root.BeltScale.330.MD1692,root.ln.wf01.wt01.status,root.原煤系统.330.MD1224,root.原煤系统.330.MD1260,root.原煤系统.330.MD1220,root.原煤系统.330.MD1264,root.原煤系统.608.I14.4,root.原煤系统.608.I14.4,root.DensityMeter.1.MD1600,root.DensityMeter.1.MD1616,root.DensityMeter.1.MD1608
1970-01-01T08:00:00.100+08:00,,,,,,,,false,,,,,,,,,
2021-06-14T09:58:24.982+08:00,,,,,,,,,,,0.061523438,,,,,,
2021-06-14T09:58:27.982+08:00,,,,,,,,,,,0.061559606,,,,,,
2021-06-14T09:58:36.984+08:00,,,,,,,,,,,0.061631944,,,,,,
2021-06-14T09:58:39.984+08:00,,,,,,,,,,,0.086552374,,,,,,
2021-06-14T09:58:45.985+08:00,,,,,,,,,,,0.086371526,,,,,,
2021-06-14T09:58:48.986+08:00,,,,,,,,,,,0.061631944,,,,,,
2021-06-14T09:58:51.986+08:00,,,,,,,,,,,0.08658854,,,,,,
2021-06-14T09:58:54.987+08:00,,,,,,,,,,,0.086443864,,,,,,
2021-06-14T09:58:57.988+08:00,,,,,,,,,,,0.08662471,,,,,,
2021-06-14T09:59:00.989+08:00,,,,,,,,,,,0.0865162,,,,,,
2021-06-14T09:59:03.989+08:00,,,,,,,,,,,0.086552374,,,,,,
2021-06-14T09:59:10.001+08:00,,,,,,,,,,,0.08658854,,,,,,
2021-06-14T09:59:13.002+08:00,,,,,,,,,,,0.08662471,,,,,,
2021-06-14T09:59:19.004+08:00,,,,,,,,,,,0.08669705,,,,,,
2021-06-14T09:59:22.006+08:00,,,,,,,,,,,0.08648004,,,,,,
2021-06-14T09:59:28.006+08:00,,,,,,,,,,,0.086733215,,,,,,
2021-06-14T09:59:31.009+08:00,,,,,,,,,,,0.08666088,,,,,,
2021-06-14T09:59:34.010+08:00,,,,,,,,,,,0.08662471,,,,,,
2021-06-14T09:59:37.011+08:00,,,,,,,,,,,0.0865162,,,,,,
2021-06-14T09:59:40.012+08:00,,,,,,,,,,,0.061559606,,,,,,
2021-06-14T09:59:43.014+08:00,,,,,,,,,,,0.086371526,,,,,,
2021-06-14T09:59:46.014+08:00,,,,,,,,,,,0.08629919,,,,,,
2021-06-14T09:59:49.014+08:00,,,,,,,,,,,0.0864077,,,,,,
2021-06-14T09:59:52.015+08:00,,,,,,,,,,,0.08626302,,,,,,
2021-06-14T09:59:55.015+08:00,,,,,,,,,,,0.08633536,,,,,,
2021-06-14T09:59:58.015+08:00,,,,,,,,,,,0.08622685,,,,,,
2021-06-14T10:00:01.015+08:00,,,,,,,,,,,0.0864077,,,,,,
2021-06-14T10:00:04.015+08:00,,,,,,,,,,,0.08658854,,,,,,
2021-06-14T10:00:07.016+08:00,,,,,,,,,,,0.086552374,,,,,,
2021-06-14T10:00:10.029+08:00,,,,,,,,,,,0.0864077,,,,,,
2021-06-14T10:00:13.030+08:00,,,,,,,,,,,0.08626302,,,,,,
2021-06-14T10:00:16.030+08:00,,,,,,,,,,,0.086443864,,,,,,
2021-06-14T10:00:19.030+08:00,,,,,,,,,,,0.08658854,,,,,,
2021-06-14T10:00:25.031+08:00,,,,,,,,,,,0.086443864,,,,,,
2021-06-14T10:00:28.032+08:00,,,,,,,,,,,0.08648004,,,,,,
2021-06-14T10:00:31.032+08:00,,,,,,,,,,,0.0864077,,,,,,
2021-06-14T10:00:34.033+08:00,,,,,,,,,,,0.086371526,,,,,,
2021-06-14T10:00:37.035+08:00,,,,,,,,,,,0.08622685,,,,,,
2021-06-14T10:00:40.035+08:00,,,,,,,,,,,0.0864077,,,,,,
2021-06-14T10:00:43.035+08:00,,,,,,,,,,,0.086443864,,,,,,
2021-06-14T10:00:46.036+08:00,,,,,,,,,,,0.0865162,,,,,,
2021-06-14T10:00:49.036+08:00,,,,,,,,,,,0.086552374,,,,,,
2021-06-14T10:00:52.036+08:00,,,,,,,,,,,0.0865162,,,,,,
2021-06-14T10:00:55.036+08:00,,,,,,,,,,,0.086371526,,,,,,
2021-06-14T10:00:58.036+08:00,,,,,,,,,,,0.086443864,,,,,,
2021-06-14T10:01:01.037+08:00,,,,,,,,,,,0.08662471,,,,,,
2021-06-14T10:01:04.037+08:00,,,,,,,,,,,0.0864077,,,,,,
2021-06-14T10:01:07.037+08:00,,,,,,,,,,,0.061523438,,,,,,
2021-06-14T10:01:10.040+08:00,,,,,,,,,,,0.08666088,,,,,,
2021-06-14T10:01:13.041+08:00,,,,,,,,,,,0.08648004,,,,,,
2021-06-14T10:01:16.041+08:00,,,,,,,,,,,0.06148727,,,,,,
2021-06-14T10:01:19.041+08:00,,,,,,,,,,,0.0865162,,,,,,
2021-06-14T10:01:22.041+08:00,,,,,,,,,,,0.086733215,,,,,,
2021-06-14T10:01:25.042+08:00,,,,,,,,,,,0.08666088,,,,,,
2021-06-14T10:01:31.042+08:00,,,,,,,,,,,0.086552374,,,,,,
2021-06-14T10:01:34.042+08:00,,,,,,,,,,,0.08662471,,,,,,
2021-06-14T10:01:37.043+08:00,,,,,,,,,,,0.0864077,,,,,,
2021-06-14T10:01:40.043+08:00,,,,,,,,,,,0.086443864,,,,,,
2021-06-14T10:01:43.044+08:00,,,,,,,,,,,0.086552374,,,,,,
2021-06-14T10:01:46.044+08:00,,,,,,,,,,,0.0865162,,,,,,
2021-06-14T10:01:52.046+08:00,,,,,,,,,,,0.08633536,,,,,,
**Screenshots**
**Desktop (please complete the following information):**
- OS: 目标IOTDB操作系统版本 Linux version 3.10.0-1160.11.1.el7.x86_64 (mockbuild@kbuilder.bsys.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-44) (GCC) )
- 源IOTDB操作系统 Linux version 3.10.0-1160.25.1.el7.x86_64 (mockbuild@kbuilder.bsys.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-44) (GCC) )
- IOTDB版本都是 0.12
**Additional context**
Add any other context about the problem here.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] github-actions[bot] commented on issue #3587: 使用 export-csv 导出数据后，再用import-csv导入，数据导入失败
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #3587:
URL: https://github.com/apache/iotdb/issues/3587#issuecomment-881798186
Hi, this is your first issue in IoTDB project. Thanks for your report. Welcome to join the community!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] HTHou closed issue #3587: 使用 export-csv 导出数据后，再用import-csv导入，数据导入失败
Posted by GitBox <gi...@apache.org>.
HTHou closed issue #3587:
URL: https://github.com/apache/iotdb/issues/3587
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] HTHou commented on issue #3587: 使用 export-csv 导出数据后，再用import-csv导入，数据导入失败
Posted by GitBox <gi...@apache.org>.
HTHou commented on issue #3587:
URL: https://github.com/apache/iotdb/issues/3587#issuecomment-881840654
试试0.12.1版本？新版本修复了一些csv工具的bug。
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org