SteveYurongSu commented on a change in pull request #1914:
URL: https://github.com/apache/iotdb/pull/1914#discussion_r525164730
##########
File path: README.md
##########
@@ -347,14 +348,17 @@ CREATE TIMESERIES root.fit.d2.s3 WITH
DATATYPE=INT32,ENCODING=RLE;
CREATE TIMESERIES root.fit.p.s1 WITH DATATYPE=INT32,ENCODING=RLE;
```
+IoTDB has the ability of type inference, so it is not necessary to create
metadata before data import. However, we still recommend creating metadata
before importing data using the CSV import tool, as this can avoid unnecessary
type conversion errors.
+
### An example of import csv file
```
Time,root.fit.d1.s1,root.fit.d1.s2,root.fit.d2.s1,root.fit.d2.s3,root.fit.p.s1
-1,100,'hello',200,300,400
-2,500,'world',600,700,800
-3,900,'IoTDB',1000,1100,1200
+1,100,hello,200,300,400
+2,500,world,600,700,800
+3,900,"hello, world",1000,1100,1200
```
+> if you have some special characters like comma in your field, the field
should be enclosed by a double quote or single quote. for example,
"hello,\"great";
Review comment:
Note that the following special characters in fields need to be checked
before importing:
1. `,` : fields containing `,` should be quoted by a pair of `"` or a pair
of `'`.
2. `"` : `"` in fields should be replaced by `\"` .
3. `'` : `'` in fields should be replaced by `\'` .
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
