assets/js/340.751471a6.js

(window.webpackJsonp=window.webpackJsonp||[]).push([[340],{737:function(t,s,a){"use strict";a.r(s);var e=a(29),n=Object(e.a)({},(function(){var t=this,s=t._self._c;return s("ContentSlotsDistributor",{attrs:{"slot-key":t.$parent.slotKey}},[s("h1",{attrs:{id:"select-expression"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#select-expression"}},[t._v("#")]),t._v(" Select Expression")]),t._v(" "),s("h2",{attrs:{id:"syntax-definition"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#syntax-definition"}},[t._v("#")]),t._v(" Syntax Definition")]),t._v(" "),s("p",[t._v("A selection expression ("),s("code",[t._v("selectExpr")]),t._v(") is a component of a SELECT clause, each "),s("code",[t._v("selectExpr")]),t._v(" corresponds to a column in the query result set, and its syntax is defined as follows:")]),t._v(" "),s("div",{staticClass:"language-sql line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-sql"}},[s("code",[t._v("selectClause\n    : "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("SELECT")]),t._v(" resultColumn "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("','")]),t._v(" resultColumn"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("*")]),t._v("\n    "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v("\n\nresultColumn\n    : selectExpr "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("AS")]),t._v(" alias"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v("?\n    "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v("\n\nselectExpr\n    : "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'('")]),t._v(" selectExpr "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("')'")]),t._v("\n    "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("|")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'-'")]),t._v(" selectExpr\n    "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("|")]),t._v(" selectExpr "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'*'")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("|")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'/'")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("|")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'%'")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" selectExpr\n    "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("|")]),t._v(" selectExpr "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'+'")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("|")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'-'")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" selectExpr\n    "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("|")]),t._v(" functionName "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'('")]),t._v(" selectExpr "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("','")]),t._v(" selectExpr"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("*")]),t._v(" functionAttribute"),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("*")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("')'")]),t._v("\n    "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("|")]),t._v(" timeSeriesSuffixPath\n    "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("|")]),t._v(" number\n    "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v("\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br"),s("span",{staticClass:"line-number"},[t._v("8")]),s("br"),s("span",{staticClass:"line-number"},[t._v("9")]),s("br"),s("span",{staticClass:"line-number"},[t._v("10")]),s("br"),s("span",{staticClass:"line-number"},[t._v("11")]),s("br"),s("span",{staticClass:"line-number"},[t._v("12")]),s("br"),s("span",{staticClass:"line-number"},[t._v("13")]),s("br"),s("span",{staticClass:"line-number"},[t._v("14")]),s("br"),s("span",{staticClass:"line-number"},[t._v("15")]),s("br"),s("span",{staticClass:"line-number"},[t._v("16")]),s("br"),s("span",{staticClass:"line-number"},[t._v("17")]),s("br")])]),s("p",[t._v("From this syntax definition, "),s("code",[t._v("selectExpr")]),t._v(" can contain:")]),t._v(" "),s("ul",[s("li",[t._v("suffix of time series path")]),t._v(" "),s("li",[t._v("function\n"),s("ul",[s("li",[t._v("Built-in aggregation functions, see "),s("RouterLink",{attrs:{to:"/UserGuide/V0.13.x/Query-Data/Aggregate-Query.html"}},[t._v("Aggregate Query")]),t._v(" for details.")],1),t._v(" "),s("li",[t._v("Time series generation function")]),t._v(" "),s("li",[t._v("User-defined functions, see "),s("RouterLink",{attrs:{to:"/UserGuide/V0.13.x/Process-Data/UDF-User-Defined-Function.html"}},[t._v("UDF")]),t._v(" for details.")],1)])]),t._v(" "),s("li",[t._v("expressions\n"),s("ul",[s("li",[t._v("Arithmetic operation expressions")]),t._v(" "),s("li",[t._v("Time series generating nested expressions")]),t._v(" "),s("li",[t._v("Aggregate query nested expressions")])])]),t._v(" "),s("li",[t._v("Numeric constants (could be used in expressions only)")])]),t._v(" "),s("h2",{attrs:{id:"arithmetic-query"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#arithmetic-query"}},[t._v("#")]),t._v(" Arithmetic Query")]),t._v(" "),s("blockquote",[s("p",[t._v("Please note that Aligned Timeseries has not been supported in Arithmetic Query yet. An error message is expected if you use Arithmetic Query with Aligned Timeseries selected.")])]),t._v(" "),s("h3",{attrs:{id:"operators"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#operators"}},[t._v("#")]),t._v(" Operators")]),t._v(" "),s("h4",{attrs:{id:"unary-arithmetic-operators"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#unary-arithmetic-operators"}},[t._v("#")]),t._v(" Unary Arithmetic Operators")]),t._v(" "),s("p",[t._v("Supported operators: "),s("code",[t._v("+")]),t._v(", "),s("code",[t._v("-")])]),t._v(" "),s("p",[t._v("Supported input data types: "),s("code",[t._v("INT32")]),t._v(", "),s("code",[t._v("INT64")]),t._v(", "),s("code",[t._v("FLOAT")]),t._v(" and "),s("code",[t._v("DOUBLE")])]),t._v(" "),s("p",[t._v("Output data type: consistent with the input data type")]),t._v(" "),s("h4",{attrs:{id:"binary-arithmetic-operators"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#binary-arithmetic-operators"}},[t._v("#")]),t._v(" Binary Arithmetic Operators")]),t._v(" "),s("p",[t._v("Supported operators: "),s("code",[t._v("+")]),t._v(", "),s("code",[t._v("-")]),t._v(", "),s("code",[t._v("*")]),t._v(", "),s("code",[t._v("/")]),t._v(", "),s("code",[t._v("%")])]),t._v(" "),s("p",[t._v("Supported input data types: "),s("code",[t._v("INT32")]),t._v(", "),s("code",[t._v("INT64")]),t._v(", "),s("code",[t._v("FLOAT")]),t._v(" and "),s("code",[t._v("DOUBLE")])]),t._v(" "),s("p",[t._v("Output data type: "),s("code",[t._v("DOUBLE")])]),t._v(" "),s("p",[t._v("Note: Only when the left operand and the right operand under a certain timestamp are not  "),s("code",[t._v("null")]),t._v(", the binary arithmetic operation will have an output value.")]),t._v(" "),s("h3",{attrs:{id:"example"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#example"}},[t._v("#")]),t._v(" Example")]),t._v(" "),s("div",{staticClass:"language-sql line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-sql"}},[s("code",[s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("select")]),t._v(" s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("-")]),t._v(" s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" s2"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" s2"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" s1 "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" s2"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" s1 "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("-")]),t._v(" s2"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" s1 "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("*")]),t._v(" s2"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" s1 "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("/")]),t._v(" s2"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" s1 "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("%")]),t._v(" s2 "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("from")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("sg"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("d1\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br")])]),s("p",[t._v("Result:")]),t._v(" "),s("div",{staticClass:"language- line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-text"}},[s("code",[t._v("+-----------------------------+-------------+--------------+-------------+-------------+-----------------------------+-----------------------------+-----------------------------+-----------------------------+-----------------------------+\n|                         Time|root.sg.d1.s1|-root.sg.d1.s1|root.sg.d1.s2|root.sg.d1.s2|root.sg.d1.s1 + root.sg.d1.s2|root.sg.d1.s1 - root.sg.d1.s2|root.sg.d1.s1 * root.sg.d1.s2|root.sg.d1.s1 / root.sg.d1.s2|root.sg.d1.s1 % root.sg.d1.s2|\n+-----------------------------+-------------+--------------+-------------+-------------+-----------------------------+-----------------------------+-----------------------------+-----------------------------+-----------------------------+\n|1970-01-01T08:00:00.001+08:00|          1.0|          -1.0|          1.0|          1.0|                          2.0|                          0.0|                          1.0|                          1.0|                          0.0|\n|1970-01-01T08:00:00.002+08:00|          2.0|          -2.0|          2.0|          2.0|                          4.0|                          0.0|                          4.0|                          1.0|                          0.0|\n|1970-01-01T08:00:00.003+08:00|          3.0|          -3.0|          3.0|          3.0|                          6.0|                          0.0|                          9.0|                          1.0|                          0.0|\n|1970-01-01T08:00:00.004+08:00|          4.0|          -4.0|          4.0|          4.0|                          8.0|                          0.0|                         16.0|                          1.0|                          0.0|\n|1970-01-01T08:00:00.005+08:00|          5.0|          -5.0|          5.0|          5.0|                         10.0|                          0.0|                         25.0|                          1.0|                          0.0|\n+-----------------------------+-------------+--------------+-------------+-------------+-----------------------------+-----------------------------+-----------------------------+-----------------------------+-----------------------------+\nTotal line number = 5\nIt costs 0.014s\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br"),s("span",{staticClass:"line-number"},[t._v("8")]),s("br"),s("span",{staticClass:"line-number"},[t._v("9")]),s("br"),s("span",{staticClass:"line-number"},[t._v("10")]),s("br"),s("span",{staticClass:"line-number"},[t._v("11")]),s("br")])]),s("h2",{attrs:{id:"time-series-generating-functions"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#time-series-generating-functions"}},[t._v("#")]),t._v(" Time Series Generating Functions")]),t._v(" "),s("p",[t._v("The time series generating function takes several time series as input and outputs one time series. Unlike the aggregation function, the result set of the time series generating function has a timestamp column.")]),t._v(" "),s("p",[t._v("All time series generating functions can accept * as input.")]),t._v(" "),s("p",[t._v("IoTDB supports hybrid queries of time series generating function queries and raw data queries.")]),t._v(" "),s("blockquote",[s("p",[t._v("Please note that Aligned Timeseries has not been supported in queries with hybrid functions yet. An error message is expected if you use hybrid functions with Aligned Timeseries selected in a query statement.")])]),t._v(" "),s("h3",{attrs:{id:"mathematical-functions"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#mathematical-functions"}},[t._v("#")]),t._v(" Mathematical Functions")]),t._v(" "),s("p",[t._v("Currently, IoTDB supports the following mathematical functions. The behavior of these mathematical functions is consistent with the behavior of these functions in the Java Math standard library.")]),t._v(" "),s("table",[s("thead",[s("tr",[s("th",[t._v("Function Name")]),t._v(" "),s("th",[t._v("Allowed Input Series Data Types")]),t._v(" "),s("th",[t._v("Output Series Data Type")]),t._v(" "),s("th",[t._v("Corresponding Implementation in the Java Standard Library")])])]),t._v(" "),s("tbody",[s("tr",[s("td",[t._v("SIN")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Math#sin(double)")])]),t._v(" "),s("tr",[s("td",[t._v("COS")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Math#cos(double)")])]),t._v(" "),s("tr",[s("td",[t._v("TAN")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Math#tan(double)")])]),t._v(" "),s("tr",[s("td",[t._v("ASIN")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Math#asin(double)")])]),t._v(" "),s("tr",[s("td",[t._v("ACOS")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Math#acos(double)")])]),t._v(" "),s("tr",[s("td",[t._v("ATAN")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Math#atan(double)")])]),t._v(" "),s("tr",[s("td",[t._v("SINH")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Math#sinh(double)")])]),t._v(" "),s("tr",[s("td",[t._v("COSH")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Math#cosh(double)")])]),t._v(" "),s("tr",[s("td",[t._v("TANH")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Math#tanh(double)")])]),t._v(" "),s("tr",[s("td",[t._v("DEGREES")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Math#toDegrees(double)")])]),t._v(" "),s("tr",[s("td",[t._v("RADIANS")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Math#toRadians(double)")])]),t._v(" "),s("tr",[s("td",[t._v("ABS")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("Same type as the input series")]),t._v(" "),s("td",[t._v("Math#abs(int) / Math#abs(long) /Math#abs(float) /Math#abs(double)")])]),t._v(" "),s("tr",[s("td",[t._v("SIGN")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Math#signum(double)")])]),t._v(" "),s("tr",[s("td",[t._v("CEIL")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Math#ceil(double)")])]),t._v(" "),s("tr",[s("td",[t._v("FLOOR")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Math#floor(double)")])]),t._v(" "),s("tr",[s("td",[t._v("ROUND")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Math#rint(double)")])]),t._v(" "),s("tr",[s("td",[t._v("EXP")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Math#exp(double)")])]),t._v(" "),s("tr",[s("td",[t._v("LN")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Math#log(double)")])]),t._v(" "),s("tr",[s("td",[t._v("LOG10")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Math#log10(double)")])]),t._v(" "),s("tr",[s("td",[t._v("SQRT")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Math#sqrt(double)")])])])]),t._v(" "),s("p",[t._v("Example:")]),t._v(" "),s("div",{staticClass:"language-sql line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-sql"}},[s("code",[s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("select")]),t._v(" s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" sin"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" cos"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" tan"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("from")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("sg1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("d1 "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("limit")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("5")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("offset")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("1000")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v("\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br")])]),s("p",[t._v("Result:")]),t._v(" "),s("div",{staticClass:"language- line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-text"}},[s("code",[t._v("+-----------------------------+-------------------+-------------------+--------------------+-------------------+\n|                         Time|     root.sg1.d1.s1|sin(root.sg1.d1.s1)| cos(root.sg1.d1.s1)|tan(root.sg1.d1.s1)|\n+-----------------------------+-------------------+-------------------+--------------------+-------------------+\n|2020-12-10T17:11:49.037+08:00|7360723084922759782| 0.8133527237573284|  0.5817708713544664| 1.3980636773094157|\n|2020-12-10T17:11:49.038+08:00|4377791063319964531|-0.8938962705202537|  0.4482738644511651| -1.994085181866842|\n|2020-12-10T17:11:49.039+08:00|7972485567734642915| 0.9627757585308978|-0.27030138509681073|-3.5618602479083545|\n|2020-12-10T17:11:49.040+08:00|2508858212791964081|-0.6073417341629443| -0.7944406950452296| 0.7644897069734913|\n|2020-12-10T17:11:49.041+08:00|2817297431185141819|-0.8419358900502509| -0.5395775727782725| 1.5603611649667768|\n+-----------------------------+-------------------+-------------------+--------------------+-------------------+\nTotal line number = 5\nIt costs 0.008s\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br"),s("span",{staticClass:"line-number"},[t._v("8")]),s("br"),s("span",{staticClass:"line-number"},[t._v("9")]),s("br"),s("span",{staticClass:"line-number"},[t._v("10")]),s("br"),s("span",{staticClass:"line-number"},[t._v("11")]),s("br")])]),s("h3",{attrs:{id:"string-processing-functions"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#string-processing-functions"}},[t._v("#")]),t._v(" String Processing Functions")]),t._v(" "),s("p",[t._v("Currently, IoTDB supports the following string processing functions:")]),t._v(" "),s("table",[s("thead",[s("tr",[s("th",[t._v("Function Name")]),t._v(" "),s("th",[t._v("Allowed Input Series Data Types")]),t._v(" "),s("th",[t._v("Required Attributes")]),t._v(" "),s("th",[t._v("Output Series Data Type")]),t._v(" "),s("th",[t._v("Description")])])]),t._v(" "),s("tbody",[s("tr",[s("td",[t._v("STRING_CONTAINS")]),t._v(" "),s("td",[t._v("TEXT")]),t._v(" "),s("td",[s("code",[t._v("s")]),t._v(": the sequence to search for")]),t._v(" "),s("td",[t._v("BOOLEAN")]),t._v(" "),s("td",[t._v("Determine whether "),s("code",[t._v("s")]),t._v(" is in the string")])]),t._v(" "),s("tr",[s("td",[t._v("STRING_MATCHES")]),t._v(" "),s("td",[t._v("TEXT")]),t._v(" "),s("td",[s("code",[t._v("regex")]),t._v(": the regular expression to which the string is to be matched")]),t._v(" "),s("td",[t._v("BOOLEAN")]),t._v(" "),s("td",[t._v("Determine whether the string can be matched by "),s("code",[t._v("regex")])])])])]),t._v(" "),s("p",[t._v("Example：")]),t._v(" "),s("div",{staticClass:"language-sql line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-sql"}},[s("code",[s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("select")]),t._v(" s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" string_contains"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'s'")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("=")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'warn'")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" string_matches"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'regex'")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("=")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'[^\\\\s]+37229'")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("from")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("sg1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("d4"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v("\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br")])]),s("p",[t._v("Result：")]),t._v(" "),s("div",{staticClass:"language- line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-text"}},[s("code",[t._v('+-----------------------------+--------------+-------------------------------------------+------------------------------------------------------+\n|                         Time|root.sg1.d4.s1|string_contains(root.sg1.d4.s1, "s"="warn")|string_matches(root.sg1.d4.s1, "regex"="[^\\\\s]+37229")|\n+-----------------------------+--------------+-------------------------------------------+------------------------------------------------------+\n|1970-01-01T08:00:00.001+08:00|    warn:-8721|                                       true|                                                 false|\n|1970-01-01T08:00:00.002+08:00|  error:-37229|                                      false|                                                  true|\n|1970-01-01T08:00:00.003+08:00|     warn:1731|                                       true|                                                 false|\n+-----------------------------+--------------+-------------------------------------------+------------------------------------------------------+\nTotal line number = 3\nIt costs 0.007s\n')])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br"),s("span",{staticClass:"line-number"},[t._v("8")]),s("br"),s("span",{staticClass:"line-number"},[t._v("9")]),s("br")])]),s("h3",{attrs:{id:"selector-functions"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#selector-functions"}},[t._v("#")]),t._v(" Selector Functions")]),t._v(" "),s("p",[t._v("Currently, IoTDB supports the following selector functions:")]),t._v(" "),s("table",[s("thead",[s("tr",[s("th",[t._v("Function Name")]),t._v(" "),s("th",[t._v("Allowed Input Series Data Types")]),t._v(" "),s("th",[t._v("Required Attributes")]),t._v(" "),s("th",[t._v("Output Series Data Type")]),t._v(" "),s("th",[t._v("Description")])])]),t._v(" "),s("tbody",[s("tr",[s("td",[t._v("TOP_K")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE / TEXT")]),t._v(" "),s("td",[s("code",[t._v("k")]),t._v(": the maximum number of selected data points, must be greater than 0 and less than or equal to 1000")]),t._v(" "),s("td",[t._v("Same type as the input series")]),t._v(" "),s("td",[t._v("Returns "),s("code",[t._v("k")]),t._v(" data points with the largest values in a time series.")])]),t._v(" "),s("tr",[s("td",[t._v("BOTTOM_K")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE / TEXT")]),t._v(" "),s("td",[s("code",[t._v("k")]),t._v(": the maximum number of selected data points, must be greater than 0 and less than or equal to 1000")]),t._v(" "),s("td",[t._v("Same type as the input series")]),t._v(" "),s("td",[t._v("Returns "),s("code",[t._v("k")]),t._v(" data points with the smallest values in a time series.")])])])]),t._v(" "),s("p",[t._v("Example：")]),t._v(" "),s("div",{staticClass:"language-sql line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-sql"}},[s("code",[s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("select")]),t._v(" s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" top_k"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'k'")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("=")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'2'")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" bottom_k"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'k'")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("=")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'2'")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("from")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("sg1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("d2 "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("where")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("time")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v(">")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("2020")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("-")]),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("12")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("-")]),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("10")]),t._v("T20:"),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("36")]),t._v(":"),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("15.530")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("08")]),t._v(":"),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("00")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v("\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br")])]),s("p",[t._v("Result：")]),t._v(" "),s("div",{staticClass:"language- line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-text"}},[s("code",[t._v('+-----------------------------+--------------------+------------------------------+---------------------------------+\n|                         Time|      root.sg1.d2.s1|top_k(root.sg1.d2.s1, "k"="2")|bottom_k(root.sg1.d2.s1, "k"="2")|\n+-----------------------------+--------------------+------------------------------+---------------------------------+\n|2020-12-10T20:36:15.531+08:00| 1531604122307244742|           1531604122307244742|                             null|\n|2020-12-10T20:36:15.532+08:00|-7426070874923281101|                          null|                             null|\n|2020-12-10T20:36:15.533+08:00|-7162825364312197604|          -7162825364312197604|                             null|\n|2020-12-10T20:36:15.534+08:00|-8581625725655917595|                          null|             -8581625725655917595|\n|2020-12-10T20:36:15.535+08:00|-7667364751255535391|                          null|             -7667364751255535391|\n+-----------------------------+--------------------+------------------------------+---------------------------------+\nTotal line number = 5\nIt costs 0.006s\n')])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br"),s("span",{staticClass:"line-number"},[t._v("8")]),s("br"),s("span",{staticClass:"line-number"},[t._v("9")]),s("br"),s("span",{staticClass:"line-number"},[t._v("10")]),s("br"),s("span",{staticClass:"line-number"},[t._v("11")]),s("br")])]),s("h3",{attrs:{id:"variation-trend-calculation-functions"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#variation-trend-calculation-functions"}},[t._v("#")]),t._v(" Variation Trend Calculation Functions")]),t._v(" "),s("p",[t._v("Currently, IoTDB supports the following variation trend calculation functions:")]),t._v(" "),s("table",[s("thead",[s("tr",[s("th",[t._v("Function Name")]),t._v(" "),s("th",[t._v("Allowed Input Series Data Types")]),t._v(" "),s("th",[t._v("Output Series Data Type")]),t._v(" "),s("th",[t._v("Description")])])]),t._v(" "),s("tbody",[s("tr",[s("td",[t._v("TIME_DIFFERENCE")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE / BOOLEAN / TEXT")]),t._v(" "),s("td",[t._v("INT64")]),t._v(" "),s("td",[t._v("Calculates the difference between the time stamp of a data point and the time stamp of the previous data point. There is no corresponding output for the first data point.")])]),t._v(" "),s("tr",[s("td",[t._v("DIFFERENCE")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("Same type as the input series")]),t._v(" "),s("td",[t._v("Calculates the difference between the value of a data point and the value of the previous data point. There is no corresponding output for the first data point.")])]),t._v(" "),s("tr",[s("td",[t._v("NON_NEGATIVE_DIFFERENCE")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("Same type as the input series")]),t._v(" "),s("td",[t._v("Calculates the absolute value of the difference between the value of a data point and the value of the previous data point. There is no corresponding output for the first data point.")])]),t._v(" "),s("tr",[s("td",[t._v("DERIVATIVE")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Calculates the rate of change of a data point compared to the previous data point, the result is equals to DIFFERENCE / TIME_DIFFERENCE. There is no corresponding output for the first data point.")])]),t._v(" "),s("tr",[s("td",[t._v("NON_NEGATIVE_DERIVATIVE")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Calculates the absolute value of the rate of change of a data point compared to the previous data point, the result is equals to NON_NEGATIVE_DIFFERENCE / TIME_DIFFERENCE. There is no corresponding output for the first data point.")])])])]),t._v(" "),s("p",[t._v("Example:")]),t._v(" "),s("div",{staticClass:"language-sql line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-sql"}},[s("code",[s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("select")]),t._v(" s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" time_difference"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" difference"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" non_negative_difference"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" derivative"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" non_negative_derivative"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("from")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("sg1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("d1 "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("limit")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("5")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("offset")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("1000")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v(" \n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br")])]),s("p",[t._v("Result:")]),t._v(" "),s("div",{staticClass:"language- line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-text"}},[s("code",[t._v("+-----------------------------+-------------------+-------------------------------+--------------------------+---------------------------------------+--------------------------+---------------------------------------+\n|                         Time|     root.sg1.d1.s1|time_difference(root.sg1.d1.s1)|difference(root.sg1.d1.s1)|non_negative_difference(root.sg1.d1.s1)|derivative(root.sg1.d1.s1)|non_negative_derivative(root.sg1.d1.s1)|\n+-----------------------------+-------------------+-------------------------------+--------------------------+---------------------------------------+--------------------------+---------------------------------------+\n|2020-12-10T17:11:49.037+08:00|7360723084922759782|                              1|      -8431715764844238876|                    8431715764844238876|    -8.4317157648442388E18|                  8.4317157648442388E18|\n|2020-12-10T17:11:49.038+08:00|4377791063319964531|                              1|      -2982932021602795251|                    2982932021602795251|     -2.982932021602795E18|                   2.982932021602795E18|\n|2020-12-10T17:11:49.039+08:00|7972485567734642915|                              1|       3594694504414678384|                    3594694504414678384|     3.5946945044146785E18|                  3.5946945044146785E18|\n|2020-12-10T17:11:49.040+08:00|2508858212791964081|                              1|      -5463627354942678834|                    5463627354942678834|     -5.463627354942679E18|                   5.463627354942679E18|\n|2020-12-10T17:11:49.041+08:00|2817297431185141819|                              1|        308439218393177738|                     308439218393177738|     3.0843921839317773E17|                  3.0843921839317773E17|\n+-----------------------------+-------------------+-------------------------------+--------------------------+---------------------------------------+--------------------------+---------------------------------------+\nTotal line number = 5\nIt costs 0.014s\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br"),s("span",{staticClass:"line-number"},[t._v("8")]),s("br"),s("span",{staticClass:"line-number"},[t._v("9")]),s("br"),s("span",{staticClass:"line-number"},[t._v("10")]),s("br"),s("span",{staticClass:"line-number"},[t._v("11")]),s("br")])]),s("h3",{attrs:{id:"constant-timeseries-generating-functions"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#constant-timeseries-generating-functions"}},[t._v("#")]),t._v(" Constant Timeseries Generating Functions")]),t._v(" "),s("p",[t._v("The constant timeseries generating function is used to generate a timeseries in which the values of all data points are the same.")]),t._v(" "),s("p",[t._v("The constant timeseries generating function accepts one or more timeseries inputs, and the timestamp set of the output data points is the union of the timestamp sets of the input timeseries.")]),t._v(" "),s("p",[t._v("Currently, IoTDB supports the following constant timeseries generating functions:")]),t._v(" "),s("table",[s("thead",[s("tr",[s("th",[t._v("Function Name")]),t._v(" "),s("th",[t._v("Required Attributes")]),t._v(" "),s("th",[t._v("Output Series Data Type")]),t._v(" "),s("th",[t._v("Description")])])]),t._v(" "),s("tbody",[s("tr",[s("td",[t._v("CONST")]),t._v(" "),s("td",[s("code",[t._v("value")]),t._v(": the value of the output data point "),s("br"),s("code",[t._v("type")]),t._v(": the type of the output data point, it can only be INT32 / INT64 / FLOAT / DOUBLE / BOOLEAN / TEXT")]),t._v(" "),s("td",[t._v("Determined by the required attribute  "),s("code",[t._v("type")])]),t._v(" "),s("td",[t._v("Output the user-specified constant timeseries according to the  attributes "),s("code",[t._v("value")]),t._v(" and "),s("code",[t._v("type")]),t._v(".")])]),t._v(" "),s("tr",[s("td",[t._v("PI")]),t._v(" "),s("td",[t._v("None")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Data point value: a "),s("code",[t._v("double")]),t._v(" value of  "),s("code",[t._v("π")]),t._v(", the ratio of the circumference of a circle to its diameter, which is equals to "),s("code",[t._v("Math.PI")]),t._v(" in the "),s("em",[t._v("Java Standard Library")]),t._v(".")])]),t._v(" "),s("tr",[s("td",[t._v("E")]),t._v(" "),s("td",[t._v("None")]),t._v(" "),s("td",[t._v("DOUBLE")]),t._v(" "),s("td",[t._v("Data point value: a "),s("code",[t._v("double")]),t._v(" value of  "),s("code",[t._v("e")]),t._v(", the base of the natural logarithms, which is equals to "),s("code",[t._v("Math.E")]),t._v(" in the "),s("em",[t._v("Java Standard Library")]),t._v(".")])])])]),t._v(" "),s("p",[t._v("Example:")]),t._v(" "),s("div",{staticClass:"language-sql line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-sql"}},[s("code",[s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("select")]),t._v(" s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" s2"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" const"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'value'")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("=")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'1024'")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'type'")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("=")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'INT64'")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" pi"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s2"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" e"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" s2"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("from")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("sg1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("d1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v(" \n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br")])]),s("p",[t._v("Result:")]),t._v(" "),s("div",{staticClass:"language- line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-text"}},[s("code",[t._v("select s1, s2, const(s1, 'value'='1024', 'type'='INT64'), pi(s2), e(s1, s2) from root.sg1.d1; \n+-----------------------------+--------------+--------------+-----------------------------------------------------+------------------+---------------------------------+\n|                         Time|root.sg1.d1.s1|root.sg1.d1.s2|const(root.sg1.d1.s1, \"value\"=\"1024\", \"type\"=\"INT64\")|pi(root.sg1.d1.s2)|e(root.sg1.d1.s1, root.sg1.d1.s2)|\n+-----------------------------+--------------+--------------+-----------------------------------------------------+------------------+---------------------------------+\n|1970-01-01T08:00:00.000+08:00|           0.0|           0.0|                                                 1024| 3.141592653589793|                2.718281828459045|\n|1970-01-01T08:00:00.001+08:00|           1.0|          null|                                                 1024|              null|                2.718281828459045|\n|1970-01-01T08:00:00.002+08:00|           2.0|          null|                                                 1024|              null|                2.718281828459045|\n|1970-01-01T08:00:00.003+08:00|          null|           3.0|                                                 null| 3.141592653589793|                2.718281828459045|\n|1970-01-01T08:00:00.004+08:00|          null|           4.0|                                                 null| 3.141592653589793|                2.718281828459045|\n+-----------------------------+--------------+--------------+-----------------------------------------------------+------------------+---------------------------------+\nTotal line number = 5\nIt costs 0.005s\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br"),s("span",{staticClass:"line-number"},[t._v("8")]),s("br"),s("span",{staticClass:"line-number"},[t._v("9")]),s("br"),s("span",{staticClass:"line-number"},[t._v("10")]),s("br"),s("span",{staticClass:"line-number"},[t._v("11")]),s("br"),s("span",{staticClass:"line-number"},[t._v("12")]),s("br")])]),s("h3",{attrs:{id:"data-type-conversion-function"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#data-type-conversion-function"}},[t._v("#")]),t._v(" Data Type Conversion Function")]),t._v(" "),s("p",[t._v("The IoTDB currently supports 6 data types, including INT32, INT64 ,FLOAT, DOUBLE, BOOLEAN, TEXT. When we query or evaluate data, we may need to convert data types, such as TEXT to INT32, or improve the accuracy of the data, such as FLOAT to DOUBLE. Therefore, IoTDB supports the use of cast functions to convert data types.")]),t._v(" "),s("table",[s("thead",[s("tr",[s("th",[t._v("Function Name")]),t._v(" "),s("th",[t._v("Required Attributes")]),t._v(" "),s("th",[t._v("Output Series Data Type")]),t._v(" "),s("th",[t._v("Series Data Type  Description")])])]),t._v(" "),s("tbody",[s("tr",[s("td",[t._v("CAST")]),t._v(" "),s("td",[s("code",[t._v("type")]),t._v(": the type of the output data point, it can only be INT32 / INT64 / FLOAT / DOUBLE / BOOLEAN / TEXT")]),t._v(" "),s("td",[t._v("Determined by the required attribute  "),s("code",[t._v("type")])]),t._v(" "),s("td",[t._v("Converts data to the type specified by the "),s("code",[t._v("type")]),t._v(" argument.")])])])]),t._v(" "),s("h4",{attrs:{id:"notes"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#notes"}},[t._v("#")]),t._v(" Notes")]),t._v(" "),s("ol",[s("li",[t._v("The value of type BOOLEAN is "),s("code",[t._v("true")]),t._v(', when data is converted to BOOLEAN if INT32 and INT64 are not 0, FLOAT and DOUBLE are not 0.0, TEXT is not empty string or "false", otherwise '),s("code",[t._v("false")]),t._v(".")]),t._v(" "),s("li",[t._v('The value of type INT32, INT64, FLOAT, DOUBLE are 1 or 1.0 and TEXT is "true", when BOOLEAN data is true, otherwise 0, 0.0 or "false".')]),t._v(" "),s("li",[t._v("When TEXT is converted to INT32, INT64, or FLOAT, the TEXT is first converted to DOUBLE and then to the corresponding type, which may cause loss of precision. It will skip directly if the data can not be converted.")])]),t._v(" "),s("h4",{attrs:{id:"syntax"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#syntax"}},[t._v("#")]),t._v(" Syntax")]),t._v(" "),s("p",[t._v("Example data:")]),t._v(" "),s("div",{staticClass:"language- line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-text"}},[s("code",[t._v("IoTDB> select text from root.test;\n+-----------------------------+--------------+\n|                         Time|root.test.text|\n+-----------------------------+--------------+\n|1970-01-01T08:00:00.001+08:00|           1.1|\n|1970-01-01T08:00:00.002+08:00|             1|\n|1970-01-01T08:00:00.003+08:00|   hello world|\n|1970-01-01T08:00:00.004+08:00|         false|\n+-----------------------------+--------------+\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br"),s("span",{staticClass:"line-number"},[t._v("8")]),s("br"),s("span",{staticClass:"line-number"},[t._v("9")]),s("br")])]),s("p",[t._v("SQL:")]),t._v(" "),s("div",{staticClass:"language-sql line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-sql"}},[s("code",[s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("select")]),t._v(" cast"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("text")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'type'")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("=")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'BOOLEAN'")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" cast"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("text")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'type'")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("=")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'INT32'")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" cast"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("text")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'type'")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("=")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'INT64'")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" cast"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("text")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'type'")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("=")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'FLOAT'")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" cast"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("text")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'type'")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("=")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'DOUBLE'")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("from")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("test"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v("\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br")])]),s("p",[t._v("Result:")]),t._v(" "),s("div",{staticClass:"language- line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-text"}},[s("code",[t._v('+-----------------------------+--------------------------------------+------------------------------------+------------------------------------+------------------------------------+-------------------------------------+\n|                         Time|cast(root.test.text, "type"="BOOLEAN")|cast(root.test.text, "type"="INT32")|cast(root.test.text, "type"="INT64")|cast(root.test.text, "type"="FLOAT")|cast(root.test.text, "type"="DOUBLE")|\n+-----------------------------+--------------------------------------+------------------------------------+------------------------------------+------------------------------------+-------------------------------------+\n|1970-01-01T08:00:00.001+08:00|                                  true|                                   1|                                   1|                                 1.1|                                  1.1|\n|1970-01-01T08:00:00.002+08:00|                                  true|                                   1|                                   1|                                 1.0|                                  1.0|\n|1970-01-01T08:00:00.003+08:00|                                  true|                                null|                                null|                                null|                                 null|\n|1970-01-01T08:00:00.004+08:00|                                 false|                                null|                                null|                                null|                                 null|\n+-----------------------------+--------------------------------------+------------------------------------+------------------------------------+------------------------------------+-------------------------------------+\nTotal line number = 4\nIt costs 0.078s\n')])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br"),s("span",{staticClass:"line-number"},[t._v("8")]),s("br"),s("span",{staticClass:"line-number"},[t._v("9")]),s("br"),s("span",{staticClass:"line-number"},[t._v("10")]),s("br")])]),s("h3",{attrs:{id:"condition-functions"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#condition-functions"}},[t._v("#")]),t._v(" Condition Functions")]),t._v(" "),s("p",[t._v("Condition functions are used to check whether timeseries data points satisfy some specific condition.")]),t._v(" "),s("p",[t._v("They return BOOLEANs.")]),t._v(" "),s("p",[t._v("Currently, IoTDB supports the following condition functions:")]),t._v(" "),s("table",[s("thead",[s("tr",[s("th",[t._v("Function Name")]),t._v(" "),s("th",[t._v("Allowed Input Series Data Types")]),t._v(" "),s("th",[t._v("Required Attributes")]),t._v(" "),s("th",[t._v("Output Series Data Type")]),t._v(" "),s("th",[t._v("Series Data Type  Description")])])]),t._v(" "),s("tbody",[s("tr",[s("td",[t._v("ON_OFF")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[s("code",[t._v("threshold")]),t._v(": a double type variate")]),t._v(" "),s("td",[t._v("BOOLEAN")]),t._v(" "),s("td",[t._v("Return "),s("code",[t._v("ts_value >= threshold")]),t._v(".")])]),t._v(" "),s("tr",[s("td",[t._v("IN_RANGR")]),t._v(" "),s("td",[t._v("INT32 / INT64 / FLOAT / DOUBLE")]),t._v(" "),s("td",[s("code",[t._v("lower")]),t._v(": DOUBLE type"),s("br"),s("code",[t._v("upper")]),t._v(": DOUBLE type")]),t._v(" "),s("td",[t._v("BOOLEAN")]),t._v(" "),s("td",[t._v("Return "),s("code",[t._v("ts_value >= lower && value <= upper")]),t._v(".")])])])]),t._v(" "),s("p",[t._v("Example Data:")]),t._v(" "),s("div",{staticClass:"language- line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-text"}},[s("code",[t._v("IoTDB> select ts from root.test;\n+-----------------------------+------------+\n|                         Time|root.test.ts|\n+-----------------------------+------------+\n|1970-01-01T08:00:00.001+08:00|           1|\n|1970-01-01T08:00:00.002+08:00|           2|\n|1970-01-01T08:00:00.003+08:00|           3|\n|1970-01-01T08:00:00.004+08:00|           4|\n+-----------------------------+------------+\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br"),s("span",{staticClass:"line-number"},[t._v("8")]),s("br"),s("span",{staticClass:"line-number"},[t._v("9")]),s("br")])]),s("h5",{attrs:{id:"test-1"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#test-1"}},[t._v("#")]),t._v(" Test 1")]),t._v(" "),s("p",[t._v("SQL:")]),t._v(" "),s("div",{staticClass:"language-sql line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-sql"}},[s("code",[s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("select")]),t._v(" ts"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" on_off"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("ts"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'threshold'")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("=")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'2'")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("from")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("test"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v("\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br")])]),s("p",[t._v("Output:")]),t._v(" "),s("div",{staticClass:"language- line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-text"}},[s("code",[t._v("IoTDB> select ts, on_off(ts, 'threshold'='2') from root.test;\n+-----------------------------+------------+-------------------------------------+\n|                         Time|root.test.ts|on_off(root.test.ts, \"threshold\"=\"2\")|\n+-----------------------------+------------+-------------------------------------+\n|1970-01-01T08:00:00.001+08:00|           1|                                false|\n|1970-01-01T08:00:00.002+08:00|           2|                                 true|\n|1970-01-01T08:00:00.003+08:00|           3|                                 true|\n|1970-01-01T08:00:00.004+08:00|           4|                                 true|\n+-----------------------------+------------+-------------------------------------+\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br"),s("span",{staticClass:"line-number"},[t._v("8")]),s("br"),s("span",{staticClass:"line-number"},[t._v("9")]),s("br")])]),s("h5",{attrs:{id:"test-2"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#test-2"}},[t._v("#")]),t._v(" Test 2")]),t._v(" "),s("p",[t._v("Sql:")]),t._v(" "),s("div",{staticClass:"language-sql line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-sql"}},[s("code",[s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("select")]),t._v(" ts"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" in_range"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("ts"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'lower'")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("=")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'2'")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'upper'")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("=")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'3.1'")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("from")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("test"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v("\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br")])]),s("p",[t._v("Output:")]),t._v(" "),s("div",{staticClass:"language- line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-text"}},[s("code",[t._v("IoTDB> select ts, in_range(ts,'lower'='2', 'upper'='3.1') from root.test;\n+-----------------------------+------------+--------------------------------------------------+\n|                         Time|root.test.ts|in_range(root.test.ts, \"lower\"=\"2\", \"upper\"=\"3.1\")|\n+-----------------------------+------------+--------------------------------------------------+\n|1970-01-01T08:00:00.001+08:00|           1|                                             false|\n|1970-01-01T08:00:00.002+08:00|           2|                                              true|\n|1970-01-01T08:00:00.003+08:00|           3|                                              true|\n|1970-01-01T08:00:00.004+08:00|           4|                                             false|\n+-----------------------------+------------+--------------------------------------------------+\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br"),s("span",{staticClass:"line-number"},[t._v("8")]),s("br"),s("span",{staticClass:"line-number"},[t._v("9")]),s("br")])]),s("h3",{attrs:{id:"continuous-interval-functions"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#continuous-interval-functions"}},[t._v("#")]),t._v(" Continuous Interval Functions")]),t._v(" "),s("p",[t._v("The continuous interval functions are used to query all continuous intervals that meet specified conditions.\nThey can be divided into two categories according to return value:")]),t._v(" "),s("ol",[s("li",[t._v("Returns the start timestamp and time span of the continuous interval that meets the conditions (a time span of 0 means that only the start time point meets the conditions)")]),t._v(" "),s("li",[t._v("Returns the start timestamp of the continuous interval that meets the condition and the number of points in the interval (a number of 1 means that only the start time point meets the conditions)")])]),t._v(" "),s("table",[s("thead",[s("tr",[s("th",[t._v("Function Name")]),t._v(" "),s("th",[t._v("Input TSDatatype")]),t._v(" "),s("th",[t._v("Parameters")]),t._v(" "),s("th",[t._v("Output TSDatatype")]),t._v(" "),s("th",[t._v("Function Description")])])]),t._v(" "),s("tbody",[s("tr",[s("td",[t._v("ZERO_DURATION")]),t._v(" "),s("td",[t._v("INT32/ INT64/ FLOAT/ DOUBLE/ BOOLEAN")]),t._v(" "),s("td",[s("code",[t._v("min")]),t._v(":Optional with default value "),s("code",[t._v("0L")]),s("br"),s("code",[t._v("max")]),t._v(":Optional with default value "),s("code",[t._v("Long.MAX_VALUE")])]),t._v(" "),s("td",[t._v("Long")]),t._v(" "),s("td",[t._v("Return intervals' start times and duration times in which the value is always 0(false), and the duration time "),s("code",[t._v("t")]),t._v(" satisfy "),s("code",[t._v("t >= min && t <= max")]),t._v(". The unit of "),s("code",[t._v("t")]),t._v(" is ms")])]),t._v(" "),s("tr",[s("td",[t._v("NON_ZERO_DURATION")]),t._v(" "),s("td",[t._v("INT32/ INT64/ FLOAT/ DOUBLE/ BOOLEAN")]),t._v(" "),s("td",[s("code",[t._v("min")]),t._v(":Optional with default value "),s("code",[t._v("0L")]),s("br"),s("code",[t._v("max")]),t._v(":Optional with default value "),s("code",[t._v("Long.MAX_VALUE")])]),t._v(" "),s("td",[t._v("Long")]),t._v(" "),s("td",[t._v("Return intervals' start times and duration times in which the value is always not 0, and the duration time "),s("code",[t._v("t")]),t._v(" satisfy "),s("code",[t._v("t >= min && t <= max")]),t._v(". The unit of "),s("code",[t._v("t")]),t._v(" is ms")])]),t._v(" "),s("tr",[s("td",[t._v("ZERO_COUNT")]),t._v(" "),s("td",[t._v("INT32/ INT64/ FLOAT/ DOUBLE/ BOOLEAN")]),t._v(" "),s("td",[s("code",[t._v("min")]),t._v(":Optional with default value "),s("code",[t._v("1L")]),s("br"),s("code",[t._v("max")]),t._v(":Optional with default value "),s("code",[t._v("Long.MAX_VALUE")])]),t._v(" "),s("td",[t._v("Long")]),t._v(" "),s("td",[t._v("Return intervals' start times and the number of data points in the interval in which the value is always 0(false). Data points number "),s("code",[t._v("n")]),t._v(" satisfy "),s("code",[t._v("n >= min && n <= max")])])]),t._v(" "),s("tr",[s("td",[t._v("NON_ZERO_COUNT")]),t._v(" "),s("td",[t._v("INT32/ INT64/ FLOAT/ DOUBLE/ BOOLEAN")]),t._v(" "),s("td",[s("code",[t._v("min")]),t._v(":Optional with default value "),s("code",[t._v("1L")]),s("br"),s("code",[t._v("max")]),t._v(":Optional with default value "),s("code",[t._v("Long.MAX_VALUE")])]),t._v(" "),s("td",[t._v("Long")]),t._v(" "),s("td",[t._v("Return intervals' start times and the number of data points in the interval in which the value is always not 0(false). Data points number "),s("code",[t._v("n")]),t._v(" satisfy "),s("code",[t._v("n >= min && n <= max")])])])])]),t._v(" "),s("h5",{attrs:{id:"demonstrate"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#demonstrate"}},[t._v("#")]),t._v(" Demonstrate")]),t._v(" "),s("p",[t._v("Example data:")]),t._v(" "),s("div",{staticClass:"language- line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-text"}},[s("code",[t._v("IoTDB> select s1,s2,s3,s4,s5 from root.sg.d2;\n+-----------------------------+-------------+-------------+-------------+-------------+-------------+\n|                         Time|root.sg.d2.s1|root.sg.d2.s2|root.sg.d2.s3|root.sg.d2.s4|root.sg.d2.s5|\n+-----------------------------+-------------+-------------+-------------+-------------+-------------+\n|1970-01-01T08:00:00.000+08:00|            0|            0|          0.0|          0.0|        false|\n|1970-01-01T08:00:00.001+08:00|            1|            1|          1.0|          1.0|         true|\n|1970-01-01T08:00:00.002+08:00|            1|            1|          1.0|          1.0|         true|\n|1970-01-01T08:00:00.003+08:00|            0|            0|          0.0|          0.0|        false|\n|1970-01-01T08:00:00.004+08:00|            1|            1|          1.0|          1.0|         true|\n|1970-01-01T08:00:00.005+08:00|            0|            0|          0.0|          0.0|        false|\n|1970-01-01T08:00:00.006+08:00|            0|            0|          0.0|          0.0|        false|\n|1970-01-01T08:00:00.007+08:00|            1|            1|          1.0|          1.0|         true|\n+-----------------------------+-------------+-------------+-------------+-------------+-------------+\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br"),s("span",{staticClass:"line-number"},[t._v("8")]),s("br"),s("span",{staticClass:"line-number"},[t._v("9")]),s("br"),s("span",{staticClass:"line-number"},[t._v("10")]),s("br"),s("span",{staticClass:"line-number"},[t._v("11")]),s("br"),s("span",{staticClass:"line-number"},[t._v("12")]),s("br"),s("span",{staticClass:"line-number"},[t._v("13")]),s("br")])]),s("p",[t._v("Sql:")]),t._v(" "),s("div",{staticClass:"language-sql line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-sql"}},[s("code",[s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("select")]),t._v(" s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" zero_count"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" non_zero_count"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s2"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" zero_duration"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s3"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" non_zero_duration"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s4"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("from")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("sg"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("d2"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v("\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br")])]),s("p",[t._v("Result:")]),t._v(" "),s("div",{staticClass:"language- line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-text"}},[s("code",[t._v("+-----------------------------+-------------+-------------------------+-----------------------------+----------------------------+--------------------------------+\n|                         Time|root.sg.d2.s1|zero_count(root.sg.d2.s1)|non_zero_count(root.sg.d2.s2)|zero_duration(root.sg.d2.s3)|non_zero_duration(root.sg.d2.s4)|\n+-----------------------------+-------------+-------------------------+-----------------------------+----------------------------+--------------------------------+\n|1970-01-01T08:00:00.000+08:00|            0|                        1|                         null|                           0|                            null|\n|1970-01-01T08:00:00.001+08:00|            1|                     null|                            2|                        null|                               1|\n|1970-01-01T08:00:00.002+08:00|            1|                     null|                         null|                        null|                            null|\n|1970-01-01T08:00:00.003+08:00|            0|                        1|                         null|                           0|                            null|\n|1970-01-01T08:00:00.004+08:00|            1|                     null|                            1|                        null|                               0|\n|1970-01-01T08:00:00.005+08:00|            0|                        2|                         null|                           1|                            null|\n|1970-01-01T08:00:00.006+08:00|            0|                     null|                         null|                        null|                            null|\n|1970-01-01T08:00:00.007+08:00|            1|                     null|                            1|                        null|                               0|\n+-----------------------------+-------------+-------------------------+-----------------------------+----------------------------+--------------------------------+\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br"),s("span",{staticClass:"line-number"},[t._v("8")]),s("br"),s("span",{staticClass:"line-number"},[t._v("9")]),s("br"),s("span",{staticClass:"line-number"},[t._v("10")]),s("br"),s("span",{staticClass:"line-number"},[t._v("11")]),s("br"),s("span",{staticClass:"line-number"},[t._v("12")]),s("br")])]),s("h3",{attrs:{id:"user-defined-timeseries-generating-functions"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#user-defined-timeseries-generating-functions"}},[t._v("#")]),t._v(" User Defined Timeseries Generating Functions")]),t._v(" "),s("p",[t._v("Please refer to "),s("RouterLink",{attrs:{to:"/UserGuide/V0.13.x/Process-Data/UDF-User-Defined-Function.html"}},[t._v("UDF (User Defined Function)")]),t._v(".")],1),t._v(" "),s("p",[t._v("Known Implementation UDF Libraries:")]),t._v(" "),s("ul",[s("li",[s("a",{attrs:{href:"https://thulab.github.io/iotdb-quality",target:"_blank",rel:"noopener noreferrer"}},[t._v("IoTDB-Quality"),s("OutboundLink")],1),t._v(", a UDF library about data quality, including data profiling, data quality evalution and data repairing, etc.")])]),t._v(" "),s("h2",{attrs:{id:"nested-expressions"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#nested-expressions"}},[t._v("#")]),t._v(" Nested Expressions")]),t._v(" "),s("p",[t._v("IoTDB supports the calculation of arbitrary nested expressions. Since time series query and aggregation query can not be used in a query statement at the same time, we divide nested expressions into two types, which are nested expressions with time series query and nested expressions with aggregation query.")]),t._v(" "),s("p",[t._v("The following is the syntax definition of the "),s("code",[t._v("select")]),t._v(" clause:")]),t._v(" "),s("div",{staticClass:"language-sql line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-sql"}},[s("code",[t._v("selectClause\n    : "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("SELECT")]),t._v(" resultColumn "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("','")]),t._v(" resultColumn"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("*")]),t._v("\n    "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v("\n\nresultColumn\n    : expression "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("AS")]),t._v(" ID"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v("?\n    "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v("\n\nexpression\n    : "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'('")]),t._v(" expression "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("')'")]),t._v("\n    "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("|")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'-'")]),t._v(" expression\n    "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("|")]),t._v(" expression "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'*'")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("|")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'/'")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("|")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'%'")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" expression\n    "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("|")]),t._v(" expression "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'+'")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("|")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'-'")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" expression\n    "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("|")]),t._v(" functionName "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("'('")]),t._v(" expression "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("','")]),t._v(" expression"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("*")]),t._v(" functionAttribute"),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("*")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token string"}},[t._v("')'")]),t._v("\n    "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("|")]),t._v(" timeSeriesSuffixPath\n    "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("|")]),t._v(" number\n    "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v("\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br"),s("span",{staticClass:"line-number"},[t._v("8")]),s("br"),s("span",{staticClass:"line-number"},[t._v("9")]),s("br"),s("span",{staticClass:"line-number"},[t._v("10")]),s("br"),s("span",{staticClass:"line-number"},[t._v("11")]),s("br"),s("span",{staticClass:"line-number"},[t._v("12")]),s("br"),s("span",{staticClass:"line-number"},[t._v("13")]),s("br"),s("span",{staticClass:"line-number"},[t._v("14")]),s("br"),s("span",{staticClass:"line-number"},[t._v("15")]),s("br"),s("span",{staticClass:"line-number"},[t._v("16")]),s("br"),s("span",{staticClass:"line-number"},[t._v("17")]),s("br")])]),s("h3",{attrs:{id:"nested-expressions-with-time-series-query"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#nested-expressions-with-time-series-query"}},[t._v("#")]),t._v(" Nested Expressions with Time Series Query")]),t._v(" "),s("p",[t._v("IoTDB supports the calculation of arbitrary nested expressions consisting of "),s("strong",[t._v("numbers, time series, time series generating functions (including user-defined functions) and arithmetic expressions")]),t._v(" in the "),s("code",[t._v("select")]),t._v(" clause.")]),t._v(" "),s("h5",{attrs:{id:"example-2"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#example-2"}},[t._v("#")]),t._v(" Example")]),t._v(" "),s("p",[t._v("Input1：")]),t._v(" "),s("div",{staticClass:"language-sql line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-sql"}},[s("code",[s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("select")]),t._v(" a"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v("\n       b"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v("\n       "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("a "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("1")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("*")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("2")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("-")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("1")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("%")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("2")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("1.5")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v("\n       sin"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("a "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" sin"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("a "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" sin"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("b"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v("\n       "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("-")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("a "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" b"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("*")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("sin"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("a "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" b"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("*")]),t._v(" sin"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("a "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" b"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" cos"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("a "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" b"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("*")]),t._v(" cos"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("a "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" b"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("1")]),t._v("\n"),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("from")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("sg1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v("\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br")])]),s("p",[t._v("Result1：")]),t._v(" "),s("div",{staticClass:"language- line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-text"}},[s("code",[t._v("+-----------------------------+----------+----------+----------------------------------------+---------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+\n|                         Time|root.sg1.a|root.sg1.b|((((root.sg1.a + 1) * 2) - 1) % 2) + 1.5|sin(root.sg1.a + sin(root.sg1.a + sin(root.sg1.b)))|(-root.sg1.a + root.sg1.b * ((sin(root.sg1.a + root.sg1.b) * sin(root.sg1.a + root.sg1.b)) + (cos(root.sg1.a + root.sg1.b) * cos(root.sg1.a + root.sg1.b)))) + 1|\n+-----------------------------+----------+----------+----------------------------------------+---------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+\n|1970-01-01T08:00:00.010+08:00|         1|         1|                                     2.5|                                 0.9238430524420609|                                                                                                                      -1.0|\n|1970-01-01T08:00:00.020+08:00|         2|         2|                                     2.5|                                 0.7903505371876317|                                                                                                                      -3.0|\n|1970-01-01T08:00:00.030+08:00|         3|         3|                                     2.5|                                0.14065207680386618|                                                                                                                      -5.0|\n|1970-01-01T08:00:00.040+08:00|         4|      null|                                     2.5|                                               null|                                                                                                                      null|\n|1970-01-01T08:00:00.050+08:00|      null|         5|                                    null|                                               null|                                                                                                                      null|\n|1970-01-01T08:00:00.060+08:00|         6|         6|                                     2.5|                                -0.7288037411970916|                                                                                                                     -11.0|\n+-----------------------------+----------+----------+----------------------------------------+---------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+\nTotal line number = 6\nIt costs 0.048s\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br"),s("span",{staticClass:"line-number"},[t._v("8")]),s("br"),s("span",{staticClass:"line-number"},[t._v("9")]),s("br"),s("span",{staticClass:"line-number"},[t._v("10")]),s("br"),s("span",{staticClass:"line-number"},[t._v("11")]),s("br"),s("span",{staticClass:"line-number"},[t._v("12")]),s("br")])]),s("p",[t._v("Input2：")]),t._v(" "),s("div",{staticClass:"language-sql line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-sql"}},[s("code",[s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("select")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("a "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" b"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("*")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("2")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" sin"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("a"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("from")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("sg\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br")])]),s("p",[t._v("Result2：")]),t._v(" "),s("div",{staticClass:"language- line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-text"}},[s("code",[t._v("+-----------------------------+----------------------------------------------+\n|                         Time|((root.sg.a + root.sg.b) * 2) + sin(root.sg.a)|\n+-----------------------------+----------------------------------------------+\n|1970-01-01T08:00:00.010+08:00|                             59.45597888911063|\n|1970-01-01T08:00:00.020+08:00|                            100.91294525072763|\n|1970-01-01T08:00:00.030+08:00|                            139.01196837590714|\n|1970-01-01T08:00:00.040+08:00|                            180.74511316047935|\n|1970-01-01T08:00:00.050+08:00|                            219.73762514629607|\n|1970-01-01T08:00:00.060+08:00|                             259.6951893788978|\n|1970-01-01T08:00:00.070+08:00|                             300.7738906815579|\n|1970-01-01T08:00:00.090+08:00|                             39.45597888911063|\n|1970-01-01T08:00:00.100+08:00|                             39.45597888911063|\n+-----------------------------+----------------------------------------------+\nTotal line number = 9\nIt costs 0.011s\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br"),s("span",{staticClass:"line-number"},[t._v("8")]),s("br"),s("span",{staticClass:"line-number"},[t._v("9")]),s("br"),s("span",{staticClass:"line-number"},[t._v("10")]),s("br"),s("span",{staticClass:"line-number"},[t._v("11")]),s("br"),s("span",{staticClass:"line-number"},[t._v("12")]),s("br"),s("span",{staticClass:"line-number"},[t._v("13")]),s("br"),s("span",{staticClass:"line-number"},[t._v("14")]),s("br"),s("span",{staticClass:"line-number"},[t._v("15")]),s("br")])]),s("p",[t._v("Input3：")]),t._v(" "),s("div",{staticClass:"language-sql line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-sql"}},[s("code",[s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("select")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("a "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("*")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("/")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("2")]),t._v("  "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("from")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("sg1\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br")])]),s("p",[t._v("Result3：")]),t._v(" "),s("div",{staticClass:"language- line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-text"}},[s("code",[t._v("+-----------------------------+-----------------------------+-----------------------------+\n|                         Time|(root.sg1.a + root.sg1.a) / 2|(root.sg1.a + root.sg1.b) / 2|\n+-----------------------------+-----------------------------+-----------------------------+\n|1970-01-01T08:00:00.010+08:00|                          1.0|                          1.0|\n|1970-01-01T08:00:00.020+08:00|                          2.0|                          2.0|\n|1970-01-01T08:00:00.030+08:00|                          3.0|                          3.0|\n|1970-01-01T08:00:00.040+08:00|                          4.0|                         null|\n|1970-01-01T08:00:00.060+08:00|                          6.0|                          6.0|\n+-----------------------------+-----------------------------+-----------------------------+\nTotal line number = 5\nIt costs 0.011s\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br"),s("span",{staticClass:"line-number"},[t._v("8")]),s("br"),s("span",{staticClass:"line-number"},[t._v("9")]),s("br"),s("span",{staticClass:"line-number"},[t._v("10")]),s("br"),s("span",{staticClass:"line-number"},[t._v("11")]),s("br")])]),s("p",[t._v("Input4：")]),t._v(" "),s("div",{staticClass:"language-sql line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-sql"}},[s("code",[s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("select")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("a "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" b"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("*")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("3")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("from")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("sg"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("ln\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br")])]),s("p",[t._v("Result4：")]),t._v(" "),s("div",{staticClass:"language- line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-text"}},[s("code",[t._v("+-----------------------------+---------------------------+---------------------------+---------------------------+---------------------------+\n|                         Time|(root.sg.a + root.sg.b) * 3|(root.sg.a + root.ln.b) * 3|(root.ln.a + root.sg.b) * 3|(root.ln.a + root.ln.b) * 3|\n+-----------------------------+---------------------------+---------------------------+---------------------------+---------------------------+\n|1970-01-01T08:00:00.010+08:00|                       90.0|                      270.0|                      360.0|                      540.0|\n|1970-01-01T08:00:00.020+08:00|                      150.0|                      330.0|                      690.0|                      870.0|\n|1970-01-01T08:00:00.030+08:00|                      210.0|                      450.0|                      570.0|                      810.0|\n|1970-01-01T08:00:00.040+08:00|                      270.0|                      240.0|                      690.0|                      660.0|\n|1970-01-01T08:00:00.050+08:00|                      330.0|                       null|                       null|                       null|\n|1970-01-01T08:00:00.060+08:00|                      390.0|                       null|                       null|                       null|\n|1970-01-01T08:00:00.070+08:00|                      450.0|                       null|                       null|                       null|\n|1970-01-01T08:00:00.090+08:00|                       60.0|                       null|                       null|                       null|\n|1970-01-01T08:00:00.100+08:00|                       60.0|                       null|                       null|                       null|\n+-----------------------------+---------------------------+---------------------------+---------------------------+---------------------------+\nTotal line number = 9\nIt costs 0.014s\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br"),s("span",{staticClass:"line-number"},[t._v("8")]),s("br"),s("span",{staticClass:"line-number"},[t._v("9")]),s("br"),s("span",{staticClass:"line-number"},[t._v("10")]),s("br"),s("span",{staticClass:"line-number"},[t._v("11")]),s("br"),s("span",{staticClass:"line-number"},[t._v("12")]),s("br"),s("span",{staticClass:"line-number"},[t._v("13")]),s("br"),s("span",{staticClass:"line-number"},[t._v("14")]),s("br"),s("span",{staticClass:"line-number"},[t._v("15")]),s("br")])]),s("h5",{attrs:{id:"explanation"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#explanation"}},[t._v("#")]),t._v(" Explanation")]),t._v(" "),s("ul",[s("li",[t._v("Only when the left operand and the right operand under a certain timestamp are not "),s("code",[t._v("null")]),t._v(", the nested expressions will have an output value. Otherwise this row will not be included in the result.\n"),s("ul",[s("li",[t._v("In Result1 of the Example part, the value of time series "),s("code",[t._v("root.sg.a")]),t._v(" at time 40 is 4, while the value of time series "),s("code",[t._v("root.sg.b")]),t._v(" is "),s("code",[t._v("null")]),t._v(". So at time 40, the value of nested expressions "),s("code",[t._v("(a + b) * 2 + sin(a)")]),t._v(" is "),s("code",[t._v("null")]),t._v(". So in Result2, this row is not included in the result.")])])]),t._v(" "),s("li",[t._v("If one operand in the nested expressions can be translated into multiple time series (For example, "),s("code",[t._v("*")]),t._v("), the result of each time series will be included in the result (Cartesian product). Please refer to Input3, Input4 and corresponding Result3 and Result4 in Example.")])]),t._v(" "),s("h5",{attrs:{id:"note"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#note"}},[t._v("#")]),t._v(" Note")]),t._v(" "),s("blockquote",[s("p",[t._v("Please note that Aligned Time Series has not been supported in Nested Expressions with Time Series Query yet. An error message is expected if you use it with Aligned Time Series selected in a query statement.")])]),t._v(" "),s("h3",{attrs:{id:"nested-expressions-query-with-aggregations"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#nested-expressions-query-with-aggregations"}},[t._v("#")]),t._v(" Nested Expressions query with aggregations")]),t._v(" "),s("p",[t._v("IoTDB supports the calculation of arbitrary nested expressions consisting of "),s("strong",[t._v("numbers, aggregations and arithmetic expressions")]),t._v(" in the "),s("code",[t._v("select")]),t._v(" clause.")]),t._v(" "),s("h5",{attrs:{id:"example-3"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#example-3"}},[t._v("#")]),t._v(" Example")]),t._v(" "),s("p",[t._v("Aggregation query without "),s("code",[t._v("GROUP BY")]),t._v(".")]),t._v(" "),s("p",[t._v("Input1:")]),t._v(" "),s("div",{staticClass:"language-sql line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-sql"}},[s("code",[s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("select")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token function"}},[t._v("avg")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("temperature"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v("\n       sin"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token function"}},[t._v("avg")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("temperature"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v("\n       "),s("span",{pre:!0,attrs:{class:"token function"}},[t._v("avg")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("temperature"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("1")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v("\n       "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("-")]),s("span",{pre:!0,attrs:{class:"token function"}},[t._v("sum")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("hardware"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v("\n       "),s("span",{pre:!0,attrs:{class:"token function"}},[t._v("avg")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("temperature"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token function"}},[t._v("sum")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("hardware"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v("\n"),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("from")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("ln"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("wf01"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("wt01"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v("\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br")])]),s("p",[t._v("Result1:")]),t._v(" "),s("div",{staticClass:"language- line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-text"}},[s("code",[t._v("+----------------------------------+---------------------------------------+--------------------------------------+--------------------------------+--------------------------------------------------------------------+\n|avg(root.ln.wf01.wt01.temperature)|sin(avg(root.ln.wf01.wt01.temperature))|avg(root.ln.wf01.wt01.temperature) + 1|-sum(root.ln.wf01.wt01.hardware)|avg(root.ln.wf01.wt01.temperature) + sum(root.ln.wf01.wt01.hardware)|\n+----------------------------------+---------------------------------------+--------------------------------------+--------------------------------+--------------------------------------------------------------------+\n|                15.927999999999999|                   -0.21826546964855045|                    16.927999999999997|                         -7426.0|                                                            7441.928|\n+----------------------------------+---------------------------------------+--------------------------------------+--------------------------------+--------------------------------------------------------------------+\nTotal line number = 1\nIt costs 0.009s\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br")])]),s("p",[t._v("Input2:")]),t._v(" "),s("div",{staticClass:"language-sql line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-sql"}},[s("code",[s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("select")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token function"}},[t._v("avg")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("*")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" \n\t   "),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token function"}},[t._v("avg")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("*")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("1")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("*")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("3")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("/")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("2")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("-")]),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("1")]),t._v(" \n"),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("from")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("sg1\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br")])]),s("p",[t._v("Result2:")]),t._v(" "),s("div",{staticClass:"language- line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-text"}},[s("code",[t._v("+---------------+---------------+-------------------------------------+-------------------------------------+\n|avg(root.sg1.a)|avg(root.sg1.b)|(((avg(root.sg1.a) + 1) * 3) / 2) - 1|(((avg(root.sg1.b) + 1) * 3) / 2) - 1|\n+---------------+---------------+-------------------------------------+-------------------------------------+\n|            3.2|            3.4|                    5.300000000000001|                   5.6000000000000005|\n+---------------+---------------+-------------------------------------+-------------------------------------+\nTotal line number = 1\nIt costs 0.007s\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br")])]),s("p",[t._v("Aggregation with "),s("code",[t._v("GROUP BY")]),t._v(".")]),t._v(" "),s("p",[t._v("Input3:")]),t._v(" "),s("div",{staticClass:"language-sql line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-sql"}},[s("code",[s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("select")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token function"}},[t._v("avg")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("temperature"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v("\n       sin"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token function"}},[t._v("avg")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("temperature"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v("\n       "),s("span",{pre:!0,attrs:{class:"token function"}},[t._v("avg")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("temperature"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("1")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v("\n       "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("-")]),s("span",{pre:!0,attrs:{class:"token function"}},[t._v("sum")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("hardware"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v("\n       "),s("span",{pre:!0,attrs:{class:"token function"}},[t._v("avg")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("temperature"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token function"}},[t._v("sum")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("hardware"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("as")]),t._v(" custom_sum\n"),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("from")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("ln"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("wf01"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("wt01\n"),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("GROUP")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("BY")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("[")]),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("10")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("90")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("10")]),t._v("ms"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v("\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br")])]),s("p",[t._v("Result3:")]),t._v(" "),s("div",{staticClass:"language- line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-text"}},[s("code",[t._v("+-----------------------------+----------------------------------+---------------------------------------+--------------------------------------+--------------------------------+----------+\n|                         Time|avg(root.ln.wf01.wt01.temperature)|sin(avg(root.ln.wf01.wt01.temperature))|avg(root.ln.wf01.wt01.temperature) + 1|-sum(root.ln.wf01.wt01.hardware)|custom_sum|\n+-----------------------------+----------------------------------+---------------------------------------+--------------------------------------+--------------------------------+----------+\n|1970-01-01T08:00:00.010+08:00|                13.987499999999999|                     0.9888207947857667|                    14.987499999999999|                         -3211.0| 3224.9875|\n|1970-01-01T08:00:00.020+08:00|                              29.6|                    -0.9701057337071853|                                  30.6|                         -3720.0|    3749.6|\n|1970-01-01T08:00:00.030+08:00|                              null|                                   null|                                  null|                            null|      null|\n|1970-01-01T08:00:00.040+08:00|                              null|                                   null|                                  null|                            null|      null|\n|1970-01-01T08:00:00.050+08:00|                              null|                                   null|                                  null|                            null|      null|\n|1970-01-01T08:00:00.060+08:00|                              null|                                   null|                                  null|                            null|      null|\n|1970-01-01T08:00:00.070+08:00|                              null|                                   null|                                  null|                            null|      null|\n|1970-01-01T08:00:00.080+08:00|                              null|                                   null|                                  null|                            null|      null|\n+-----------------------------+----------------------------------+---------------------------------------+--------------------------------------+--------------------------------+----------+\nTotal line number = 8\nIt costs 0.012s\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br"),s("span",{staticClass:"line-number"},[t._v("4")]),s("br"),s("span",{staticClass:"line-number"},[t._v("5")]),s("br"),s("span",{staticClass:"line-number"},[t._v("6")]),s("br"),s("span",{staticClass:"line-number"},[t._v("7")]),s("br"),s("span",{staticClass:"line-number"},[t._v("8")]),s("br"),s("span",{staticClass:"line-number"},[t._v("9")]),s("br"),s("span",{staticClass:"line-number"},[t._v("10")]),s("br"),s("span",{staticClass:"line-number"},[t._v("11")]),s("br"),s("span",{staticClass:"line-number"},[t._v("12")]),s("br"),s("span",{staticClass:"line-number"},[t._v("13")]),s("br"),s("span",{staticClass:"line-number"},[t._v("14")]),s("br")])]),s("h5",{attrs:{id:"explanation-2"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#explanation-2"}},[t._v("#")]),t._v(" Explanation")]),t._v(" "),s("ul",[s("li",[t._v("Only when the left operand and the right operand under a certain timestamp are not "),s("code",[t._v("null")]),t._v(", the nested expressions will have an output value. Otherwise this row will not be included in the result. But for nested expressions with "),s("code",[t._v("GROUP BY")]),t._v(" clause, it is better to show the result of all time intervals. Please refer to Input3 and corresponding Result3 in Example.")]),t._v(" "),s("li",[t._v("If one operand in the nested expressions can be translated into multiple time series (For example, "),s("code",[t._v("*")]),t._v("), the result of each time series will be included in the result (Cartesian product). Please refer to Input2 and corresponding Result2 in Example.")])]),t._v(" "),s("h5",{attrs:{id:"note-2"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#note-2"}},[t._v("#")]),t._v(" Note")]),t._v(" "),s("blockquote",[s("p",[t._v("Automated fill ("),s("code",[t._v("FILL")]),t._v(") and grouped by level ("),s("code",[t._v("GROUP BY LEVEL")]),t._v(") are not supported in an aggregation query with expression nested. They may be supported in future versions.")]),t._v(" "),s("p",[t._v("The aggregation expression must be the lowest level input of one expression tree. Any kind expressions except timeseries are not valid as aggregation function parameters。")]),t._v(" "),s("p",[t._v("In a word, the following queries are not valid.")]),t._v(" "),s("div",{staticClass:"language-sql line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-sql"}},[s("code",[s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("SELECT")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token function"}},[t._v("avg")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s1"),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("1")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("FROM")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("sg"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("d1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token comment"}},[t._v("-- The aggregation function has expression parameters.")]),t._v("\n"),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("SELECT")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token function"}},[t._v("avg")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token function"}},[t._v("avg")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s2"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("FROM")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("sg"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("*")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("GROUP")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("BY")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("LEVEL")]),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("=")]),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("1")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token comment"}},[t._v("-- Grouped by level")]),t._v("\n"),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("SELECT")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token function"}},[t._v("avg")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s1"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token operator"}},[t._v("+")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token function"}},[t._v("avg")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("s2"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("FROM")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("sg"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("d1 "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("GROUP")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("BY")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("[")]),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("0")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("10000")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token number"}},[t._v("1")]),t._v("s"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),t._v(" FILL"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v("(")]),t._v("previous"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(")")]),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v(" "),s("span",{pre:!0,attrs:{class:"token comment"}},[t._v("-- Automated fill")]),t._v("\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br"),s("span",{staticClass:"line-number"},[t._v("2")]),s("br"),s("span",{staticClass:"line-number"},[t._v("3")]),s("br")])])]),t._v(" "),s("h2",{attrs:{id:"use-alias"}},[s("a",{staticClass:"header-anchor",attrs:{href:"#use-alias"}},[t._v("#")]),t._v(" Use Alias")]),t._v(" "),s("p",[t._v("Since the unique data model of IoTDB, lots of additional information like device will be carried before each sensor. Sometimes, we want to query just one specific device, then these prefix information show frequently will be redundant in this situation, influencing the analysis of result set. At this time, we can use "),s("code",[t._v("AS")]),t._v(" function provided by IoTDB, assign an alias to time series selected in query.")]),t._v(" "),s("p",[t._v("For example：")]),t._v(" "),s("div",{staticClass:"language-sql line-numbers-mode"},[s("pre",{pre:!0,attrs:{class:"language-sql"}},[s("code",[s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("select")]),t._v(" s1 "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("as")]),t._v(" temperature"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(",")]),t._v(" s2 "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("as")]),t._v(" speed "),s("span",{pre:!0,attrs:{class:"token keyword"}},[t._v("from")]),t._v(" root"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("ln"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("wf01"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(".")]),t._v("wt01"),s("span",{pre:!0,attrs:{class:"token punctuation"}},[t._v(";")]),t._v("\n")])]),t._v(" "),s("div",{staticClass:"line-numbers-wrapper"},[s("span",{staticClass:"line-number"},[t._v("1")]),s("br")])]),s("p",[t._v("The result set is：")]),t._v(" "),s("table",[s("thead",[s("tr",[s("th",[t._v("Time")]),t._v(" "),s("th",[t._v("temperature")]),t._v(" "),s("th",[t._v("speed")])])]),t._v(" "),s("tbody",[s("tr",[s("td",[t._v("...")]),t._v(" "),s("td",[t._v("...")]),t._v(" "),s("td",[t._v("...")])])])])])}),[],!1,null,null,null);s.default=n.exports}}]);