This is an automated email from the ASF dual-hosted git repository. geniuspig pushed a commit to branch move_doc in repository https://gitbox.apache.org/repos/asf/iotdb.git
commit 490f77706e9c00ed33da46063a98b39675d5e489 Author: Boris <[email protected]> AuthorDate: Wed Jan 6 10:25:34 2021 +0800 move doc --- README.md | 54 -------------------- README_ZH.md | 56 --------------------- docs/UserGuide/System Tools/CSV Tool.md | 76 ++++++++++++++++++++++++++++ docs/zh/UserGuide/System Tools/CSV Tool.md | 79 ++++++++++++++++++++++++++++++ 4 files changed, 155 insertions(+), 110 deletions(-) diff --git a/README.md b/README.md index 0b35840..e71ec0c 100644 --- a/README.md +++ b/README.md @@ -333,59 +333,5 @@ Under the root path of iotdb: After being built, the IoTDB cli is located at the folder "cli/target/iotdb-cli-{project.version}". -## Usage of import-csv.sh - -### Create metadata -``` -SET STORAGE GROUP TO root.fit.d1; -SET STORAGE GROUP TO root.fit.d2; -SET STORAGE GROUP TO root.fit.p; -CREATE TIMESERIES root.fit.d1.s1 WITH DATATYPE=INT32,ENCODING=RLE; -CREATE TIMESERIES root.fit.d1.s2 WITH DATATYPE=TEXT,ENCODING=PLAIN; -CREATE TIMESERIES root.fit.d2.s1 WITH DATATYPE=INT32,ENCODING=RLE; -CREATE TIMESERIES root.fit.d2.s3 WITH DATATYPE=INT32,ENCODING=RLE; -CREATE TIMESERIES root.fit.p.s1 WITH DATATYPE=INT32,ENCODING=RLE; -``` - -### 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 -``` - -### Run import shell -``` -# Unix/OS X -> tools/import-csv.sh -h <ip> -p <port> -u <username> -pw <password> -f <xxx.csv> - -# Windows -> tools\import-csv.bat -h <ip> -p <port> -u <username> -pw <password> -f <xxx.csv> -``` - -### Error data file - -`csvInsertError.error` - -## Usage of export-csv.sh - -### Run export shell -``` -# Unix/OS X -> tools/export-csv.sh -h <ip> -p <port> -u <username> -pw <password> -td <directory> [-tf <time-format>] - -# Windows -> tools\export-csv.bat -h <ip> -p <port> -u <username> -pw <password> -td <directory> [-tf <time-format>] -``` - -### Input query - -``` -select * from root.fit.d1 -``` - - # Frequent Questions for Compiling see [Frequent Questions when Compiling the Source Code](https://iotdb.apache.org/Development/ContributeGuide.html#_Frequent-Questions-when-Compiling-the-Source-Code) diff --git a/README_ZH.md b/README_ZH.md index 9545377..87d58be 100644 --- a/README_ZH.md +++ b/README_ZH.md @@ -333,61 +333,5 @@ server 可以使用 "ctrl-C" 或者执行下面的脚本: 编译完成后, IoTDB cli 将生成在 "cli/target/iotdb-cli-{project.version}". -## 使用 import-csv.sh - -### 创建元数据 - -``` -SET STORAGE GROUP TO root.fit.d1; -SET STORAGE GROUP TO root.fit.d2; -SET STORAGE GROUP TO root.fit.p; -CREATE TIMESERIES root.fit.d1.s1 WITH DATATYPE=INT32,ENCODING=RLE; -CREATE TIMESERIES root.fit.d1.s2 WITH DATATYPE=TEXT,ENCODING=PLAIN; -CREATE TIMESERIES root.fit.d2.s1 WITH DATATYPE=INT32,ENCODING=RLE; -CREATE TIMESERIES root.fit.d2.s3 WITH DATATYPE=INT32,ENCODING=RLE; -CREATE TIMESERIES root.fit.p.s1 WITH DATATYPE=INT32,ENCODING=RLE; -``` - -### 从 csv 文件导入数据的示例 - -``` -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 -``` - -### 运行 import shell -``` -# Unix/OS X -> tools/import-csv.sh -h <ip> -p <port> -u <username> -pw <password> -f <xxx.csv> - -# Windows -> tools\import-csv.bat -h <ip> -p <port> -u <username> -pw <password> -f <xxx.csv> -``` - -### 错误的数据文件 - -`csvInsertError.error` - -## 使用 export-csv.sh - -### 运行 export shell - -``` -# Unix/OS X -> tools/export-csv.sh -h <ip> -p <port> -u <username> -pw <password> -td <directory> [-tf <time-format>] - -# Windows -> tools\export-csv.bat -h <ip> -p <port> -u <username> -pw <password> -td <directory> [-tf <time-format>] -``` - -### 执行查询 - -``` -select * from root.fit.d1 -``` - - # 常见编译错误 see [Frequent Questions when Compiling the Source Code](https://iotdb.apache.org/zh/Development/ContributeGuide.html#%E5%B8%B8%E8%A7%81%E7%BC%96%E8%AF%91%E9%94%99%E8%AF%AF) diff --git a/docs/UserGuide/System Tools/CSV Tool.md b/docs/UserGuide/System Tools/CSV Tool.md new file mode 100644 index 0000000..7d75418 --- /dev/null +++ b/docs/UserGuide/System Tools/CSV Tool.md @@ -0,0 +1,76 @@ +<!-- + + Licensed to the Apache Software Foundation (ASF) under one + or more contributor license agreements. See the NOTICE file + distributed with this work for additional information + regarding copyright ownership. The ASF licenses this file + to you under the Apache License, Version 2.0 (the + "License"); you may not use this file except in compliance + with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + + Unless required by applicable law or agreed to in writing, + software distributed under the License is distributed on an + "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + KIND, either express or implied. See the License for the + specific language governing permissions and limitations + under the License. + +--> +# Csv tool + +Csv tool is that you can import csv file into IoTDB or export csv file from IoTDB. + +## Usage of import-csv.sh + +### Create metadata +``` +SET STORAGE GROUP TO root.fit.d1; +SET STORAGE GROUP TO root.fit.d2; +SET STORAGE GROUP TO root.fit.p; +CREATE TIMESERIES root.fit.d1.s1 WITH DATATYPE=INT32,ENCODING=RLE; +CREATE TIMESERIES root.fit.d1.s2 WITH DATATYPE=TEXT,ENCODING=PLAIN; +CREATE TIMESERIES root.fit.d2.s1 WITH DATATYPE=INT32,ENCODING=RLE; +CREATE TIMESERIES root.fit.d2.s3 WITH DATATYPE=INT32,ENCODING=RLE; +CREATE TIMESERIES root.fit.p.s1 WITH DATATYPE=INT32,ENCODING=RLE; +``` + +### 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 +``` + +### Run import shell +``` +# Unix/OS X +> tools/import-csv.sh -h <ip> -p <port> -u <username> -pw <password> -f <xxx.csv> + +# Windows +> tools\import-csv.bat -h <ip> -p <port> -u <username> -pw <password> -f <xxx.csv> +``` + +### Error data file + +`csvInsertError.error` + +## Usage of export-csv.sh + +### Run export shell +``` +# Unix/OS X +> tools/export-csv.sh -h <ip> -p <port> -u <username> -pw <password> -td <directory> [-tf <time-format>] + +# Windows +> tools\export-csv.bat -h <ip> -p <port> -u <username> -pw <password> -td <directory> [-tf <time-format>] +``` + +### Input query + +``` +select * from root.fit.d1 +``` diff --git a/docs/zh/UserGuide/System Tools/CSV Tool.md b/docs/zh/UserGuide/System Tools/CSV Tool.md new file mode 100644 index 0000000..e4f7392 --- /dev/null +++ b/docs/zh/UserGuide/System Tools/CSV Tool.md @@ -0,0 +1,79 @@ +<!-- + + Licensed to the Apache Software Foundation (ASF) under one + or more contributor license agreements. See the NOTICE file + distributed with this work for additional information + regarding copyright ownership. The ASF licenses this file + to you under the Apache License, Version 2.0 (the + "License"); you may not use this file except in compliance + with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + + Unless required by applicable law or agreed to in writing, + software distributed under the License is distributed on an + "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + KIND, either express or implied. See the License for the + specific language governing permissions and limitations + under the License. + +--> + +# CSV 工具 + +Csv工具是您可以导入csv文件到IoTDB或从IoTDB导出csv文件。 + +## 使用 import-csv.sh + +### 创建元数据 + +``` +SET STORAGE GROUP TO root.fit.d1; +SET STORAGE GROUP TO root.fit.d2; +SET STORAGE GROUP TO root.fit.p; +CREATE TIMESERIES root.fit.d1.s1 WITH DATATYPE=INT32,ENCODING=RLE; +CREATE TIMESERIES root.fit.d1.s2 WITH DATATYPE=TEXT,ENCODING=PLAIN; +CREATE TIMESERIES root.fit.d2.s1 WITH DATATYPE=INT32,ENCODING=RLE; +CREATE TIMESERIES root.fit.d2.s3 WITH DATATYPE=INT32,ENCODING=RLE; +CREATE TIMESERIES root.fit.p.s1 WITH DATATYPE=INT32,ENCODING=RLE; +``` + +### 从 csv 文件导入数据的示例 + +``` +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 +``` + +### 运行 import shell +``` +# Unix/OS X +> tools/import-csv.sh -h <ip> -p <port> -u <username> -pw <password> -f <xxx.csv> + +# Windows +> tools\import-csv.bat -h <ip> -p <port> -u <username> -pw <password> -f <xxx.csv> +``` + +### 错误的数据文件 + +`csvInsertError.error` + +## 使用 export-csv.sh + +### 运行 export shell + +``` +# Unix/OS X +> tools/export-csv.sh -h <ip> -p <port> -u <username> -pw <password> -td <directory> [-tf <time-format>] + +# Windows +> tools\export-csv.bat -h <ip> -p <port> -u <username> -pw <password> -td <directory> [-tf <time-format>] +``` + +### 执行查询 + +``` +select * from root.fit.d1 +``` \ No newline at end of file
