[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r337350502 ## File path: docs/Documentation/UserGuide/4-Operation Manual/7-IoTDB Query Statement.md ## @@ -0,0 +1,694 @@ + +# Chapter 4 Operation Manual +# IoTDB SQL Statement +In this part, we will introduce you IoTDB's Query Language. IoTDB offers you a SQL-like query language for interacting with IoTDB, the query language can be devided into 4 major parts: + +* Schema Statement: statements about schema management are all listed in this section. +* Data Management Statement: statements about data management (such as: data insertion, data query, etc.) are all listed in this section. +* Database Management Statement: statements about database management and authentication are all listed in this section. +* Functions: functions that IoTDB offers are all listed in this section. + +All of these statements are write in IoTDB's own syntax, for details about the syntax composition, please check the `Reference` section. + +## IoTDB Query Statement + + +### Schema Statement + +* Set Storage Group + +``` SQL +SET STORAGE GROUP TO +Eg: IoTDB > SET STORAGE GROUP TO root.ln.wf01.wt01 +Note: PrefixPath can not include `*` +``` +* Create Timeseries Statement + +``` +CREATE TIMESERIES WITH +AttributeClauses : DATATYPE= COMMA ENCODING= [COMMA ]* +DataTypeValue: BOOLEAN | DOUBLE | FLOAT | INT32 | INT64 | TEXT +EncodingValue: GORILLA | PLAIN | RLE | TS_2DIFF | REGULAR +ExtraAttributeClause: { + COMPRESSOR = + MAX_POINT_NUMBER = Integer +} +CompressorValue: UNCOMPRESSED | SNAPPY +Eg: IoTDB > CREATE TIMESERIES root.ln.wf01.wt01.status WITH DATATYPE=BOOLEAN, ENCODING=PLAIN +Eg: IoTDB > CREATE TIMESERIES root.ln.wf01.wt01.temperature WITH DATATYPE=FLOAT, ENCODING=RLE +Eg: IoTDB > CREATE TIMESERIES root.ln.wf01.wt01.temperature WITH DATATYPE=FLOAT, ENCODING=RLE, COMPRESSOR=SNAPPY, MAX_POINT_NUMBER=3 +Note: Datatype and encoding type must be corresponding. Please check Chapter 3 Encoding Section for details. +``` + +* Delete Timeseries Statement + +``` +DELETE TIMESERIES [COMMA ]* +Eg: IoTDB > DELETE TIMESERIES root.ln.wf01.wt01.status +Eg: IoTDB > DELETE TIMESERIES root.ln.wf01.wt01.status, root.ln.wf01.wt01.temperature +Eg: IoTDB > DELETE TIMESERIES root.ln.wf01.wt01.* +``` + +* Show All Timeseries Statement + +``` +SHOW TIMESERIES +Eg: IoTDB > SHOW TIMESERIES +Note: This statement can only be used in IoTDB Client. If you need to show all timeseries in JDBC, please use `DataBaseMetadata` interface. +``` + +* Show Specific Timeseries Statement + +``` +SHOW TIMESERIES +Eg: IoTDB > SHOW TIMESERIES root +Eg: IoTDB > SHOW TIMESERIES root.ln +Eg: IoTDB > SHOW TIMESERIES root.ln.*.*.status +Eg: IoTDB > SHOW TIMESERIES root.ln.wf01.wt01.status +Note: The path can be prefix path, star path or timeseries path +Note: This statement can be used in IoTDB Client and JDBC. +``` + +* Show Storage Group Statement + +``` +SHOW STORAGE GROUP +Eg: IoTDB > SHOW STORAGE GROUP +Note: This statement can be used in IoTDB Client and JDBC. +``` + +### Data Management Statement + +* Insert Record Statement + +``` +INSERT INTO LPAREN TIMESTAMP COMMA [COMMA ]* RPAREN VALUES LPAREN , [COMMA ]* RPAREN +Sensor : Identifier +Eg: IoTDB > INSERT INTO root.ln.wf01.wt01(timestamp,status) values(150946560,true) +Eg: IoTDB > INSERT INTO root.ln.wf01.wt01(timestamp,status) VALUES(NOW(), false) +Eg: IoTDB > INSERT INTO root.ln.wf01.wt01(timestamp,temperature) VALUES(2017-11-01T00:17:00.000+08:00,24.22028) +Eg: IoTDB > INSERT INTO root.ln.wf01.wt01(timestamp, status, temperature) VALUES (150946668, false, 20.060787); +Note: the statement needs to satisfy this constraint: + = +Note: The order of Sensor and PointValue need one-to-one correspondence +``` + +* Update Record Statement + +``` +UPDATE SET WHERE +UpdateClause: +SetClause: +SetExpression: EQUAL +WhereClause : [(AND | OR) ]* +Condition : [(AND | OR) ]* +Expression : [NOT | !]? TIME PrecedenceEqualOperator +Eg: IoTDB > UPDATE root.ln.wf01.wt01 SET temperature = 23 WHERE time < NOW() and time > 2017-11-1T00:15:00+08:00 +Note: the statement needs to satisfy this constraint: + = +``` + +* Delete Record Statement + +``` +DELETE FROM [COMMA ]* WHERE TIME LESSTHAN +Eg: DELETE FROM root.ln.wf01.wt01.temperature WHERE time < 2017-11-1T00:05:00+08:00 +Eg: DELETE FROM root.ln.wf01.wt01.status, root.ln.wf01.wt01.temperature WHERE time < NOW() +Eg: DELETE FROM root.ln.wf01.wt01.* WHERE time < 150946614 +``` + +* Select Record Statement + +``` +SELECT FROM [WHERE ]? +SelectClause : (COMMA )* +SelectPath : LPAREN RPAREN | +FUNCTION : ‘COUNT’ , ‘MIN_TIME’, ‘MAX_TIME’, ‘MIN_VALUE’, ‘MAX_VALUE’ +FromClause : (COMMA )? +WhereClause : [(AND | OR) ]* +Condition : [(AND | OR) ]* +Expression : [NOT | !]? | [NOT | !]? +TimeExpr : TIME PrecedenceEqualOperator +SensorExpr : ( | )
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r337354516 ## File path: docs/Documentation/UserGuide/9-Tools-Grafana.md ## @@ -0,0 +1,139 @@ + + + +## Outline + +- IoTDB-Grafana +- Grafana installation +- Install Grafana +- Install data source plugin +- Start Grafana +- IoTDB installation +- IoTDB-Grafana installation +- Start IoTDB-Grafana +- Explore in Grafana +- Add data source +- Design in dashboard + + +# IoTDB-Grafana + +This project provides a connector which reads data from IoTDB and sends to Grafana(https://grafana.com/). Before you use this tool, make sure Grafana and IoTDB are correctly installed and started. + +## Grafana installation + +### Install Grafana + +* Download url: https://grafana.com/grafana/download +* version >= 4.4.1 + +### Install data source plugin + +* plugin name: simple-json-datasource +* Download url: https://github.com/grafana/simple-json-datasource + +After downloading this plugin, you can use the grafana-cli tool to install SimpleJson from the commandline: + +``` +grafana-cli plugins install grafana-simple-json-datasource +``` + +Alternatively, you can manually download the .zip file and unpack it into your grafana plugins directory. + +* `{grafana-install-directory}\data\plugin\` (Windows) +* `/var/lib/grafana/plugins` (Linux) +* `/usr/local/var/lib/grafana/plugins`(Mac) + +### Start Grafana +If you use Unix, Grafana will auto start after installing, or you can run `sudo service grafana-server start` command. See more information [here](http://docs.grafana.org/installation/debian/). + +If you use Mac and `homebrew` to install Grafana, you can use `homebrew` to start Grafana. +First make sure homebrew/services is installed by running `brew tap homebrew/services`, then start Grafana using: `brew services start grafana`. +See more information [here](http://docs.grafana.org/installation/mac/). + +If you use Windows, start Grafana by executing grafana-server.exe, located in the bin directory, preferably from the command line. See more information [here](http://docs.grafana.org/installation/windows/). + +## IoTDB installation + +See https://github.com/apache/incubator-iotdb Review comment: How about changing this to an internal link to the corresponding chapter in the user guide. 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r337348684 ## File path: docs/Documentation/UserGuide/4-Operation Manual/7-IoTDB Query Statement.md ## @@ -0,0 +1,694 @@ + +# Chapter 4 Operation Manual +# IoTDB SQL Statement +In this part, we will introduce you IoTDB's Query Language. IoTDB offers you a SQL-like query language for interacting with IoTDB, the query language can be devided into 4 major parts: + +* Schema Statement: statements about schema management are all listed in this section. +* Data Management Statement: statements about data management (such as: data insertion, data query, etc.) are all listed in this section. +* Database Management Statement: statements about database management and authentication are all listed in this section. +* Functions: functions that IoTDB offers are all listed in this section. + +All of these statements are write in IoTDB's own syntax, for details about the syntax composition, please check the `Reference` section. + +## IoTDB Query Statement + + +### Schema Statement + +* Set Storage Group + +``` SQL +SET STORAGE GROUP TO +Eg: IoTDB > SET STORAGE GROUP TO root.ln.wf01.wt01 +Note: PrefixPath can not include `*` +``` +* Create Timeseries Statement + +``` +CREATE TIMESERIES WITH +AttributeClauses : DATATYPE= COMMA ENCODING= [COMMA ]* +DataTypeValue: BOOLEAN | DOUBLE | FLOAT | INT32 | INT64 | TEXT +EncodingValue: GORILLA | PLAIN | RLE | TS_2DIFF | REGULAR +ExtraAttributeClause: { + COMPRESSOR = + MAX_POINT_NUMBER = Integer +} +CompressorValue: UNCOMPRESSED | SNAPPY Review comment: Please update the compressor types. 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r337334873 ## File path: docs/Documentation-CHN/UserGuide/9-Tools-Cli.md ## @@ -0,0 +1,134 @@ + + + +## 概览 +- Cli / Shell工具 +- Cli / Shell运行方式 +- Cli / Shell运行参数 +- Cli / Shell的-e参数 + + + +# Cli / Shell工具 +IOTDB为用户提供Client/Shell工具用于启动客户端和服务端程序。下面介绍每个Client/Shell工具的运行方式和相关参数。 +> \$IOTDB\_HOME表示IoTDB的安装目录所在路径。 + +## Cli / Shell运行方式 +安装后的IoTDB中有一个默认用户:`root`,默认密码为`root`。用户可以使用该用户尝试运行IoTDB客户端以测试服务器是否正常启动。客户端启动脚本为$IOTDB_HOME/bin文件夹下的`start-client`脚本。启动脚本时需要指定运行IP和PORT。以下为服务器在本机启动,且用户未更改运行端口号的示例,默认端口为6667。若用户尝试连接远程服务器或更改了服务器运行的端口号,请在-h和-p项处使用服务器的IP和PORT。 + +Linux系统与MacOS系统启动命令如下: + +``` + Shell > ./sbin/start-cli.sh -h 127.0.0.1 -p 6667 -u root -pw root +``` +Windows系统启动命令如下: + +``` + Shell > \sbin\start-cli.bat -h 127.0.0.1 -p 6667 -u root -pw root Review comment: There seems to be a missing ".". And I think the names of the scripts have changed. 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r337352379 ## File path: docs/Documentation/UserGuide/9-Tools-Cli.md ## @@ -0,0 +1,132 @@ + + + +## Outline +- Cli/shell tool +- Running Cli/Shell +- Cli/Shell Parameters +- Cli/shell tool with -e parameter + + +# Cli/shell tool +IoTDB provides Cli/shell tools for users to interact with IoTDB server in command lines. This document will show how Cli/shell tool works and what does it parameters mean. Review comment: " what does it parameters mean" -> " what do its parameters mean" 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r336869424 ## File path: docs/Documentation/UserGuide/1-Overview/4-Features.md ## @@ -43,9 +43,9 @@ IoTDB supports millions of low-power devices' strong connection data access, hig IoTDB supports time alignment for timeseries data accross devices and sensors, computation in timeseries field (frequency domain transformation) and rich aggregation function support in time dimension. -* Easy to get start. +* Easy to get startd. Review comment: startd -> started 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335361471 ## File path: docs/Documentation-CHN/UserGuide/5-Management/1-System Monitor.md ## @@ -33,13 +33,13 @@ 本模块是IoTDB为用户提供的对其中存储数据信息的数据统计监控方式,我们会在系统中为您记录各个模块的数据统计信息,并将其汇总存入数据库中。当前0.7.0版本的IoTDB提供IoTDB写入数据的统计功能。 -用户可以选择开启或关闭数据统计监控功能(您可以设定配置文件中的`enable_stat_monitor`项,详细信息参见[第4.2节](/#/Documents/0.8.0/chap4/sec2))。 +用户可以选择开启或关闭数据统计监控功能(您可以设定配置文件中的`enable_stat_monitor`项,详细信息参见[第4.2节](/#/Documents/progress/chap3/sec2))。 Review comment: “第4.2节” -> "第3.2节" This is common, please check other places for the same problem. 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335847896 ## File path: docs/Documentation/UserGuide/4-Operation Manual/2-Data Model Selection.md ## @@ -105,6 +111,6 @@ It is worth noting that when the queried path does not exist, the system will re Version 0.7.0 imposes some limitations on the scale of data that users can operate: -Limit 1: Assuming that the JVM memory allocated to IoTDB at runtime is p and the user-defined size of data in memory written to disk ([group\_size\_in\_byte](/#/Documents/0.8.0/chap4/sec2)) is Q, then the number of storage groups should not exceed p/q. +Limit 1: Assuming that the JVM memory allocated to IoTDB at runtime is p and the user-defined size of data in memory written to disk ([group\_size\_in\_byte](/#/Documents/progress/chap3/sec2)) is Q, then the number of storage groups should not exceed p/q. Review comment: Decapitalize "Q". 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335360236 ## File path: docs/Documentation-CHN/UserGuide/5-Management/1-System Monitor.md ## @@ -33,13 +33,13 @@ 本模块是IoTDB为用户提供的对其中存储数据信息的数据统计监控方式,我们会在系统中为您记录各个模块的数据统计信息,并将其汇总存入数据库中。当前0.7.0版本的IoTDB提供IoTDB写入数据的统计功能。 Review comment: "当前0.7.0版本" -> "当前版本" Please check the occurrence of "0.7.0" or "0.8.0" and remove them if they are not necessary. 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335869845 ## File path: docs/Documentation/UserGuide/4-Operation Manual/7-IoTDB Query Language.md ## @@ -0,0 +1,836 @@ + + +# Chapter 4: Operation Manual + +In this part, we will introduce you IoTDB's Query Language. IoTDB offers you a SQL-like query language for interacting with IoTDB, the query language can be devided into 4 major parts: + +* Schema Statement: statements about schema management are all listed in this section. +* Data Management Statement: statements about data management (such as: data insertion, data query, etc.) are all listed in this section. +* Database Management Statement: statements about database management and authentication are all listed in this section. +* Functions: functions that IoTDB offers are all listed in this section. + +All of these statements are write in IoTDB's own syntax, for details about the syntax composition, please check the `Reference` section. + +## IoTDB Query Language + + +### Schema Statement + + Set Storage Group + + + + +SET STORAGE GROUP TO PrefixPath> + +Eg: +``` SQL +IoTDB > SET STORAGE GROUP TO root.ln.wf01.wt01 +``` +>Note: PrefixPath can not include `*` + + Create Timeseries Statement + + +CREATE TIMESERIES Timeseries> WITH AttributeClauses> + +AttributeClauses : DATATYPE=DataTypeValue> COMMA ENCODING=EncodingValue> [COMMA ExtraAttributeClause>]* + +DataTypeValue: BOOLEAN | DOUBLE | FLOAT | INT32 | INT64 | TEXT +EncodingValue: GORILLA | PLAIN | RLE | TS_2DIFF | REGULAR + +ExtraAttributeClause: { + COMPRESSOR = CompressorValue> + MAX_POINT_NUMBER = Integer +} + +CompressorValue: UNCOMPRESSED | SNAPPY + +Eg: +``` +IoTDB > CREATE TIMESERIES root.ln.wf01.wt01.status WITH DATATYPE=BOOLEAN, ENCODING=PLAIN +IoTDB > CREATE TIMESERIES root.ln.wf01.wt01.temperature WITH DATATYPE=FLOAT, ENCODING=RLE +IoTDB > CREATE TIMESERIES root.ln.wf01.wt01.temperature WITH DATATYPE=FLOAT, ENCODING=RLE, COMPRESSOR=SNAPPY, MAX_POINT_NUMBER=3 +``` +>Note: Datatype and encoding type must be corresponding. Please check Chapter 3 Encoding Section for details. + + + Delete Timeseries Statement + + +DELETE TIMESERIES PrefixPath> [COMMA PrefixPath>]* + +Eg: +``` +IoTDB > DELETE TIMESERIES root.ln.wf01.wt01.status +IoTDB > DELETE TIMESERIES root.ln.wf01.wt01.status, root.ln.wf01.wt01.temperature +IoTDB > DELETE TIMESERIES root.ln.wf01.wt01.* +``` + + Show All Timeseries Statement + +SHOW TIMESERIES + +Eg: +``` +IoTDB > SHOW TIMESERIES +``` +>Note: This statement can only be used in IoTDB Client. If you need to show all timeseries in JDBC, please use `DataBaseMetadata` interface. + + Show Specific Timeseries Statement + + +SHOW TIMESERIES Path> + +Eg: +``` +IoTDB > SHOW TIMESERIES root +IoTDB > SHOW TIMESERIES root.ln +IoTDB > SHOW TIMESERIES root.ln.*.*.status +IoTDB > SHOW TIMESERIES root.ln.wf01.wt01.status +``` +>Note: The path can be prefix path, star path or timeseries path + +>Note: This statement can be used in IoTDB Client and JDBC. + + + Show Storage Group Statement + +SHOW STORAGE GROUP + +Eg: +``` +IoTDB > SHOW STORAGE GROUP +``` +>Note: This statement can be used in IoTDB Client and JDBC. + +### Data Management Statement + + Insert Record Statement + + +INSERT INTO PrefixPath> LPAREN TIMESTAMP COMMA Sensor> [COMMA Sensor>]* RPAREN VALUES LPAREN TimeValue>, PointValue> [COMMA PointValue>]* RPAREN + +Sensor : Identifier + +Eg: +``` +IoTDB > INSERT INTO root.ln.wf01.wt01(timestamp,status) values(150946560,true) +IoTDB > INSERT INTO root.ln.wf01.wt01(timestamp,status) VALUES(NOW(), false) +IoTDB > INSERT INTO root.ln.wf01.wt01(timestamp,temperature) VALUES(2017-11-01T00:17:00.000+08:00,24.22028) +IoTDB > INSERT INTO root.ln.wf01.wt01(timestamp, status, temperature) VALUES (150946668, false, 20.060787); +``` +>Note: the statement needs to satisfy this constraint: PrefixPath> + Path> = Timeseries> + +>Note: The order of Sensor and PointValue need one-to-one correspondence + + + Update Record Statement Review comment: Better to leave a remark that UPDATE is currently unsupported. 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335785603 ## File path: docs/Documentation/UserGuide/2-Concept/1-Key Concepts and Terminology.md ## @@ -169,7 +169,7 @@ IoTDB can support LONG types and DATETIME-DISPLAY types when displaying timestam * Value -The value of a time series is actually the value sent by a sensor to IoTDB. This value can be stored by IoTDB according to the data type. At the same time, users can select the compression mode and the corresponding encoding mode according to the data type of this value. See [Data Type](/#/Documents/0.8.0/chap2/sec2) and [Encoding](/#/Documents/0.8.0/chap2/sec3) of this document for details on data type and corresponding encoding. +The value of a time series is actually the value sent by a sensor to IoTDB. This value can be stored by IoTDB according to the data type. At the same time, users can select the compression mode and the corresponding encoding mode according to the data type of this value. See [Data Type](/#/Documents/progress/chap2/sec2) and [Encoding](/#/Documents/progress/chap2/sec3) of this document for details on data type and corresponding encoding. Review comment: There should also be a link to the compressor chapter. 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335782360 ## File path: docs/Documentation-CHN/UserGuide/5-Management/4-Data Management.md ## @@ -30,17 +30,17 @@ IoTDB需要存储的数据分为三类,分别为数据文件、系统文件以 ### 数据文件 -数据文件存储了用户写入IoTDB系统的所有数据。包含TsFile文件和其他文件,其中,TsFile文件可以通过配置项`tsfile_dir`配置存储路径(详情见[tsfile_dir配置项](/#/Documents/0.8.0/chap4/sec2)),其他文件可通过[data_dir配置项](/#/Documents/0.8.0/chap4/sec2)进行配置。 +数据文件存储了用户写入IoTDB系统的所有数据。包含TsFile文件和其他文件,其中,TsFile文件可以通过配置项`tsfile_dir`配置存储路径(详情见[tsfile_dir配置项](/#/Documents/progress/chap3/sec2)),其他文件可通过[data_dir配置项](/#/Documents/progress/chap3/sec2)进行配置。 -为了更好的支持用户对于磁盘空间扩展等存储需求,IoTDB为TsFile的存储配置增加了多文件目录的存储方式,用户可自主配置多个存储路径作为数据的持久化位置(详情见[tsfile_dir配置项](/#/Documents/0.8.0/chap4/sec2)),并可以指定或自定义目录选择策略(详情见[mult_dir_strategy配置项](/#/Documents/0.8.0/chap4/sec2))。 +为了更好的支持用户对于磁盘空间扩展等存储需求,IoTDB为TsFile的存储配置增加了多文件目录的存储方式,用户可自主配置多个存储路径作为数据的持久化位置(详情见[tsfile_dir配置项](/#/Documents/progress/chap3/sec2)),并可以指定或自定义目录选择策略(详情见[mult_dir_strategy配置项](/#/Documents/progress/chap3/sec2))。 ### 系统文件 -系统文件包括Restore文件和Schema文件,存储了数据文件的元数据信息。可通过sys_dir配置项进行配置(详情见[sys_dir配置项](/#/Documents/0.8.0/chap4/sec2))。 +系统文件包括Restore文件和Schema文件,存储了数据文件的元数据信息。可通过sys_dir配置项进行配置(详情见[sys_dir配置项](/#/Documents/progress/chap3/sec2))。 Review comment: Restore files no longer exists. 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335786803 ## File path: docs/Documentation/UserGuide/2-Concept/3-Encoding.md ## @@ -32,13 +32,13 @@ PLAIN encoding, the default encoding mode, i.e, no encoding, supports multiple d Second-order differential encoding is more suitable for encoding monotonically increasing or decreasing sequence data, and is not recommended for sequence data with large fluctuations. -Second-order differential encoding can also be used to encode floating-point numbers, but it is necessary to specify reserved decimal digits (MAX\_POINT\_NUMBER, see [this page](/#/Documents/0.8.0/chap5/sec1) for more information on how to specify) when creating time series. It is more suitable for storing sequence data where floating-point values appear continuously, monotonously increase or decrease, and it is not suitable for storing sequence data with high precision requirements after the decimal point or with large fluctuations. +Second-order differential encoding can also be used to encode floating-point numbers, but it is necessary to specify reserved decimal digits (MAX\_POINT\_NUMBER, see [this page](/#/Documents/progress/chap5/sec1) for more information on how to specify) when creating time series. It is more suitable for storing sequence data where floating-point values appear continuously, monotonously increase or decrease, and it is not suitable for storing sequence data with high precision requirements after the decimal point or with large fluctuations. * RLE Run-length encoding is more suitable for storing sequence with continuous integer values, and is not recommended for sequence data with most of the time different values. -Run-length encoding can also be used to encode floating-point numbers, but it is necessary to specify reserved decimal digits (MAX\_POINT\_NUMBER, see [this page](/#/Documents/0.8.0/chap5/sec1) for more information on how to specify) when creating time series. It is more suitable for storing sequence data where floating-point values appear continuously, monotonously increase or decrease, and it is not suitable for storing sequence data with high precision requirements after the decimal point or with large fluctuations. +Run-length encoding can also be used to encode floating-point numbers, but it is necessary to specify reserved decimal digits (MAX\_POINT\_NUMBER, see [this page](/#/Documents/progress/chap5/sec1) for more information on how to specify) when creating time series. It is more suitable for storing sequence data where floating-point values appear continuously, monotonously increase or decrease, and it is not suitable for storing sequence data with high precision requirements after the decimal point or with large fluctuations. Review comment: "monotonously increase or decrease" -> "monotonously increasing or decreasing" 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335349270 ## File path: docs/Documentation-CHN/UserGuide/4-Operation Manual/2-Data Model Selection.md ## @@ -109,6 +116,6 @@ IoTDB> show timeseries root.ln 0.7.0版本对用户操作的数据规模进行一些限制: Review comment: 0.7.0 -> 当前 I understand the main purpose of this PR is not correcting. But if you could fix them I would be grateful. 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335789537 ## File path: docs/Documentation/UserGuide/2-Concept/4-Compression.md ## @@ -25,4 +25,4 @@ When the time series is written and encoded as binary data according to the specified type, IoTDB compresses the data using compression technology to further improve space storage efficiency. Although both encoding and compression are designed to improve storage efficiency, encoding techniques are usually only available for specific data types (e.g., second-order differential encoding is only suitable for INT32 or INT64 data type, and storing floating-point numbers requires multiplying them by 10m to convert to integers), after which the data is converted to a binary stream. The compression method (SNAPPY) compresses the binary stream, so the use of the compression method is no longer limited by the data type. -IoTDB allows you to specify the compression method of the column when creating a time series. IoTDB now supports two kinds of compression: UNCOMPRESSED (no compression) and SNAPPY compression. The specified syntax for compression is detailed in [Create Timeseries Statement](/#/Documents/0.8.0/chap5/sec1). \ No newline at end of file +IoTDB allows you to specify the compression method of the column when creating a time series. IoTDB now supports two kinds of compression: UNCOMPRESSED (no compression) and SNAPPY compression. The specified syntax for compression is detailed in [Create Timeseries Statement](/#/Documents/progress/chap4/sec7). Review comment: There are more compressors now, please refer to `org.apache.iotdb.tsfile.file.metadata.enums.CompressionType` and update. 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335786164 ## File path: docs/Documentation/UserGuide/2-Concept/2-Data Type.md ## @@ -31,7 +31,7 @@ IoTDB supports six data types in total: * TEXT (String). -The time series of **FLOAT** and **DOUBLE** type can specify (MAX\_POINT\_NUMBER, see [this page](/#/Documents/0.8.0/chap5/sec1) for more information on how to specify), which is the number of digits after the decimal point of the floating point number, if the encoding method is [RLE](/#/Documents/0.8.0/chap2/sec3) or [TS\_2DIFF](/#/Documents/0.8.0/chap2/sec3) (Refer to [Create Timeseries Statement](/#/Documents/0.8.0/chap5/sec1) for more information on how to specify). If MAX\_POINT\_NUMBER is not specified, the system will use [float\_precision](/#/Documents/0.8.0/chap4/sec2) in the configuration file `tsfile-format.properties`. +The time series of **FLOAT** and **DOUBLE** type can specify (MAX\_POINT\_NUMBER, see [this page](/#/Documents/progress/chap5/sec1) for more information on how to specify), which is the number of digits after the decimal point of the floating point number, if the encoding method is [RLE](/#/Documents/progress/chap2/sec3) or [TS\_2DIFF](/#/Documents/progress/chap2/sec3) (Refer to [Create Timeseries Statement](/#/Documents/progress/chap5/sec1) for more information on how to specify). If MAX\_POINT\_NUMBER is not specified, the system will use [float\_precision](/#/Documents/progress/chap4/sec2) in the configuration file `tsfile-format.properties`. Review comment: The positions of brackets in " (MAX\_POINT\_NUMBER, see [this page](/#/Documents/progress/chap5/sec1) for more information on how to specify)" seem strange. I think "MAX\_POINT\_NUMBER" should be outside of the brackets. 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335783141 ## File path: docs/Documentation/UserGuide/1-Overview/4-Features.md ## @@ -24,10 +24,29 @@ ## Features -* Flexible deployment. IoTDB provides users one-click installation tool on the cloud, once-decompressed-used terminal tool and the bridge tool between cloud platform and terminal tool (Data Synchronization Tool). -* Low cost on hardware. IoTDB can reach a high compression ratio of disk storage (For one billion data storage, hard drive cost less than $0.23) -* Efficient directory structure. IoTDB supports efficient oganization for complex timeseries data structure from intelligent networking devices, oganization for timeseries data from devices of the same type, fuzzy searching strategy for massive and complex directory of timeseries data. -* High-throughput read and write. IoTDB supports millions of low-power devices' strong connection data access, high-speed data read and write for intelligent networking devices and mixed devices mentioned above. -* Rich query semantics. IoTDB supports time alignment for timeseries data accross devices and sensors, computation in timeseries field (frequency domain transformation) and rich aggregation function support in time dimension. -* Easy to get start. IoTDB supports SQL-Like language, JDBC standard API and import/export tools which is easy to use. -* Intense integration with Open Source Ecosystem. IoTDB supports Hadoop, Spark, etc. analysis ecosystems and Grafana visualization tool. +* Flexible deployment. + +IoTDB provides users one-click installation tool on the cloud, once-decompressed-used terminal tool and the bridge tool between cloud platform and terminal tool (Data Synchronization Tool). Review comment: "bridge tool" -> "bridging tool" "platform" -> "platforms" "terminal tool" -> "terminal tools" (maybe "end tools") 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335350625 ## File path: docs/Documentation-CHN/UserGuide/4-Operation Manual/3-Data Import.md ## @@ -28,12 +28,12 @@ ### 实时数据接入 -IoTDB为用户提供多种插入实时数据的方式,例如在[Cli/Shell工具](/#/Tools/Cli)中直接输入插入数据的[INSERT语句](/#/Documents/0.8.0/chap5/sec1),或使用Java API(标准[Java JDBC](/#/Documents/0.8.0/chap6/sec1)接口)单条或批量执行插入数据的[INSERT语句](/#/Documents/0.8.0/chap5/sec1)。 +IoTDB为用户提供多种插入实时数据的方式,例如在[Cli/Shell工具](/#/Documents/progress/chap4/sec1)中直接输入插入数据的[INSERT语句](/#/Documents/progress/chap4/sec7),或使用Java API(标准[Java JDBC](/#/Documents/progress/chap6/sec1)接口)单条或批量执行插入数据的[INSERT语句](/#/Documents/progress/chap4/sec7)。 -本节主要为您介绍实时数据接入的[INSERT语句](/#/Documents/0.8.0/chap5/sec1)在场景中的实际使用示例,有关INSERT SQL语句的详细语法请参见本文[INSERT语句](/#/Documents/0.8.0/chap5/sec1)节。 +本节主要为您介绍实时数据接入的[INSERT语句](/#/Documents/progress/chap4/sec7)在场景中的实际使用示例,有关INSERT SQL语句的详细语法请参见本文[INSERT语句](/#/Documents/progress/chap4/sec7)节。 使用INSERT语句 -使用[INSERT语句](/#/Documents/0.8.0/chap5/sec1)可以向指定的已经创建的一条或多条时间序列中插入数据。对于每一条数据,均由一个时间戳类型的[时间戳](/#/Documents/0.8.0/chap2/sec1)和一个[数值类型](/#/Documents/0.8.0/chap2/sec2)的传感器采集值组成。 +使用[INSERT语句](/#/Documents/progress/chap4/sec7)可以向指定的已经创建的一条或多条时间序列中插入数据。对于每一条数据,均由一个时间戳类型的[时间戳](/#/Documents/progress/chap2/sec1)和一个[数值类型](/#/Documents/progress/chap2/sec2)的传感器采集值组成。 Review comment: I do not think "数值类型" is precise here since we support non-numeric data types like text and boolean. 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335357264 ## File path: docs/Documentation-CHN/UserGuide/4-Operation Manual/7-IoTDB Query Language.md ## @@ -475,3 +475,117 @@ SELECT SUM(Path) (COMMA SUM(Path))* FROM [WHERE ]? Eg. SELECT SUM(temperature) FROM root.ln.wf01.wt01 WHERE root.ln.wf01.wt01.temperature < 24 Note: the statement needs to satisfy this constraint: + = ``` +## 参考 + +### 关键字 + +``` +Keywords for IoTDB (case insensitive): +ADD, BY, COMPRESSOR, CREATE, DATATYPE, DELETE, DESCRIBE, DROP, ENCODING, EXIT, FROM, GRANT, GROUP, LABLE, LINK, INDEX, INSERT, INTO, LOAD, MAX_POINT_NUMBER, MERGE, METADATA, ON, ORDER, PASSWORD, PRIVILEGES, PROPERTY, QUIT, REVOKE, ROLE, ROOT, SELECT, SET, SHOW, STORAGE, TIME, TIMESERIES, TIMESTAMP, TO, UNLINK, UPDATE, USER, USING, VALUE, VALUES, WHERE, WITH + +Keywords with special meanings (case sensitive): +* Data Types: BOOLEAN, DOUBLE, FLOAT, INT32, INT64, TEXT (Only capitals is acceptable) +* Encoding Methods: BITMAP, DFT, GORILLA, PLAIN, RLE, TS_2DIFF (Only capitals is acceptable) Review comment: I think this requirement is out-dated. @LeiRui 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335844012 ## File path: docs/Documentation/UserGuide/3-Deployment/3-Build and use IoTDB by Dockerfile.md ## @@ -85,7 +85,7 @@ $ start-cli.sh -h localhost -p 6667 -u root -pw root 0.8.0-SNAPSHOT ``` -Some example about how to use IoTDB with IoTDB-JDBC can be found at: https://github.com/apache/incubator-iotdb/tree/master/jdbc/src/test/java/org/apache/iotdb/jdbc/demo +Some example about how to use IoTDB with IoTDB-JDBC can be found at: https://github.com/apache/incubator-iotdb/tree/master/example/jdbc/src/main/java/org/apache/iotdb (Notice that because we have not published Apache IoTDB version 0.8.0 now, you have to compile the source code by `mvn install -DskipTests` to install the dependence into your local maven repository) Review comment: This is outdated. 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335843628 ## File path: docs/Documentation/UserGuide/3-Deployment/3-Build and use IoTDB by Dockerfile.md ## @@ -85,7 +85,7 @@ $ start-cli.sh -h localhost -p 6667 -u root -pw root 0.8.0-SNAPSHOT ``` -Some example about how to use IoTDB with IoTDB-JDBC can be found at: https://github.com/apache/incubator-iotdb/tree/master/jdbc/src/test/java/org/apache/iotdb/jdbc/demo +Some example about how to use IoTDB with IoTDB-JDBC can be found at: https://github.com/apache/incubator-iotdb/tree/master/example/jdbc/src/main/java/org/apache/iotdb Review comment: "example" -> "examples" 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335358169 ## File path: docs/Documentation-CHN/UserGuide/4-Operation Manual/7-IoTDB Query Language.md ## @@ -475,3 +475,117 @@ SELECT SUM(Path) (COMMA SUM(Path))* FROM [WHERE ]? Eg. SELECT SUM(temperature) FROM root.ln.wf01.wt01 WHERE root.ln.wf01.wt01.temperature < 24 Note: the statement needs to satisfy this constraint: + = ``` +## 参考 + +### 关键字 + +``` +Keywords for IoTDB (case insensitive): +ADD, BY, COMPRESSOR, CREATE, DATATYPE, DELETE, DESCRIBE, DROP, ENCODING, EXIT, FROM, GRANT, GROUP, LABLE, LINK, INDEX, INSERT, INTO, LOAD, MAX_POINT_NUMBER, MERGE, METADATA, ON, ORDER, PASSWORD, PRIVILEGES, PROPERTY, QUIT, REVOKE, ROLE, ROOT, SELECT, SET, SHOW, STORAGE, TIME, TIMESERIES, TIMESTAMP, TO, UNLINK, UPDATE, USER, USING, VALUE, VALUES, WHERE, WITH + +Keywords with special meanings (case sensitive): +* Data Types: BOOLEAN, DOUBLE, FLOAT, INT32, INT64, TEXT (Only capitals is acceptable) +* Encoding Methods: BITMAP, DFT, GORILLA, PLAIN, RLE, TS_2DIFF (Only capitals is acceptable) +* Compression Methods: UNCOMPRESSED, SNAPPY (Only capitals is acceptable) +* Logical symbol: AND, &, &&, OR, | , ||, NOT, !, TRUE, FALSE +``` + +### 标识符 + +``` +QUOTE := '\''; +DOT := '.'; +COLON : ':' ; +COMMA := ',' ; +SEMICOLON := ';' ; +LPAREN := '(' ; +RPAREN := ')' ; +LBRACKET := '['; +RBRACKET := ']'; +EQUAL := '=' | '=='; +NOTEQUAL := '<>' | '!='; +LESSTHANOREQUALTO := '<='; +LESSTHAN := '<'; +GREATERTHANOREQUALTO := '>='; +GREATERTHAN := '>'; +DIVIDE := '/'; +PLUS := '+'; +MINUS := '-'; +STAR := '*'; +Letter := 'a'..'z' | 'A'..'Z'; +HexDigit := 'a'..'f' | 'A'..'F'; +Digit := '0'..'9'; +Boolean := TRUE | FALSE | 0 | 1 (case insensitive) + +``` + +``` +StringLiteral := ( '\'' ( ~('\'') )* '\'' | '\"' ( ~('\"') )* '\"'); +eg. ‘abc’ +eg. “abc” Review comment: The examples seem to be using Chinese quotes, which can be misleading. 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335785046 ## File path: docs/Documentation/UserGuide/2-Concept/1-Key Concepts and Terminology.md ## @@ -59,7 +59,7 @@ path: LayerName (DOT LayerName)+ LayerName: Identifier | STAR ``` -Among them, STAR is "*" and DOT is ".". +Among them, STAR is "* " and DOT is ".". Review comment: Why adding a space 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. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335783237 ## File path: docs/Documentation/UserGuide/1-Overview/4-Features.md ## @@ -24,10 +24,29 @@ ## Features -* Flexible deployment. IoTDB provides users one-click installation tool on the cloud, once-decompressed-used terminal tool and the bridge tool between cloud platform and terminal tool (Data Synchronization Tool). -* Low cost on hardware. IoTDB can reach a high compression ratio of disk storage (For one billion data storage, hard drive cost less than $0.23) -* Efficient directory structure. IoTDB supports efficient oganization for complex timeseries data structure from intelligent networking devices, oganization for timeseries data from devices of the same type, fuzzy searching strategy for massive and complex directory of timeseries data. -* High-throughput read and write. IoTDB supports millions of low-power devices' strong connection data access, high-speed data read and write for intelligent networking devices and mixed devices mentioned above. -* Rich query semantics. IoTDB supports time alignment for timeseries data accross devices and sensors, computation in timeseries field (frequency domain transformation) and rich aggregation function support in time dimension. -* Easy to get start. IoTDB supports SQL-Like language, JDBC standard API and import/export tools which is easy to use. -* Intense integration with Open Source Ecosystem. IoTDB supports Hadoop, Spark, etc. analysis ecosystems and Grafana visualization tool. +* Flexible deployment. + +IoTDB provides users one-click installation tool on the cloud, once-decompressed-used terminal tool and the bridge tool between cloud platform and terminal tool (Data Synchronization Tool). + +* Low cost on hardware. Review comment: "Low storage cost" suits better. 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335354718 ## File path: docs/Documentation-CHN/UserGuide/4-Operation Manual/5-Data Maintenance.md ## @@ -54,9 +54,9 @@ Msg: do not select any existing series ### 数据删除 -用户使用[DELETE语句](/#/Documents/0.8.0/chap5/sec1)可以删除指定的时间序列中符合时间删除条件的数据。在删除数据时,用户可以选择需要删除的一个或多个时间序列、时间序列的前缀、时间序列带*路径对某时间之前的数据进行删除(0.8.0版本暂不支持删除某一闭时间区间范围内的数据)。 +用户使用[DELETE语句](/#/Documents/progress/chap4/sec7)可以删除指定的时间序列中符合时间删除条件的数据。在删除数据时,用户可以选择需要删除的一个或多个时间序列、时间序列的前缀、时间序列带*路径对某时间之前的数据进行删除(0.8.0版本暂不支持删除某一闭时间区间范围内的数据)。 Review comment: The "*" should be escaped. And it would be better to replace "0.8.0版本" with "当前版本", so you do not need to change it when the version has changed unless the description itself is out-dated. 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335784774 ## File path: docs/Documentation/UserGuide/1-Overview/4-Features.md ## @@ -24,10 +24,29 @@ ## Features -* Flexible deployment. IoTDB provides users one-click installation tool on the cloud, once-decompressed-used terminal tool and the bridge tool between cloud platform and terminal tool (Data Synchronization Tool). -* Low cost on hardware. IoTDB can reach a high compression ratio of disk storage (For one billion data storage, hard drive cost less than $0.23) -* Efficient directory structure. IoTDB supports efficient oganization for complex timeseries data structure from intelligent networking devices, oganization for timeseries data from devices of the same type, fuzzy searching strategy for massive and complex directory of timeseries data. -* High-throughput read and write. IoTDB supports millions of low-power devices' strong connection data access, high-speed data read and write for intelligent networking devices and mixed devices mentioned above. -* Rich query semantics. IoTDB supports time alignment for timeseries data accross devices and sensors, computation in timeseries field (frequency domain transformation) and rich aggregation function support in time dimension. -* Easy to get start. IoTDB supports SQL-Like language, JDBC standard API and import/export tools which is easy to use. -* Intense integration with Open Source Ecosystem. IoTDB supports Hadoop, Spark, etc. analysis ecosystems and Grafana visualization tool. +* Flexible deployment. + +IoTDB provides users one-click installation tool on the cloud, once-decompressed-used terminal tool and the bridge tool between cloud platform and terminal tool (Data Synchronization Tool). + +* Low cost on hardware. + +IoTDB can reach a high compression ratio of disk storage (For one billion data storage, hard drive cost less than $0.23) + +* Efficient directory structure. + +IoTDB supports efficient oganization for complex timeseries data structure from intelligent networking devices, oganization for timeseries data from devices of the same type, fuzzy searching strategy for massive and complex directory of timeseries data. +* High-throughput read and write. + +IoTDB supports millions of low-power devices' strong connection data access, high-speed data read and write for intelligent networking devices and mixed devices mentioned above. + +* Rich query semantics. + +IoTDB supports time alignment for timeseries data accross devices and sensors, computation in timeseries field (frequency domain transformation) and rich aggregation function support in time dimension. + +* Easy to get start. + +IoTDB supports SQL-Like language, JDBC standard API and import/export tools which is easy to use. Review comment: "which is" -> "which are" 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335783581 ## File path: docs/Documentation/UserGuide/1-Overview/4-Features.md ## @@ -24,10 +24,29 @@ ## Features -* Flexible deployment. IoTDB provides users one-click installation tool on the cloud, once-decompressed-used terminal tool and the bridge tool between cloud platform and terminal tool (Data Synchronization Tool). -* Low cost on hardware. IoTDB can reach a high compression ratio of disk storage (For one billion data storage, hard drive cost less than $0.23) -* Efficient directory structure. IoTDB supports efficient oganization for complex timeseries data structure from intelligent networking devices, oganization for timeseries data from devices of the same type, fuzzy searching strategy for massive and complex directory of timeseries data. -* High-throughput read and write. IoTDB supports millions of low-power devices' strong connection data access, high-speed data read and write for intelligent networking devices and mixed devices mentioned above. -* Rich query semantics. IoTDB supports time alignment for timeseries data accross devices and sensors, computation in timeseries field (frequency domain transformation) and rich aggregation function support in time dimension. -* Easy to get start. IoTDB supports SQL-Like language, JDBC standard API and import/export tools which is easy to use. -* Intense integration with Open Source Ecosystem. IoTDB supports Hadoop, Spark, etc. analysis ecosystems and Grafana visualization tool. +* Flexible deployment. + +IoTDB provides users one-click installation tool on the cloud, once-decompressed-used terminal tool and the bridge tool between cloud platform and terminal tool (Data Synchronization Tool). + +* Low cost on hardware. + +IoTDB can reach a high compression ratio of disk storage (For one billion data storage, hard drive cost less than $0.23) Review comment: This number should be checked or deprecated. As storage getting cheaper, this number could be ridiculously high. 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335353887 ## File path: docs/Documentation-CHN/UserGuide/4-Operation Manual/4-Data Query.md ## @@ -282,11 +282,11 @@ select temperature from root.sgcc.wf03.wt01 where time = 2017-11-01T16:37:50.000 > 注意: 0.7.0版本中Fill语句内至少指定一种填充类型。 ### 查询结果的分页控制 -为方便用户在对IoTDB进行查询时更好的进行结果阅读,IoTDB为用户提供了[LIMIT/SLIMIT](/#/Documents/0.8.0/chap5/sec1)子句以及[OFFSET/SOFFSET](/#/Documents/0.8.0/chap5/sec1)子句。使用LIMIT和SLIMIT子句可以允许用户对查询结果的行数和列数进行控制,使用OFFSET和SOFFSET子句可以允许用户设定结果展示的起始位置。 +为方便用户在对IoTDB进行查询时更好的进行结果阅读,IoTDB为用户提供了[LIMIT/SLIMIT](/#/Documents/progress/chap4/sec7)子句以及[OFFSET/SOFFSET](/#/Documents/progress/chap4/sec7)子句。使用LIMIT和SLIMIT子句可以允许用户对查询结果的行数和列数进行控制,使用OFFSET和SOFFSET子句可以允许用户设定结果展示的起始位置。 值得说明的是,LIMIT/SLIMIT子句以及OFFSET/SOFFSET子句均不改变查询的实际执行过程,仅对查询返回的结果进行约束。 Review comment: I think at least SLIMIT does change the procedure now, am I right? @LeiRui 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: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-iotdb] jt2594838 commented on a change in pull request #450: modify documents
jt2594838 commented on a change in pull request #450: modify documents URL: https://github.com/apache/incubator-iotdb/pull/450#discussion_r335784655 ## File path: docs/Documentation/UserGuide/1-Overview/4-Features.md ## @@ -24,10 +24,29 @@ ## Features -* Flexible deployment. IoTDB provides users one-click installation tool on the cloud, once-decompressed-used terminal tool and the bridge tool between cloud platform and terminal tool (Data Synchronization Tool). -* Low cost on hardware. IoTDB can reach a high compression ratio of disk storage (For one billion data storage, hard drive cost less than $0.23) -* Efficient directory structure. IoTDB supports efficient oganization for complex timeseries data structure from intelligent networking devices, oganization for timeseries data from devices of the same type, fuzzy searching strategy for massive and complex directory of timeseries data. -* High-throughput read and write. IoTDB supports millions of low-power devices' strong connection data access, high-speed data read and write for intelligent networking devices and mixed devices mentioned above. -* Rich query semantics. IoTDB supports time alignment for timeseries data accross devices and sensors, computation in timeseries field (frequency domain transformation) and rich aggregation function support in time dimension. -* Easy to get start. IoTDB supports SQL-Like language, JDBC standard API and import/export tools which is easy to use. -* Intense integration with Open Source Ecosystem. IoTDB supports Hadoop, Spark, etc. analysis ecosystems and Grafana visualization tool. +* Flexible deployment. + +IoTDB provides users one-click installation tool on the cloud, once-decompressed-used terminal tool and the bridge tool between cloud platform and terminal tool (Data Synchronization Tool). + +* Low cost on hardware. + +IoTDB can reach a high compression ratio of disk storage (For one billion data storage, hard drive cost less than $0.23) + +* Efficient directory structure. + +IoTDB supports efficient oganization for complex timeseries data structure from intelligent networking devices, oganization for timeseries data from devices of the same type, fuzzy searching strategy for massive and complex directory of timeseries data. +* High-throughput read and write. + +IoTDB supports millions of low-power devices' strong connection data access, high-speed data read and write for intelligent networking devices and mixed devices mentioned above. + +* Rich query semantics. + +IoTDB supports time alignment for timeseries data accross devices and sensors, computation in timeseries field (frequency domain transformation) and rich aggregation function support in time dimension. + +* Easy to get start. Review comment: "get start" -> "get started" 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: us...@infra.apache.org With regards, Apache Git Services