assets/Function-and-Expression.html-lYNMtylP.js

const e=JSON.parse('{"key":"v-3bdad281","path":"/zh/UserGuide/Master/Reference/Function-and-Expression.html","title":"内置函数与表达式","lang":"zh-CN","frontmatter":{"description":"聚合函数 聚合函数是多对一函数。它们对一组值进行聚合计算，得到单个聚合结果。 除了 COUNT(), COUNT_IF()之外，其他所有聚合函数都忽略空值，并在没有输入行或所有值为空时返回空值。 例如，SUM() 返回 null 而不是零，而 AVG() 在计数中不包括 null 值。 IoTDB 支持的聚合函数如下： 函数名 功能描述 允许的输入类型...","head":[["link",{"rel":"alternate","hreflang":"en-us","href":"https://iotdb.apache.org/UserGuide/Master/Reference/Function-and-Expression.html"}],["meta",{"property":"og:url","content":"https://iotdb.apache.org/zh/UserGuide/Master/Reference/Function-and-Expression.html"}],["meta",{"property":"og:site_name","content":"IoTDB Website"}],["meta",{"property":"og:title","content":"内置函数与表达式"}],["meta",{"property":"og:description","content":"聚合函数 聚合函数是多对一函数。它们对一组值进行聚合计算，得到单个聚合结果。 除了 COUNT(), COUNT_IF()之外，其他所有聚合函数都忽略空值，并在没有输入行或所有值为空时返回空值。 例如，SUM() 返回 null 而不是零，而 AVG() 在计数中不包括 null 值。 IoTDB 支持的聚合函数如下： 函数名 功能描述 允许的输入类型..."}],["meta",{"property":"og:type","content":"article"}],["meta",{"property":"og:locale","content":"zh-CN"}],["meta",{"property":"og:locale:alternate","content":"en-US"}],["meta",{"property":"og:updated_time","content":"2024-03-29T10:15:18.000Z"}],["meta",{"property":"article:modified_time","content":"2024-03-29T10:15:18.000Z"}],["script",{"type":"application/ld+json"},"{\\"@context\\":\\"https://schema.org\\",\\"@type\\":\\"Article\\",\\"headline\\":\\"内置函数与表达式\\",\\"image\\":[\\"\\"],\\"dateModified\\":\\"2024-03-29T10:15:18.000Z\\",\\"author\\":[]}"]]},"headers":[{"level":2,"title":"聚合函数","slug":"聚合函数","link":"#聚合函数","children":[{"level":3,"title":"COUNT_IF","slug":"count-if","link":"#count-if","children":[]},{"level":3,"title":"TIME_DURATION","slug":"time-duration","link":"#time-duration","children":[]},{"level":3,"title":"COUNT_TIME","slug":"count-time","link":"#count-time","children":[]}]},{"level":2,"title":"算数运算符和函数","slug":"算数运算符和函数","link":"#算数运算符和函数","children":[{"level":3,"title":"算数运算符","slug":"算数运算符","link":"#算数运算符","children":[]},{"level":3,"title":"数学函数","slug":"数学函数","link":"#数学函数","children":[]}]},{"level":2,"title":"比较运算符和函数","slug":"比较运算符和函数","link":"#比较运算符和函数","children":[{"level":3,"title":"基本比较运算符","slug":"基本比较运算符","link":"#基本比较运算符","children":[]},{"level":3,"title":"BETWEEN ... AND ... 运算符","slug":"between-and-运算符","link":"#between-and-运算符","children":[]},{"level":3,"title":"模糊匹配运算符","slug":"模糊匹配运算符","link":"#模糊匹配运算符","children":[]},{"level":3,"title":"IS NULL 运算符","slug":"is-null-运算符","link":"#is-null-运算符","children":[]},{"level":3,"title":"IN 运算符","slug":"in-运算符","link":"#in-运算符","children":[]},{"level":3,"title":"条件函数","slug":"条件函数","link":"#条件函数","children":[]}]},{"level":2,"title":"逻辑运算符","slug":"逻辑运算符","link":"#逻辑运算符","children":[{"level":3,"title":"一元逻辑运算符","slug":"一元逻辑运算符","link":"#一元逻辑运算符","children":[]},{"level":3,"title":"二元逻辑运算符","slug":"二元逻辑运算符","link":"#二元逻辑运算符","children":[]}]},{"level":2,"title":"字符串处理","slug":"字符串处理","link":"#字符串处理","children":[{"level":3,"title":"STRING_CONTAINS","slug":"string-contains","link":"#string-contains","children":[]},{"level":3,"title":"STRING_MATCHES","slug":"string-matches","link":"#string-matches","children":[]},{"level":3,"title":"Length","slug":"length","link":"#length","children":[]},{"level":3,"title":"Locate","slug":"locate","link":"#locate","children":[]},{"level":3,"title":"StartsWith","slug":"startswith","link":"#startswith","children":[]},{"level":3,"title":"EndsWith","slug":"endswith","link":"#endswith","children":[]},{"level":3,"title":"Concat","slug":"concat","link":"#concat","children":[]},{"level":3,"title":"Substring","slug":"substring","link":"#substring","children":[]},{"level":3,"title":"Replace","slug":"replace","link":"#replace","children":[]},{"level":3,"title":"Upper","slug":"upper","link":"#upper","children":[]},{"level":3,"title":"Lower","slug":"lower","link":"#lower","children":[]},{"level":3,"title":"Trim","slug":"trim","link":"#trim","children":[]},{"level":3,"title":"StrCmp","slug":"strcmp","link":"#strcmp","children":[]},{"level":3,"title":"StrReplace","slug":"strreplace","link":"#strreplace","children":[]},{"level":3,"title":"RegexMatch","slug":"regexmatch","link":"#regexmatch","children":[]},{"level":3,"title":"RegexReplace","slug":"regexreplace","link":"#regexreplace","children":[]}]},{"level":2,"title":"数据类型转换","slug":"数据类型转换","link":"#数据类型转换","children":[{"level":3,"title":"CAST","slug":"cast","link":"#cast","children":[]}]},{"level":2,"title":"常序列生成函数","slug":"常序列生成函数","link":"#常序列生成函数","children":[]},{"level":2,"title":"选择函数","slug":"选择函数","link":"#选择函数","children":[]},{"level":2,"title":"区间查询函数","slug":"区间查询函数","link":"#区间查询函数","children":[{"level":3,"title":"连续满足区间函数","slug":"连续满足区间函数","link":"#连续满足区间函数","children":[]}]},{"level":2,"title":"趋势计算函数","slug":"趋势计算函数","link":"#趋势计算函数","children":[{"level":3,"title":"使用示例","slug":"使用示例-22","link":"#使用示例-22","children":[]}]},{"level":2,"title":"采样函数","slug":"采样函数","link":"#采样函数","children":[{"level":3,"title":"等数量分桶降采样函数","slug":"等数量分桶降采样函数","link":"#等数量分桶降采样函数","children":[]},{"level":3,"title":"M4函数","slug":"m4函数","link":"#m4函数","children":[]}]},{"level":2,"title":"时间序列处理","slug":"时间序列处理","link":"#时间序列处理","children":[{"level":3,"title":"CHANGE_POINTS","slug":"change-points","link":"#change-points","children":[]}]},{"level":2,"title":"Lambda 表达式","slug":"lambda-表达式","link":"#lambda-表达式","children":[{"level":3,"title":"JEXL 自定义函数","slug":"jexl-自定义函数","link":"#jexl-自定义函数","children":[]}]},{"level":2,"title":"条件表达式","slug":"条件表达式","link":"#条件表达式","children":[{"level":3,"title":"CASE","slug":"case","link":"#case","children":[]}]}],"git":{"createdTime":1711707318000,"updatedTime":1711707318000,"contributors":[{"name":"CritasWang","email":"critas@outlook.com","commits":1}]},"readingTime":{"minutes":63.02,"words":18907},"filePathRelative":"zh/UserGuide/Master/Reference/Function-and-Expression.md","localizedDate":"2024年3月29日","autoDesc":true}');export{e as data};