| import{_ as i,c as o,b as p,d as n,e as a,a as l,w as t,r,o as u}from"./app-qnr2m1Dh.js";const c={};function d(k,s){const e=r("RouteLink");return u(),o("div",null,[s[66]||(s[66]=p(`<h1 id="数据查询" tabindex="-1"><a class="header-anchor" href="#数据查询"><span>数据查询</span></a></h1><h2 id="概述" tabindex="-1"><a class="header-anchor" href="#概述"><span>概述</span></a></h2><p>在 IoTDB 中，使用 <code>SELECT</code> 语句从一条或多条时间序列中查询数据，IoTDB 不区分历史数据和实时数据，用户可以用统一的sql语法进行查询，通过 <code>WHERE</code> 子句中的时间过滤谓词决定查询的时间范围。</p><h3 id="语法定义" tabindex="-1"><a class="header-anchor" href="#语法定义"><span>语法定义</span></a></h3><div class="language-sql line-numbers-mode" data-highlighter="prismjs" data-ext="sql" data-title="sql"><pre><code><span class="line"><span class="token keyword">SELECT</span> <span class="token punctuation">[</span><span class="token keyword">LAST</span><span class="token punctuation">]</span> selectExpr <span class="token punctuation">[</span><span class="token punctuation">,</span> selectExpr<span class="token punctuation">]</span> <span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span></span> |
| <span class="line"> <span class="token punctuation">[</span><span class="token keyword">INTO</span> intoItem <span class="token punctuation">[</span><span class="token punctuation">,</span> intoItem<span class="token punctuation">]</span> <span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">]</span></span> |
| <span class="line"> <span class="token keyword">FROM</span> prefixPath <span class="token punctuation">[</span><span class="token punctuation">,</span> prefixPath<span class="token punctuation">]</span> <span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span></span> |
| <span class="line"> <span class="token punctuation">[</span><span class="token keyword">WHERE</span> whereCondition<span class="token punctuation">]</span></span> |
| <span class="line"> <span class="token punctuation">[</span><span class="token keyword">GROUP</span> <span class="token keyword">BY</span> {</span> |
| <span class="line"> <span class="token punctuation">(</span><span class="token punctuation">[</span>startTime<span class="token punctuation">,</span> endTime<span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token keyword">interval</span> <span class="token punctuation">[</span><span class="token punctuation">,</span> slidingStep<span class="token punctuation">]</span><span class="token punctuation">)</span> <span class="token operator">|</span></span> |
| <span class="line"> <span class="token keyword">LEVEL</span> <span class="token operator">=</span> levelNum <span class="token punctuation">[</span><span class="token punctuation">,</span> levelNum<span class="token punctuation">]</span> <span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span> <span class="token operator">|</span></span> |
| <span class="line"> TAGS<span class="token punctuation">(</span>tagKey <span class="token punctuation">[</span><span class="token punctuation">,</span> tagKey<span class="token punctuation">]</span> <span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span> <span class="token operator">|</span></span> |
| <span class="line"> VARIATION<span class="token punctuation">(</span>expression<span class="token punctuation">[</span><span class="token punctuation">,</span>delta<span class="token punctuation">]</span><span class="token punctuation">[</span><span class="token punctuation">,</span>ignoreNull<span class="token operator">=</span><span class="token boolean">true</span><span class="token operator">/</span><span class="token boolean">false</span><span class="token punctuation">]</span><span class="token punctuation">)</span><span class="token operator">|</span></span> |
| <span class="line"> CONDITION<span class="token punctuation">(</span>expression<span class="token punctuation">,</span><span class="token punctuation">[</span>keep<span class="token operator">></span><span class="token operator">/</span><span class="token operator">>=</span><span class="token operator">/</span><span class="token operator">=</span><span class="token operator">/</span><span class="token operator"><</span><span class="token operator">/</span><span class="token operator"><=</span><span class="token punctuation">]</span>threshold<span class="token punctuation">[</span><span class="token punctuation">,</span>ignoreNull<span class="token operator">=</span><span class="token boolean">true</span><span class="token operator">/</span><span class="token boolean">false</span><span class="token punctuation">]</span><span class="token punctuation">)</span><span class="token operator">|</span></span> |
| <span class="line"> <span class="token keyword">SESSION</span><span class="token punctuation">(</span>timeInterval<span class="token punctuation">)</span></span> |
| <span class="line"> }<span class="token punctuation">]</span></span> |
| <span class="line"> <span class="token punctuation">[</span><span class="token keyword">HAVING</span> havingCondition<span class="token punctuation">]</span></span> |
| <span class="line"> <span class="token punctuation">[</span><span class="token keyword">ORDER</span> <span class="token keyword">BY</span> sortKey {<span class="token keyword">ASC</span> <span class="token operator">|</span> <span class="token keyword">DESC</span>}<span class="token punctuation">]</span></span> |
| <span class="line"> <span class="token punctuation">[</span>FILL <span class="token punctuation">(</span>{PREVIOUS <span class="token operator">|</span> LINEAR <span class="token operator">|</span> constant}<span class="token punctuation">)</span><span class="token punctuation">]</span></span> |
| <span class="line"> <span class="token punctuation">[</span>SLIMIT seriesLimit<span class="token punctuation">]</span> <span class="token punctuation">[</span>SOFFSET seriesOffset<span class="token punctuation">]</span></span> |
| <span class="line"> <span class="token punctuation">[</span><span class="token keyword">LIMIT</span> rowLimit<span class="token punctuation">]</span> <span class="token punctuation">[</span><span class="token keyword">OFFSET</span> rowOffset<span class="token punctuation">]</span></span> |
| <span class="line"> <span class="token punctuation">[</span>ALIGN <span class="token keyword">BY</span> {<span class="token keyword">TIME</span> <span class="token operator">|</span> DEVICE}<span class="token punctuation">]</span></span> |
| <span class="line"></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h3 id="语法说明" tabindex="-1"><a class="header-anchor" href="#语法说明"><span>语法说明</span></a></h3><h4 id="select-子句" tabindex="-1"><a class="header-anchor" href="#select-子句"><span><code>SELECT</code> 子句</span></a></h4>`,7)),n("ul",null,[s[10]||(s[10]=n("li",null,[n("code",null,"SELECT"),a(" 子句指定查询的输出，由若干个 "),n("code",null,"selectExpr"),a(" 组成。")],-1)),s[11]||(s[11]=n("li",null,[a("每个 "),n("code",null,"selectExpr"),a(" 定义查询结果中的一列或多列，它是一个由时间序列路径后缀、常量、函数和运算符组成的表达式。")],-1)),s[12]||(s[12]=n("li",null,[a("支持使用"),n("code",null,"AS"),a("为查询结果集中的列指定别名。")],-1)),n("li",null,[s[1]||(s[1]=a("在 ")),s[2]||(s[2]=n("code",null,"SELECT",-1)),s[3]||(s[3]=a(" 子句中使用 ")),s[4]||(s[4]=n("code",null,"LAST",-1)),s[5]||(s[5]=a(" 关键词可以指定查询为最新点查询，详细说明及示例见文档 ")),l(e,{to:"/zh/UserGuide/V1.1.x/Query-Data/Last-Query.html"},{default:t(()=>s[0]||(s[0]=[a("最新点查询")])),_:1}),s[6]||(s[6]=a(" 。"))]),n("li",null,[s[8]||(s[8]=a("详细说明及示例见文档 ")),l(e,{to:"/zh/UserGuide/V1.1.x/Query-Data/Select-Expression.html"},{default:t(()=>s[7]||(s[7]=[a("选择表达式")])),_:1}),s[9]||(s[9]=a(" 。"))])]),s[67]||(s[67]=n("h4",{id:"into-子句",tabindex:"-1"},[n("a",{class:"header-anchor",href:"#into-子句"},[n("span",null,[n("code",null,"INTO"),a(" 子句")])])],-1)),n("ul",null,[s[16]||(s[16]=n("li",null,[n("code",null,"SELECT INTO"),a(" 用于将查询结果写入一系列指定的时间序列中。"),n("code",null,"INTO"),a(" 子句指定了查询结果写入的目标时间序列。")],-1)),n("li",null,[s[14]||(s[14]=a("详细说明及示例见文档 ")),l(e,{to:"/zh/UserGuide/V1.1.x/Query-Data/Select-Into.html"},{default:t(()=>s[13]||(s[13]=[a("SELECT INTO（查询写回）")])),_:1}),s[15]||(s[15]=a(" 。"))])]),s[68]||(s[68]=p('<h4 id="from-子句" tabindex="-1"><a class="header-anchor" href="#from-子句"><span><code>FROM</code> 子句</span></a></h4><ul><li><code>FROM</code> 子句包含要查询的一个或多个时间序列的路径前缀，支持使用通配符。</li><li>在执行查询时，会将 <code>FROM</code> 子句中的路径前缀和 <code>SELECT</code> 子句中的后缀进行拼接得到完整的查询目标序列。</li></ul><h4 id="where-子句" tabindex="-1"><a class="header-anchor" href="#where-子句"><span><code>WHERE</code> 子句</span></a></h4>',3)),n("ul",null,[s[20]||(s[20]=n("li",null,[n("code",null,"WHERE"),a(" 子句指定了对数据行的筛选条件，由一个 "),n("code",null,"whereCondition"),a(" 组成。")],-1)),s[21]||(s[21]=n("li",null,[n("code",null,"whereCondition"),a(" 是一个逻辑表达式，对于要选择的每一行，其计算结果为真。如果没有 "),n("code",null,"WHERE"),a(" 子句，将选择所有行。")],-1)),s[22]||(s[22]=n("li",null,[a("在 "),n("code",null,"whereCondition"),a(" 中，可以使用除聚合函数之外的任何 IOTDB 支持的函数和运算符。")],-1)),n("li",null,[s[18]||(s[18]=a("详细说明及示例见文档 ")),l(e,{to:"/zh/UserGuide/V1.1.x/Query-Data/Where-Condition.html"},{default:t(()=>s[17]||(s[17]=[a("查询过滤条件")])),_:1}),s[19]||(s[19]=a(" 。"))])]),s[69]||(s[69]=n("h4",{id:"group-by-子句",tabindex:"-1"},[n("a",{class:"header-anchor",href:"#group-by-子句"},[n("span",null,[n("code",null,"GROUP BY"),a(" 子句")])])],-1)),n("ul",null,[s[26]||(s[26]=p("<li><code>GROUP BY</code> 子句指定对序列进行分段或分组聚合的方式。</li><li>分段聚合是指按照时间维度，针对同时间序列中不同数据点之间的时间关系，对数据在行的方向进行分段，每个段得到一个聚合值。目前支持<strong>时间区间分段</strong>、<strong>差值分段</strong>、<strong>条件分段</strong>和<strong>会话分段</strong>，未来将支持更多分段方式。</li><li>分组聚合是指针对不同时间序列，在时间序列的潜在业务属性上分组，每个组包含若干条时间序列，每个组得到一个聚合值。支持<strong>按路径层级分组</strong>和<strong>按序列标签分组</strong>两种分组方式。</li><li>分段聚合和分组聚合可以混合使用。</li>",4)),n("li",null,[s[24]||(s[24]=a("详细说明及示例见文档 ")),l(e,{to:"/zh/UserGuide/V1.1.x/Query-Data/Group-By.html"},{default:t(()=>s[23]||(s[23]=[a("分段分组聚合")])),_:1}),s[25]||(s[25]=a(" 。"))])]),s[70]||(s[70]=n("h4",{id:"having-子句",tabindex:"-1"},[n("a",{class:"header-anchor",href:"#having-子句"},[n("span",null,[n("code",null,"HAVING"),a(" 子句")])])],-1)),n("ul",null,[s[30]||(s[30]=p("<li><code>HAVING</code> 子句指定了对聚合结果的筛选条件，由一个 <code>havingCondition</code> 组成。</li><li><code>havingCondition</code> 是一个逻辑表达式，对于要选择的聚合结果，其计算结果为真。如果没有 <code>HAVING</code> 子句，将选择所有聚合结果。</li><li><code>HAVING</code> 要和聚合函数以及 <code>GROUP BY</code> 子句一起使用。</li>",3)),n("li",null,[s[28]||(s[28]=a("详细说明及示例见文档 ")),l(e,{to:"/zh/UserGuide/V1.1.x/Query-Data/Having-Condition.html"},{default:t(()=>s[27]||(s[27]=[a("聚合结果过滤")])),_:1}),s[29]||(s[29]=a(" 。"))])]),s[71]||(s[71]=n("h4",{id:"order-by-子句",tabindex:"-1"},[n("a",{class:"header-anchor",href:"#order-by-子句"},[n("span",null,[n("code",null,"ORDER BY"),a(" 子句")])])],-1)),n("ul",null,[s[34]||(s[34]=n("li",null,[n("code",null,"ORDER BY"),a(" 子句用于指定结果集的排序方式。")],-1)),s[35]||(s[35]=n("li",null,[a("按时间对齐模式下：默认按照时间戳大小升序排列，可以通过 "),n("code",null,"ORDER BY TIME DESC"),a(" 指定结果集按照时间戳大小降序排列。")],-1)),s[36]||(s[36]=n("li",null,[a("按设备对齐模式下：默认按照设备名的字典序升序排列，每个设备内部按照时间戳大小升序排列，可以通过 "),n("code",null,"ORDER BY"),a(" 子句调整设备列和时间列的排序优先级。")],-1)),n("li",null,[s[32]||(s[32]=a("详细说明及示例见文档 ")),l(e,{to:"/zh/UserGuide/V1.1.x/Query-Data/Order-By.html"},{default:t(()=>s[31]||(s[31]=[a("结果集排序")])),_:1}),s[33]||(s[33]=a("。"))])]),s[72]||(s[72]=n("h4",{id:"fill-子句",tabindex:"-1"},[n("a",{class:"header-anchor",href:"#fill-子句"},[n("span",null,[n("code",null,"FILL"),a(" 子句")])])],-1)),n("ul",null,[s[40]||(s[40]=n("li",null,[n("code",null,"FILL"),a(" 子句用于指定数据缺失情况下的填充模式，允许用户按照特定的方法对任何查询的结果集填充空值。")],-1)),n("li",null,[s[38]||(s[38]=a("详细说明及示例见文档 ")),l(e,{to:"/zh/UserGuide/V1.1.x/Query-Data/Fill.html"},{default:t(()=>s[37]||(s[37]=[a("结果集补空值")])),_:1}),s[39]||(s[39]=a(" 。"))])]),s[73]||(s[73]=n("h4",{id:"slimit-和-soffset-子句",tabindex:"-1"},[n("a",{class:"header-anchor",href:"#slimit-和-soffset-子句"},[n("span",null,[n("code",null,"SLIMIT"),a(" 和 "),n("code",null,"SOFFSET"),a(" 子句")])])],-1)),n("ul",null,[s[44]||(s[44]=n("li",null,[n("code",null,"SLIMIT"),a(" 指定查询结果的列数，"),n("code",null,"SOFFSET"),a(" 指定查询结果显示的起始列位置。"),n("code",null,"SLIMIT"),a(" 和 "),n("code",null,"SOFFSET"),a(" 仅用于控制值列，对时间列和设备列无效。")],-1)),n("li",null,[s[42]||(s[42]=a("关于查询结果分页，详细说明及示例见文档 ")),l(e,{to:"/zh/UserGuide/V1.1.x/Query-Data/Pagination.html"},{default:t(()=>s[41]||(s[41]=[a("结果集分页")])),_:1}),s[43]||(s[43]=a(" 。"))])]),s[74]||(s[74]=n("h4",{id:"limit-和-offset-子句",tabindex:"-1"},[n("a",{class:"header-anchor",href:"#limit-和-offset-子句"},[n("span",null,[n("code",null,"LIMIT"),a(" 和 "),n("code",null,"OFFSET"),a(" 子句")])])],-1)),n("ul",null,[s[48]||(s[48]=n("li",null,[n("code",null,"LIMIT"),a(" 指定查询结果的行数，"),n("code",null,"OFFSET"),a(" 指定查询结果显示的起始行位置。")],-1)),n("li",null,[s[46]||(s[46]=a("关于查询结果分页，详细说明及示例见文档 ")),l(e,{to:"/zh/UserGuide/V1.1.x/Query-Data/Pagination.html"},{default:t(()=>s[45]||(s[45]=[a("结果集分页")])),_:1}),s[47]||(s[47]=a(" 。"))])]),s[75]||(s[75]=n("h4",{id:"align-by-子句",tabindex:"-1"},[n("a",{class:"header-anchor",href:"#align-by-子句"},[n("span",null,[n("code",null,"ALIGN BY"),a(" 子句")])])],-1)),n("ul",null,[s[52]||(s[52]=n("li",null,[a("查询结果集默认"),n("strong",null,"按时间对齐"),a("，包含一列时间列和若干个值列，每一行数据各列的时间戳相同。")],-1)),s[53]||(s[53]=n("li",null,[a("除按时间对齐之外，还支持"),n("strong",null,"按设备对齐"),a("，查询结果集包含一列时间列、一列设备列和若干个值列。")],-1)),n("li",null,[s[50]||(s[50]=a("详细说明及示例见文档 ")),l(e,{to:"/zh/UserGuide/V1.1.x/Query-Data/Align-By.html"},{default:t(()=>s[49]||(s[49]=[a("查询对齐模式")])),_:1}),s[51]||(s[51]=a(" 。"))])]),s[76]||(s[76]=p(`<h3 id="sql-示例" tabindex="-1"><a class="header-anchor" href="#sql-示例"><span>SQL 示例</span></a></h3><p>IoTDB 支持即席(Ad_hoc)查询，即支持用户在使用系统时，自定义查询条件，根据自己当时的需求写出查询sql并执行。用户可以通过上述介绍的子句，进行组合，指定任意合法的过滤条件来满足当时的查询需求，下面介绍了一些查询的示例：</p><h4 id="示例1-根据一个时间区间选择一列数据" tabindex="-1"><a class="header-anchor" href="#示例1-根据一个时间区间选择一列数据"><span>示例1：根据一个时间区间选择一列数据</span></a></h4><p>SQL 语句为：</p><div class="language-sql line-numbers-mode" data-highlighter="prismjs" data-ext="sql" data-title="sql"><pre><code><span class="line"><span class="token keyword">select</span> temperature <span class="token keyword">from</span> root<span class="token punctuation">.</span>ln<span class="token punctuation">.</span>wf01<span class="token punctuation">.</span>wt01 <span class="token keyword">where</span> <span class="token keyword">time</span> <span class="token operator"><</span> <span class="token number">2017</span><span class="token operator">-</span><span class="token number">11</span><span class="token operator">-</span><span class="token number">01</span>T00:<span class="token number">08</span>:<span class="token number">00.000</span></span> |
| <span class="line"></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p>其含义为：</p><p>被选择的设备为 ln 集团 wf01 子站 wt01 设备；被选择的时间序列为温度传感器（temperature）；该语句要求选择出该设备在 “2017-11-01T00:08:00.000” 时间点以前的所有温度传感器的值。</p><p>该 SQL 语句的执行结果如下：</p><div class="language-text line-numbers-mode" data-highlighter="prismjs" data-ext="text" data-title="text"><pre><code><span class="line">+-----------------------------+-----------------------------+</span> |
| <span class="line">| Time|root.ln.wf01.wt01.temperature|</span> |
| <span class="line">+-----------------------------+-----------------------------+</span> |
| <span class="line">|2017-11-01T00:00:00.000+08:00| 25.96|</span> |
| <span class="line">|2017-11-01T00:01:00.000+08:00| 24.36|</span> |
| <span class="line">|2017-11-01T00:02:00.000+08:00| 20.09|</span> |
| <span class="line">|2017-11-01T00:03:00.000+08:00| 20.18|</span> |
| <span class="line">|2017-11-01T00:04:00.000+08:00| 21.13|</span> |
| <span class="line">|2017-11-01T00:05:00.000+08:00| 22.72|</span> |
| <span class="line">|2017-11-01T00:06:00.000+08:00| 20.71|</span> |
| <span class="line">|2017-11-01T00:07:00.000+08:00| 21.45|</span> |
| <span class="line">+-----------------------------+-----------------------------+</span> |
| <span class="line">Total line number = 8</span> |
| <span class="line">It costs 0.026s</span> |
| <span class="line"></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h4 id="示例2-根据一个时间区间选择多列数据" tabindex="-1"><a class="header-anchor" href="#示例2-根据一个时间区间选择多列数据"><span>示例2：根据一个时间区间选择多列数据</span></a></h4><p>SQL 语句为：</p><div class="language-sql line-numbers-mode" data-highlighter="prismjs" data-ext="sql" data-title="sql"><pre><code><span class="line"><span class="token keyword">select</span> <span class="token keyword">status</span><span class="token punctuation">,</span> temperature <span class="token keyword">from</span> root<span class="token punctuation">.</span>ln<span class="token punctuation">.</span>wf01<span class="token punctuation">.</span>wt01 <span class="token keyword">where</span> <span class="token keyword">time</span> <span class="token operator">></span> <span class="token number">2017</span><span class="token operator">-</span><span class="token number">11</span><span class="token operator">-</span><span class="token number">01</span>T00:<span class="token number">05</span>:<span class="token number">00.000</span> <span class="token operator">and</span> <span class="token keyword">time</span> <span class="token operator"><</span> <span class="token number">2017</span><span class="token operator">-</span><span class="token number">11</span><span class="token operator">-</span><span class="token number">01</span>T00:<span class="token number">12</span>:<span class="token number">00.000</span><span class="token punctuation">;</span></span> |
| <span class="line"></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p>其含义为：</p><p>被选择的设备为 ln 集团 wf01 子站 wt01 设备；被选择的时间序列为供电状态（status）和温度传感器（temperature）；该语句要求选择出 “2017-11-01T00:05:00.000” 至 “2017-11-01T00:12:00.000” 之间的所选时间序列的值。</p><p>该 SQL 语句的执行结果如下：</p><div class="language-text line-numbers-mode" data-highlighter="prismjs" data-ext="text" data-title="text"><pre><code><span class="line">+-----------------------------+------------------------+-----------------------------+</span> |
| <span class="line">| Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature|</span> |
| <span class="line">+-----------------------------+------------------------+-----------------------------+</span> |
| <span class="line">|2017-11-01T00:06:00.000+08:00| false| 20.71|</span> |
| <span class="line">|2017-11-01T00:07:00.000+08:00| false| 21.45|</span> |
| <span class="line">|2017-11-01T00:08:00.000+08:00| false| 22.58|</span> |
| <span class="line">|2017-11-01T00:09:00.000+08:00| false| 20.98|</span> |
| <span class="line">|2017-11-01T00:10:00.000+08:00| true| 25.52|</span> |
| <span class="line">|2017-11-01T00:11:00.000+08:00| false| 22.91|</span> |
| <span class="line">+-----------------------------+------------------------+-----------------------------+</span> |
| <span class="line">Total line number = 6</span> |
| <span class="line">It costs 0.018s</span> |
| <span class="line"></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h4 id="示例3-按照多个时间区间选择同一设备的多列数据" tabindex="-1"><a class="header-anchor" href="#示例3-按照多个时间区间选择同一设备的多列数据"><span>示例3：按照多个时间区间选择同一设备的多列数据</span></a></h4><p>IoTDB 支持在一次查询中指定多个时间区间条件，用户可以根据需求随意组合时间区间条件。例如，</p><p>SQL 语句为：</p><div class="language-sql line-numbers-mode" data-highlighter="prismjs" data-ext="sql" data-title="sql"><pre><code><span class="line"><span class="token keyword">select</span> <span class="token keyword">status</span><span class="token punctuation">,</span> temperature <span class="token keyword">from</span> root<span class="token punctuation">.</span>ln<span class="token punctuation">.</span>wf01<span class="token punctuation">.</span>wt01 <span class="token keyword">where</span> <span class="token punctuation">(</span><span class="token keyword">time</span> <span class="token operator">></span> <span class="token number">2017</span><span class="token operator">-</span><span class="token number">11</span><span class="token operator">-</span><span class="token number">01</span>T00:<span class="token number">05</span>:<span class="token number">00.000</span> <span class="token operator">and</span> <span class="token keyword">time</span> <span class="token operator"><</span> <span class="token number">2017</span><span class="token operator">-</span><span class="token number">11</span><span class="token operator">-</span><span class="token number">01</span>T00:<span class="token number">12</span>:<span class="token number">00.000</span><span class="token punctuation">)</span> <span class="token operator">or</span> <span class="token punctuation">(</span><span class="token keyword">time</span> <span class="token operator">>=</span> <span class="token number">2017</span><span class="token operator">-</span><span class="token number">11</span><span class="token operator">-</span><span class="token number">01</span>T16:<span class="token number">35</span>:<span class="token number">00.000</span> <span class="token operator">and</span> <span class="token keyword">time</span> <span class="token operator"><=</span> <span class="token number">2017</span><span class="token operator">-</span><span class="token number">11</span><span class="token operator">-</span><span class="token number">01</span>T16:<span class="token number">37</span>:<span class="token number">00.000</span><span class="token punctuation">)</span><span class="token punctuation">;</span></span> |
| <span class="line"></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p>其含义为：</p><p>被选择的设备为 ln 集团 wf01 子站 wt01 设备；被选择的时间序列为“供电状态（status）”和“温度传感器（temperature）”；该语句指定了两个不同的时间区间，分别为“2017-11-01T00:05:00.000 至 2017-11-01T00:12:00.000”和“2017-11-01T16:35:00.000 至 2017-11-01T16:37:00.000”；该语句要求选择出满足任一时间区间的被选时间序列的值。</p><p>该 SQL 语句的执行结果如下：</p><div class="language-text line-numbers-mode" data-highlighter="prismjs" data-ext="text" data-title="text"><pre><code><span class="line">+-----------------------------+------------------------+-----------------------------+</span> |
| <span class="line">| Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature|</span> |
| <span class="line">+-----------------------------+------------------------+-----------------------------+</span> |
| <span class="line">|2017-11-01T00:06:00.000+08:00| false| 20.71|</span> |
| <span class="line">|2017-11-01T00:07:00.000+08:00| false| 21.45|</span> |
| <span class="line">|2017-11-01T00:08:00.000+08:00| false| 22.58|</span> |
| <span class="line">|2017-11-01T00:09:00.000+08:00| false| 20.98|</span> |
| <span class="line">|2017-11-01T00:10:00.000+08:00| true| 25.52|</span> |
| <span class="line">|2017-11-01T00:11:00.000+08:00| false| 22.91|</span> |
| <span class="line">|2017-11-01T16:35:00.000+08:00| true| 23.44|</span> |
| <span class="line">|2017-11-01T16:36:00.000+08:00| false| 21.98|</span> |
| <span class="line">|2017-11-01T16:37:00.000+08:00| false| 21.93|</span> |
| <span class="line">+-----------------------------+------------------------+-----------------------------+</span> |
| <span class="line">Total line number = 9</span> |
| <span class="line">It costs 0.018s</span> |
| <span class="line"></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h4 id="示例4-按照多个时间区间选择不同设备的多列数据" tabindex="-1"><a class="header-anchor" href="#示例4-按照多个时间区间选择不同设备的多列数据"><span>示例4：按照多个时间区间选择不同设备的多列数据</span></a></h4><p>该系统支持在一次查询中选择任意列的数据，也就是说，被选择的列可以来源于不同的设备。例如，SQL 语句为：</p><div class="language-sql line-numbers-mode" data-highlighter="prismjs" data-ext="sql" data-title="sql"><pre><code><span class="line"><span class="token keyword">select</span> wf01<span class="token punctuation">.</span>wt01<span class="token punctuation">.</span><span class="token keyword">status</span><span class="token punctuation">,</span> wf02<span class="token punctuation">.</span>wt02<span class="token punctuation">.</span>hardware <span class="token keyword">from</span> root<span class="token punctuation">.</span>ln <span class="token keyword">where</span> <span class="token punctuation">(</span><span class="token keyword">time</span> <span class="token operator">></span> <span class="token number">2017</span><span class="token operator">-</span><span class="token number">11</span><span class="token operator">-</span><span class="token number">01</span>T00:<span class="token number">05</span>:<span class="token number">00.000</span> <span class="token operator">and</span> <span class="token keyword">time</span> <span class="token operator"><</span> <span class="token number">2017</span><span class="token operator">-</span><span class="token number">11</span><span class="token operator">-</span><span class="token number">01</span>T00:<span class="token number">12</span>:<span class="token number">00.000</span><span class="token punctuation">)</span> <span class="token operator">or</span> <span class="token punctuation">(</span><span class="token keyword">time</span> <span class="token operator">>=</span> <span class="token number">2017</span><span class="token operator">-</span><span class="token number">11</span><span class="token operator">-</span><span class="token number">01</span>T16:<span class="token number">35</span>:<span class="token number">00.000</span> <span class="token operator">and</span> <span class="token keyword">time</span> <span class="token operator"><=</span> <span class="token number">2017</span><span class="token operator">-</span><span class="token number">11</span><span class="token operator">-</span><span class="token number">01</span>T16:<span class="token number">37</span>:<span class="token number">00.000</span><span class="token punctuation">)</span><span class="token punctuation">;</span></span> |
| <span class="line"></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p>其含义为：</p><p>被选择的时间序列为 “ln 集团 wf01 子站 wt01 设备的供电状态” 以及 “ln 集团 wf02 子站 wt02 设备的硬件版本”；该语句指定了两个时间区间，分别为 “2017-11-01T00:05:00.000 至 2017-11-01T00:12:00.000” 和 “2017-11-01T16:35:00.000 至 2017-11-01T16:37:00.000”；该语句要求选择出满足任意时间区间的被选时间序列的值。</p><p>该 SQL 语句的执行结果如下：</p><div class="language-text line-numbers-mode" data-highlighter="prismjs" data-ext="text" data-title="text"><pre><code><span class="line">+-----------------------------+------------------------+--------------------------+</span> |
| <span class="line">| Time|root.ln.wf01.wt01.status|root.ln.wf02.wt02.hardware|</span> |
| <span class="line">+-----------------------------+------------------------+--------------------------+</span> |
| <span class="line">|2017-11-01T00:06:00.000+08:00| false| v1|</span> |
| <span class="line">|2017-11-01T00:07:00.000+08:00| false| v1|</span> |
| <span class="line">|2017-11-01T00:08:00.000+08:00| false| v1|</span> |
| <span class="line">|2017-11-01T00:09:00.000+08:00| false| v1|</span> |
| <span class="line">|2017-11-01T00:10:00.000+08:00| true| v2|</span> |
| <span class="line">|2017-11-01T00:11:00.000+08:00| false| v1|</span> |
| <span class="line">|2017-11-01T16:35:00.000+08:00| true| v2|</span> |
| <span class="line">|2017-11-01T16:36:00.000+08:00| false| v1|</span> |
| <span class="line">|2017-11-01T16:37:00.000+08:00| false| v1|</span> |
| <span class="line">+-----------------------------+------------------------+--------------------------+</span> |
| <span class="line">Total line number = 9</span> |
| <span class="line">It costs 0.014s</span> |
| <span class="line"></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h4 id="示例5-根据时间降序返回结果集" tabindex="-1"><a class="header-anchor" href="#示例5-根据时间降序返回结果集"><span>示例5：根据时间降序返回结果集</span></a></h4><p>IoTDB 支持 <code>order by time</code> 语句，用于对结果按照时间进行降序展示。例如，SQL 语句为：</p><div class="language-sql line-numbers-mode" data-highlighter="prismjs" data-ext="sql" data-title="sql"><pre><code><span class="line"><span class="token keyword">select</span> <span class="token operator">*</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>ln<span class="token punctuation">.</span><span class="token operator">*</span><span class="token operator">*</span> <span class="token keyword">where</span> <span class="token keyword">time</span> <span class="token operator">></span> <span class="token number">1</span> <span class="token keyword">order</span> <span class="token keyword">by</span> <span class="token keyword">time</span> <span class="token keyword">desc</span> <span class="token keyword">limit</span> <span class="token number">10</span><span class="token punctuation">;</span></span> |
| <span class="line"></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p>语句执行的结果为：</p><div class="language-text line-numbers-mode" data-highlighter="prismjs" data-ext="text" data-title="text"><pre><code><span class="line">+-----------------------------+--------------------------+------------------------+-----------------------------+------------------------+</span> |
| <span class="line">| Time|root.ln.wf02.wt02.hardware|root.ln.wf02.wt02.status|root.ln.wf01.wt01.temperature|root.ln.wf01.wt01.status|</span> |
| <span class="line">+-----------------------------+--------------------------+------------------------+-----------------------------+------------------------+</span> |
| <span class="line">|2017-11-07T23:59:00.000+08:00| v1| false| 21.07| false|</span> |
| <span class="line">|2017-11-07T23:58:00.000+08:00| v1| false| 22.93| false|</span> |
| <span class="line">|2017-11-07T23:57:00.000+08:00| v2| true| 24.39| true|</span> |
| <span class="line">|2017-11-07T23:56:00.000+08:00| v2| true| 24.44| true|</span> |
| <span class="line">|2017-11-07T23:55:00.000+08:00| v2| true| 25.9| true|</span> |
| <span class="line">|2017-11-07T23:54:00.000+08:00| v1| false| 22.52| false|</span> |
| <span class="line">|2017-11-07T23:53:00.000+08:00| v2| true| 24.58| true|</span> |
| <span class="line">|2017-11-07T23:52:00.000+08:00| v1| false| 20.18| false|</span> |
| <span class="line">|2017-11-07T23:51:00.000+08:00| v1| false| 22.24| false|</span> |
| <span class="line">|2017-11-07T23:50:00.000+08:00| v2| true| 23.7| true|</span> |
| <span class="line">+-----------------------------+--------------------------+------------------------+-----------------------------+------------------------+</span> |
| <span class="line">Total line number = 10</span> |
| <span class="line">It costs 0.016s</span> |
| <span class="line"></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h3 id="查询执行接口" tabindex="-1"><a class="header-anchor" href="#查询执行接口"><span>查询执行接口</span></a></h3><p>在 IoTDB 中，提供两种方式执行数据查询操作：</p><ul><li>使用 IoTDB-SQL 执行查询。</li><li>常用查询的高效执行接口，包括时间序列原始数据范围查询、最新点查询、简单聚合查询。</li></ul><h4 id="使用-iotdb-sql-执行查询" tabindex="-1"><a class="header-anchor" href="#使用-iotdb-sql-执行查询"><span>使用 IoTDB-SQL 执行查询</span></a></h4><p>数据查询语句支持在 SQL 命令行终端、JDBC、JAVA / C++ / Python / Go 等编程语言 API、RESTful API 中使用。</p>`,41)),n("ul",null,[n("li",null,[n("p",null,[s[55]||(s[55]=a("在 SQL 命令行终端中执行查询语句：启动 SQL 命令行终端，直接输入查询语句执行即可，详见 ")),l(e,{to:"/zh/UserGuide/V1.1.x/QuickStart/Command-Line-Interface.html"},{default:t(()=>s[54]||(s[54]=[a("SQL 命令行终端")])),_:1}),s[56]||(s[56]=a("。"))])]),n("li",null,[n("p",null,[s[58]||(s[58]=a("在 JDBC 中执行查询语句，详见 ")),l(e,{to:"/zh/UserGuide/V1.1.x/API/Programming-JDBC.html"},{default:t(()=>s[57]||(s[57]=[a("JDBC")])),_:1}),s[59]||(s[59]=a(" 。"))])]),s[65]||(s[65]=p(`<li><p>在 JAVA / C++ / Python / Go 等编程语言 API 中执行查询语句，详见应用编程接口一章相应文档。接口原型如下：</p><div class="language-java line-numbers-mode" data-highlighter="prismjs" data-ext="java" data-title="java"><pre><code><span class="line"><span class="token class-name">SessionDataSet</span> <span class="token function">executeQueryStatement</span><span class="token punctuation">(</span><span class="token class-name">String</span> sql<span class="token punctuation">)</span><span class="token punctuation">;</span></span> |
| <span class="line"></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div></li>`,1)),n("li",null,[n("p",null,[s[62]||(s[62]=a("在 RESTful API 中使用，详见 ")),l(e,{to:"/zh/UserGuide/V1.1.x/API/RestServiceV1.html"},{default:t(()=>s[60]||(s[60]=[a("HTTP API V1")])),_:1}),s[63]||(s[63]=a(" 或者 ")),l(e,{to:"/zh/UserGuide/V1.1.x/API/RestServiceV2.html"},{default:t(()=>s[61]||(s[61]=[a("HTTP API V2")])),_:1}),s[64]||(s[64]=a("。"))])])]),s[77]||(s[77]=p(`<h4 id="常用查询的高效执行接口" tabindex="-1"><a class="header-anchor" href="#常用查询的高效执行接口"><span>常用查询的高效执行接口</span></a></h4><p>各编程语言的 API 为常用的查询提供了高效执行接口，可以省去 SQL 解析等操作的耗时。包括：</p><ul><li>时间序列原始数据范围查询： <ul><li>指定的查询时间范围为左闭右开区间，包含开始时间但不包含结束时间。</li></ul></li></ul><div class="language-java line-numbers-mode" data-highlighter="prismjs" data-ext="java" data-title="java"><pre><code><span class="line"><span class="token class-name">SessionDataSet</span> <span class="token function">executeRawDataQuery</span><span class="token punctuation">(</span><span class="token class-name">List</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">String</span><span class="token punctuation">></span></span> paths<span class="token punctuation">,</span> <span class="token keyword">long</span> startTime<span class="token punctuation">,</span> <span class="token keyword">long</span> endTime<span class="token punctuation">)</span><span class="token punctuation">;</span></span> |
| <span class="line"></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><ul><li>最新点查询： <ul><li>查询最后一条时间戳大于等于某个时间点的数据。</li></ul></li></ul><div class="language-java line-numbers-mode" data-highlighter="prismjs" data-ext="java" data-title="java"><pre><code><span class="line"><span class="token class-name">SessionDataSet</span> <span class="token function">executeLastDataQuery</span><span class="token punctuation">(</span><span class="token class-name">List</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">String</span><span class="token punctuation">></span></span> paths<span class="token punctuation">,</span> <span class="token keyword">long</span> lastTime<span class="token punctuation">)</span><span class="token punctuation">;</span></span> |
| <span class="line"></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><ul><li>聚合查询： <ul><li>支持指定查询时间范围。指定的查询时间范围为左闭右开区间，包含开始时间但不包含结束时间。</li><li>支持按照时间区间分段查询。</li></ul></li></ul><div class="language-java line-numbers-mode" data-highlighter="prismjs" data-ext="java" data-title="java"><pre><code><span class="line"><span class="token class-name">SessionDataSet</span> <span class="token function">executeAggregationQuery</span><span class="token punctuation">(</span><span class="token class-name">List</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">String</span><span class="token punctuation">></span></span> paths<span class="token punctuation">,</span> <span class="token class-name">List</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">Aggregation</span><span class="token punctuation">></span></span> aggregations<span class="token punctuation">)</span><span class="token punctuation">;</span></span> |
| <span class="line"></span> |
| <span class="line"><span class="token class-name">SessionDataSet</span> <span class="token function">executeAggregationQuery</span><span class="token punctuation">(</span></span> |
| <span class="line"> <span class="token class-name">List</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">String</span><span class="token punctuation">></span></span> paths<span class="token punctuation">,</span> <span class="token class-name">List</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">Aggregation</span><span class="token punctuation">></span></span> aggregations<span class="token punctuation">,</span> <span class="token keyword">long</span> startTime<span class="token punctuation">,</span> <span class="token keyword">long</span> endTime<span class="token punctuation">)</span><span class="token punctuation">;</span></span> |
| <span class="line"></span> |
| <span class="line"><span class="token class-name">SessionDataSet</span> <span class="token function">executeAggregationQuery</span><span class="token punctuation">(</span></span> |
| <span class="line"> <span class="token class-name">List</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">String</span><span class="token punctuation">></span></span> paths<span class="token punctuation">,</span></span> |
| <span class="line"> <span class="token class-name">List</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">Aggregation</span><span class="token punctuation">></span></span> aggregations<span class="token punctuation">,</span></span> |
| <span class="line"> <span class="token keyword">long</span> startTime<span class="token punctuation">,</span></span> |
| <span class="line"> <span class="token keyword">long</span> endTime<span class="token punctuation">,</span></span> |
| <span class="line"> <span class="token keyword">long</span> interval<span class="token punctuation">)</span><span class="token punctuation">;</span></span> |
| <span class="line"></span> |
| <span class="line"><span class="token class-name">SessionDataSet</span> <span class="token function">executeAggregationQuery</span><span class="token punctuation">(</span></span> |
| <span class="line"> <span class="token class-name">List</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">String</span><span class="token punctuation">></span></span> paths<span class="token punctuation">,</span></span> |
| <span class="line"> <span class="token class-name">List</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">Aggregation</span><span class="token punctuation">></span></span> aggregations<span class="token punctuation">,</span></span> |
| <span class="line"> <span class="token keyword">long</span> startTime<span class="token punctuation">,</span></span> |
| <span class="line"> <span class="token keyword">long</span> endTime<span class="token punctuation">,</span></span> |
| <span class="line"> <span class="token keyword">long</span> interval<span class="token punctuation">,</span></span> |
| <span class="line"> <span class="token keyword">long</span> slidingStep<span class="token punctuation">)</span><span class="token punctuation">;</span></span> |
| <span class="line"></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div>`,8))])}const v=i(c,[["render",d],["__file","Overview.html.vue"]]),b=JSON.parse('{"path":"/zh/UserGuide/V1.1.x/Query-Data/Overview.html","title":"数据查询","lang":"zh-CN","frontmatter":{"description":"数据查询 概述 在 IoTDB 中，使用 SELECT 语句从一条或多条时间序列中查询数据，IoTDB 不区分历史数据和实时数据，用户可以用统一的sql语法进行查询，通过 WHERE 子句中的时间过滤谓词决定查询的时间范围。 语法定义 语法说明 SELECT 子句 SELECT 子句指定查询的输出，由若干个 selectExpr 组成。 每个 sele...","head":[["link",{"rel":"alternate","hreflang":"en-us","href":"https://iotdb.apache.org/UserGuide/V1.1.x/Query-Data/Overview.html"}],["meta",{"property":"og:url","content":"https://iotdb.apache.org/zh/UserGuide/V1.1.x/Query-Data/Overview.html"}],["meta",{"property":"og:site_name","content":"IoTDB Website"}],["meta",{"property":"og:title","content":"数据查询"}],["meta",{"property":"og:description","content":"数据查询 概述 在 IoTDB 中，使用 SELECT 语句从一条或多条时间序列中查询数据，IoTDB 不区分历史数据和实时数据，用户可以用统一的sql语法进行查询，通过 WHERE 子句中的时间过滤谓词决定查询的时间范围。 语法定义 语法说明 SELECT 子句 SELECT 子句指定查询的输出，由若干个 selectExpr 组成。 每个 sele..."}],["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":"2023-07-31T13:49:08.000Z"}],["meta",{"property":"article:modified_time","content":"2023-07-31T13:49:08.000Z"}],["script",{"type":"application/ld+json"},"{\\"@context\\":\\"https://schema.org\\",\\"@type\\":\\"Article\\",\\"headline\\":\\"数据查询\\",\\"image\\":[\\"\\"],\\"dateModified\\":\\"2023-07-31T13:49:08.000Z\\",\\"author\\":[]}"]]},"headers":[{"level":2,"title":"概述","slug":"概述","link":"#概述","children":[{"level":3,"title":"语法定义","slug":"语法定义","link":"#语法定义","children":[]},{"level":3,"title":"语法说明","slug":"语法说明","link":"#语法说明","children":[]},{"level":3,"title":"SQL 示例","slug":"sql-示例","link":"#sql-示例","children":[]},{"level":3,"title":"查询执行接口","slug":"查询执行接口","link":"#查询执行接口","children":[]}]}],"git":{"createdTime":1688958677000,"updatedTime":1690811348000,"contributors":[{"name":"CritasWang","email":"critas@outlook.com","commits":1},{"name":"Jackie Tien","email":"jackietien97@gmail.com","commits":1}]},"readingTime":{"minutes":10.5,"words":3150},"filePathRelative":"zh/UserGuide/V1.1.x/Query-Data/Overview.md","localizedDate":"2023年7月10日","autoDesc":true}');export{v as comp,b as data}; |
