| import{_ as t,c as a,b as l,o as n}from"./app-BWhNjvfs.js";const e={};function o(p,s){return n(),a("div",null,s[0]||(s[0]=[l(`<h1 id="数据导出" tabindex="-1"><a class="header-anchor" href="#数据导出"><span>数据导出</span></a></h1><h2 id="_1-功能概述" tabindex="-1"><a class="header-anchor" href="#_1-功能概述"><span>1. 功能概述</span></a></h2><p>数据导出工具 <a href="http://export-data.sh/bat" target="_blank" rel="noopener noreferrer">export-data.sh/bat</a> 位于 tools 目录下，能够将指定 SQL 的查询结果导出为 CSV、SQL 及 TsFile（开源时间序列文件格式）格式。具体功能如下：</p><table style="text-align:left;"><tbody><tr><th>文件格式</th><th>IoTDB工具</th><th>具体介绍</th></tr><tr><td>CSV</td><td rowspan="3">export-data.sh/bat</td><td>纯文本格式，存储格式化数据，需按照下文指定 CSV 格式进行构造</td></tr><tr><td>SQL</td><td>包含自定义 SQL 语句的文件</td></tr><tr><td>TsFile</td><td>开源时序数据文件格式</td></tr></tbody></table><h2 id="_2-功能详解" tabindex="-1"><a class="header-anchor" href="#_2-功能详解"><span>2. 功能详解</span></a></h2><h3 id="_2-1-公共参数" tabindex="-1"><a class="header-anchor" href="#_2-1-公共参数"><span>2.1 公共参数</span></a></h3><table><thead><tr><th>参数缩写</th><th>参数全称</th><th>参数含义</th><th>是否为必填项</th><th>默认值</th></tr></thead><tbody><tr><td>-ft</td><td>--file_type</td><td>导出文件的类型，可以选择：csv、sql、tsfile</td><td>√</td><td></td></tr><tr><td>-h</td><td>-- host</td><td>主机名</td><td>否</td><td>127.0.0.1</td></tr><tr><td>-p</td><td>--port</td><td>端口号</td><td>否</td><td>6667</td></tr><tr><td>-u</td><td>--username</td><td>用户名</td><td>否</td><td>root</td></tr><tr><td>-pw</td><td>--password</td><td>密码</td><td>否</td><td>root</td></tr><tr><td>-t</td><td>--target</td><td>指定输出文件的目标文件夹，如果路径不存在新建文件夹</td><td>√</td><td></td></tr><tr><td>-pfn</td><td>--prefix_file_name</td><td>指定导出文件的名称。例如：abc,生成的文件是abc_0.tsfile、abc_1.tsfile</td><td>否</td><td>dump_0.tsfile</td></tr><tr><td>-q</td><td>--query</td><td>要执行的查询命令</td><td>否</td><td>无</td></tr><tr><td>-timeout</td><td>--query_timeout</td><td>会话查询的超时时间(ms)</td><td>否</td><td>-1<br>范围：-1～Long max=9223372036854775807</td></tr><tr><td>-help</td><td>--help</td><td>显示帮助信息</td><td>否</td><td></td></tr></tbody></table><h3 id="_2-2-csv-格式" tabindex="-1"><a class="header-anchor" href="#_2-2-csv-格式"><span>2.2 Csv 格式</span></a></h3><h4 id="_2-2-1-运行命令" tabindex="-1"><a class="header-anchor" href="#_2-2-1-运行命令"><span>2.2.1 运行命令</span></a></h4><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" data-title="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code><span class="line"><span style="color:#7F848E;font-style:italic;"># Unix/OS X</span></span> |
| <span class="line"><span style="color:#ABB2BF;">> tools/export-data.sh -ft<format> [-h </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">host</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-p </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">port</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-u </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">username</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-pw </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">password</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] -t <target_directory> </span></span> |
| <span class="line"><span style="color:#ABB2BF;"> [-pfn </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">prefix_file_name</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-dt </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">datatype</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-lpf </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">lines_per_file</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-tf </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">time_format</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] </span></span> |
| <span class="line"><span style="color:#ABB2BF;"> [-tz </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">timezone</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-q </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">query_command</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-timeout </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">query_timeout</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">]</span></span> |
| <span class="line"><span style="color:#7F848E;font-style:italic;"># Windows</span></span> |
| <span class="line"><span style="color:#ABB2BF;">> tools</span><span style="color:#56B6C2;">\\e</span><span style="color:#ABB2BF;">xport-data.bat -ft<format> [-h </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">host</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-p </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">port</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-u </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">username</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-pw </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">password</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] -t <target_directory> </span></span> |
| <span class="line"><span style="color:#ABB2BF;"> [-pfn </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">prefix_file_name</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-dt </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">datatype</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-lpf </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">lines_per_file</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-tf </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">time_format</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] </span></span> |
| <span class="line"><span style="color:#ABB2BF;"> [-tz </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">timezone</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-q </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">query_command</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-timeout </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">query_timeout</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">]</span></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></div><h4 id="_2-2-2-私有参数" tabindex="-1"><a class="header-anchor" href="#_2-2-2-私有参数"><span>2.2.2 私有参数</span></a></h4><table><thead><tr><th>参数缩写</th><th>参数全称</th><th>参数含义</th><th>是否为必填项</th><th>默认值</th></tr></thead><tbody><tr><td>-dt</td><td>--datatype</td><td>是否在CSV文件的表头输出时间序列的数据类型，可以选择<code>true</code>或<code>false</code></td><td>否</td><td>false</td></tr><tr><td>-lpf</td><td>--lines_per_file</td><td>每个转储文件的行数</td><td>否</td><td>10000<br>范围：0～Integer.Max=2147483647</td></tr><tr><td>-tf</td><td>--time_format</td><td>指定CSV文件中的时间格式。可以选择：1) 时间戳（数字、长整型）；2) ISO8601（默认）；3) 用户自定义模式，如<code>yyyy-MM-dd HH:mm:ss</code>（默认为ISO8601）。SQL文件中的时间戳输出不受时间格式设置影响</td><td>否</td><td>ISO8601</td></tr><tr><td>-tz</td><td>--timezone</td><td>设置时区，例如<code>+08:00</code>或<code>-01:00</code></td><td>否</td><td>本机系统时间</td></tr></tbody></table><h4 id="_2-2-3-运行示例" tabindex="-1"><a class="header-anchor" href="#_2-2-3-运行示例"><span>2.2.3 运行示例：</span></a></h4><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" data-title="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code><span class="line"><span style="color:#7F848E;font-style:italic;"># 正确示例</span></span> |
| <span class="line"><span style="color:#ABB2BF;">> tools/export-data.sh -ft csv -h 127.0.0.1 -p 6667 -u root -pw root -t /path/export/dir </span></span> |
| <span class="line"><span style="color:#61AFEF;"> -pfn</span><span style="color:#98C379;"> exported-data.csv</span><span style="color:#D19A66;"> -dt</span><span style="color:#D19A66;"> true</span><span style="color:#D19A66;"> -lpf</span><span style="color:#D19A66;"> 1000</span><span style="color:#D19A66;"> -tf</span><span style="color:#98C379;"> "yyyy-MM-dd HH:mm:ss"</span></span> |
| <span class="line"><span style="color:#61AFEF;"> -tz</span><span style="color:#98C379;"> +08:00</span><span style="color:#D19A66;"> -q</span><span style="color:#98C379;"> "SELECT * FROM root.ln"</span><span style="color:#D19A66;"> -timeout</span><span style="color:#D19A66;"> 20000</span><span style="color:#ABB2BF;"> </span></span> |
| <span class="line"><span style="color:#ABB2BF;"> </span></span> |
| <span class="line"><span style="color:#7F848E;font-style:italic;"># 异常示例</span></span> |
| <span class="line"><span style="color:#ABB2BF;">> tools/export-data.sh -ft csv -h 127.0.0.1 -p 6667 -u root -pw root</span></span> |
| <span class="line"><span style="color:#61AFEF;">Parse</span><span style="color:#98C379;"> error:</span><span style="color:#98C379;"> Missing</span><span style="color:#98C379;"> required</span><span style="color:#98C379;"> option:</span><span style="color:#98C379;"> t</span></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></div><h3 id="_2-3-sql-格式" tabindex="-1"><a class="header-anchor" href="#_2-3-sql-格式"><span>2.3 Sql 格式</span></a></h3><h4 id="_2-3-1-运行命令" tabindex="-1"><a class="header-anchor" href="#_2-3-1-运行命令"><span>2.3.1 运行命令</span></a></h4><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" data-title="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code><span class="line"><span style="color:#7F848E;font-style:italic;"># Unix/OS X</span></span> |
| <span class="line"><span style="color:#ABB2BF;">> tools/export-data.sh -ft<format> [-h </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">host</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-p </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">port</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-u </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">username</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-pw </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">password</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] </span></span> |
| <span class="line"><span style="color:#61AFEF;"> -t</span><span style="color:#ABB2BF;"> <</span><span style="color:#98C379;">target_director</span><span style="color:#ABB2BF;">y> [-pfn <</span><span style="color:#98C379;">prefix_file_nam</span><span style="color:#ABB2BF;">e></span><span style="color:#98C379;">]</span><span style="color:#ABB2BF;"> [-aligned <</span><span style="color:#98C379;">export</span><span style="color:#98C379;"> aligned</span><span style="color:#98C379;"> insert</span><span style="color:#98C379;"> sq</span><span style="color:#ABB2BF;">l></span><span style="color:#98C379;">]</span></span> |
| <span class="line"><span style="color:#61AFEF;"> -lpf</span><span style="color:#ABB2BF;"> <</span><span style="color:#98C379;">lines_per_fil</span><span style="color:#ABB2BF;">e> </span><span style="color:#98C379;">-</span><span style="color:#ABB2BF;"> [-tf <</span><span style="color:#98C379;">time_forma</span><span style="color:#ABB2BF;">t></span><span style="color:#98C379;">]</span><span style="color:#ABB2BF;"> [-tz <</span><span style="color:#98C379;">timezon</span><span style="color:#ABB2BF;">e></span><span style="color:#98C379;">]</span><span style="color:#ABB2BF;"> [-q <</span><span style="color:#98C379;">query_comman</span><span style="color:#ABB2BF;">d></span><span style="color:#98C379;">]</span><span style="color:#ABB2BF;"> [-timeout <</span><span style="color:#98C379;">query_timeou</span><span style="color:#ABB2BF;">t></span><span style="color:#98C379;">]</span></span> |
| <span class="line"><span style="color:#ABB2BF;"> </span></span> |
| <span class="line"><span style="color:#7F848E;font-style:italic;"># Windows</span></span> |
| <span class="line"><span style="color:#ABB2BF;">> tools</span><span style="color:#56B6C2;">\\e</span><span style="color:#ABB2BF;">xport-data.bat -ft<format> [-h </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">host</span><span style="color:#56B6C2;">></span><span style="color:#56B6C2;"> -p</span><span style="color:#56B6C2;"> <</span><span style="color:#ABB2BF;">port</span><span style="color:#56B6C2;">></span><span style="color:#56B6C2;"> -u</span><span style="color:#56B6C2;"> <</span><span style="color:#ABB2BF;">username</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;"> -pw </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">password</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] </span></span> |
| <span class="line"><span style="color:#61AFEF;"> -t</span><span style="color:#ABB2BF;"> <</span><span style="color:#98C379;">target_director</span><span style="color:#ABB2BF;">y> [-pfn <</span><span style="color:#98C379;">prefix_file_nam</span><span style="color:#ABB2BF;">e> </span><span style="color:#D19A66;">-aligned</span><span style="color:#ABB2BF;"> <</span><span style="color:#98C379;">export</span><span style="color:#98C379;"> aligned</span><span style="color:#98C379;"> insert</span><span style="color:#98C379;"> sq</span><span style="color:#ABB2BF;">l> </span></span> |
| <span class="line"><span style="color:#61AFEF;"> -lpf</span><span style="color:#ABB2BF;"> <</span><span style="color:#98C379;">lines_per_fil</span><span style="color:#ABB2BF;">e> </span><span style="color:#D19A66;">-tf</span><span style="color:#ABB2BF;"> <</span><span style="color:#98C379;">time_forma</span><span style="color:#ABB2BF;">t> </span><span style="color:#D19A66;">-tz</span><span style="color:#ABB2BF;"> <</span><span style="color:#98C379;">timezon</span><span style="color:#ABB2BF;">e> </span><span style="color:#D19A66;">-q</span><span style="color:#ABB2BF;"> <</span><span style="color:#98C379;">query_comman</span><span style="color:#ABB2BF;">d> </span><span style="color:#D19A66;">-timeout</span><span style="color:#ABB2BF;"> <</span><span style="color:#98C379;">query_timeou</span><span style="color:#ABB2BF;">t></span><span style="color:#98C379;">]</span></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></div><h4 id="_2-3-2-私有参数" tabindex="-1"><a class="header-anchor" href="#_2-3-2-私有参数"><span>2.3.2 私有参数</span></a></h4><table><thead><tr><th>参数缩写</th><th>参数全称</th><th>参数含义</th><th>是否为必填项</th><th>默认值</th></tr></thead><tbody><tr><td>-aligned</td><td>--use_aligned</td><td>是否导出为对齐的SQL格式</td><td>否</td><td>true</td></tr><tr><td>-lpf</td><td>--lines_per_file</td><td>每个转储文件的行数</td><td>否</td><td>10000<br>范围：0～Integer.Max=2147483647</td></tr><tr><td>-tf</td><td>--time_format</td><td>指定CSV文件中的时间格式。可以选择：1) 时间戳（数字、长整型）；2) ISO8601（默认）；3) 用户自定义模式，如<code>yyyy-MM-dd HH:mm:ss</code>（默认为ISO8601）。SQL文件中的时间戳输出不受时间格式设置影响</td><td>否</td><td>ISO8601</td></tr><tr><td>-tz</td><td>--timezone</td><td>设置时区，例如<code>+08:00</code>或<code>-01:00</code></td><td>否</td><td>本机系统时间</td></tr></tbody></table><h4 id="_2-3-3-运行示例" tabindex="-1"><a class="header-anchor" href="#_2-3-3-运行示例"><span>2.3.3 运行示例：</span></a></h4><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" data-title="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code><span class="line"><span style="color:#7F848E;font-style:italic;"># 正确示例</span></span> |
| <span class="line"><span style="color:#ABB2BF;">> tools/export-data.sh -ft sql -h 127.0.0.1 -p 6667 -u root -pw root -t /path/export/dir </span></span> |
| <span class="line"><span style="color:#61AFEF;"> -pfn</span><span style="color:#98C379;"> exported-data.csv</span><span style="color:#D19A66;"> -aligned</span><span style="color:#D19A66;"> true</span><span style="color:#D19A66;"> -lpf</span><span style="color:#D19A66;"> 1000</span><span style="color:#D19A66;"> -tf</span><span style="color:#98C379;"> "yyyy-MM-dd HH:mm:ss"</span></span> |
| <span class="line"><span style="color:#61AFEF;"> -tz</span><span style="color:#98C379;"> +08:00</span><span style="color:#D19A66;"> -q</span><span style="color:#98C379;"> "SELECT * FROM root.ln"</span><span style="color:#D19A66;"> -timeout</span><span style="color:#D19A66;"> 20000</span><span style="color:#ABB2BF;"> </span></span> |
| <span class="line"><span style="color:#ABB2BF;"> </span></span> |
| <span class="line"><span style="color:#7F848E;font-style:italic;"># 异常示例</span></span> |
| <span class="line"><span style="color:#ABB2BF;">> tools/export-data.sh -ft sql -h 127.0.0.1 -p 6667 -u root -pw root</span></span> |
| <span class="line"><span style="color:#61AFEF;">Parse</span><span style="color:#98C379;"> error:</span><span style="color:#98C379;"> Missing</span><span style="color:#98C379;"> required</span><span style="color:#98C379;"> option:</span><span style="color:#98C379;"> t</span></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></div><h3 id="_2-4-tsfile-格式" tabindex="-1"><a class="header-anchor" href="#_2-4-tsfile-格式"><span>2.4 TsFile 格式</span></a></h3><h4 id="_2-4-1-运行命令" tabindex="-1"><a class="header-anchor" href="#_2-4-1-运行命令"><span>2.4.1 运行命令</span></a></h4><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" data-title="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code><span class="line"><span style="color:#7F848E;font-style:italic;"># Unix/OS X</span></span> |
| <span class="line"><span style="color:#ABB2BF;">> tools/export-data.sh -ft<format> [-h </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">host</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-p </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">port</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-u </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">username</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-pw </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">password</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">]</span></span> |
| <span class="line"><span style="color:#61AFEF;"> -t</span><span style="color:#ABB2BF;"> <</span><span style="color:#98C379;">target_director</span><span style="color:#ABB2BF;">y> [-pfn <</span><span style="color:#98C379;">prefix_file_nam</span><span style="color:#ABB2BF;">e></span><span style="color:#98C379;">]</span><span style="color:#ABB2BF;"> [-q <</span><span style="color:#98C379;">query_comman</span><span style="color:#ABB2BF;">d></span><span style="color:#98C379;">]</span><span style="color:#ABB2BF;"> [-timeout <</span><span style="color:#98C379;">query_timeou</span><span style="color:#ABB2BF;">t></span><span style="color:#98C379;">]</span></span> |
| <span class="line"><span style="color:#ABB2BF;"> </span></span> |
| <span class="line"><span style="color:#7F848E;font-style:italic;"># Windows</span></span> |
| <span class="line"><span style="color:#ABB2BF;">> tools</span><span style="color:#56B6C2;">\\e</span><span style="color:#ABB2BF;">xport-data.sh -ft<format> [-h </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">host</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-p </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">port</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-u </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">username</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">] [-pw </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">password</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;">]</span></span> |
| <span class="line"><span style="color:#61AFEF;"> -t</span><span style="color:#ABB2BF;"> <</span><span style="color:#98C379;">target_director</span><span style="color:#ABB2BF;">y> [-pfn <</span><span style="color:#98C379;">prefix_file_nam</span><span style="color:#ABB2BF;">e></span><span style="color:#98C379;">]</span><span style="color:#ABB2BF;"> [-q <</span><span style="color:#98C379;">query_comman</span><span style="color:#ABB2BF;">d></span><span style="color:#98C379;">]</span><span style="color:#ABB2BF;"> [-timeout <</span><span style="color:#98C379;">query_timeou</span><span style="color:#ABB2BF;">t></span><span style="color:#98C379;">]</span></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></div><h4 id="_2-4-2-私有参数" tabindex="-1"><a class="header-anchor" href="#_2-4-2-私有参数"><span>2.4.2 私有参数</span></a></h4><ul><li>无</li></ul><h4 id="_2-4-3-运行示例" tabindex="-1"><a class="header-anchor" href="#_2-4-3-运行示例"><span>2.4.3 运行示例：</span></a></h4><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" data-title="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code><span class="line"><span style="color:#7F848E;font-style:italic;"># 正确示例</span></span> |
| <span class="line"><span style="color:#ABB2BF;">> tools/export-data.sh -ft tsfile -h 127.0.0.1 -p 6667 -u root -pw root -t /path/export/dir </span></span> |
| <span class="line"><span style="color:#61AFEF;"> -pfn</span><span style="color:#98C379;"> export-data.tsfile</span><span style="color:#D19A66;"> -q</span><span style="color:#98C379;"> "SELECT * FROM root.ln"</span><span style="color:#D19A66;"> -timeout</span><span style="color:#D19A66;"> 10000</span></span> |
| <span class="line"><span style="color:#ABB2BF;"> </span></span> |
| <span class="line"><span style="color:#7F848E;font-style:italic;"># 异常示例</span></span> |
| <span class="line"><span style="color:#ABB2BF;">> tools/export-data.sh -ft tsfile -h 127.0.0.1 -p 6667 -u root -pw root</span></span> |
| <span class="line"><span style="color:#61AFEF;">Parse</span><span style="color:#98C379;"> error:</span><span style="color:#98C379;"> Missing</span><span style="color:#98C379;"> required</span><span style="color:#98C379;"> option:</span><span style="color:#98C379;"> t</span></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></div>`,28)]))}const c=t(e,[["render",o],["__file","Data-Export-Tool.html.vue"]]),d=JSON.parse('{"path":"/zh/UserGuide/latest/Tools-System/Data-Export-Tool.html","title":"数据导出","lang":"zh-CN","frontmatter":{"description":"数据导出 1. 功能概述 数据导出工具 export-data.sh/bat 位于 tools 目录下，能够将指定 SQL 的查询结果导出为 CSV、SQL 及 TsFile（开源时间序列文件格式）格式。具体功能如下： 2. 功能详解 2.1 公共参数 2.2 Csv 格式 2.2.1 运行命令 2.2.2 私有参数 2.2.3 运行示例： 2.3 S...","head":[["link",{"rel":"alternate","hreflang":"en-us","href":"https://iotdb.apache.org/UserGuide/latest/Tools-System/Data-Export-Tool.html"}],["meta",{"property":"og:url","content":"https://iotdb.apache.org/zh/UserGuide/latest/Tools-System/Data-Export-Tool.html"}],["meta",{"property":"og:site_name","content":"IoTDB Website"}],["meta",{"property":"og:title","content":"数据导出"}],["meta",{"property":"og:description","content":"数据导出 1. 功能概述 数据导出工具 export-data.sh/bat 位于 tools 目录下，能够将指定 SQL 的查询结果导出为 CSV、SQL 及 TsFile（开源时间序列文件格式）格式。具体功能如下： 2. 功能详解 2.1 公共参数 2.2 Csv 格式 2.2.1 运行命令 2.2.2 私有参数 2.2.3 运行示例： 2.3 S..."}],["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":"2025-03-13T04:11:44.000Z"}],["meta",{"property":"article:modified_time","content":"2025-03-13T04:11:44.000Z"}],["script",{"type":"application/ld+json"},"{\\"@context\\":\\"https://schema.org\\",\\"@type\\":\\"Article\\",\\"headline\\":\\"数据导出\\",\\"image\\":[\\"\\"],\\"dateModified\\":\\"2025-03-13T04:11:44.000Z\\",\\"author\\":[]}"]]},"headers":[{"level":2,"title":"1. 功能概述","slug":"_1-功能概述","link":"#_1-功能概述","children":[]},{"level":2,"title":"2. 功能详解","slug":"_2-功能详解","link":"#_2-功能详解","children":[{"level":3,"title":"2.1 公共参数","slug":"_2-1-公共参数","link":"#_2-1-公共参数","children":[]},{"level":3,"title":"2.2 Csv 格式","slug":"_2-2-csv-格式","link":"#_2-2-csv-格式","children":[]},{"level":3,"title":"2.3 Sql 格式","slug":"_2-3-sql-格式","link":"#_2-3-sql-格式","children":[]},{"level":3,"title":"2.4 TsFile 格式","slug":"_2-4-tsfile-格式","link":"#_2-4-tsfile-格式","children":[]}]}],"git":{"createdTime":1731934472000,"updatedTime":1741839104000,"contributors":[{"name":"W1y1r","username":"W1y1r","email":"150988475+W1y1r@users.noreply.github.com","commits":3,"url":"https://github.com/W1y1r"},{"name":"leto-b","username":"leto-b","email":"bingqian.bai@timecho.com","commits":3,"url":"https://github.com/leto-b"}]},"readingTime":{"minutes":3.52,"words":1057},"filePathRelative":"zh/UserGuide/latest/Tools-System/Data-Export-Tool.md","localizedDate":"2024年11月18日","autoDesc":true}');export{c as comp,d as data}; |
