[jira] [Created] (IOTDB-2830) SQL: SHOW PIPE and SHOW PIPESERVER STATUS

["yanze chen (Jira)" <ji...@apache.org>]

yanze chen created IOTDB-2830:
---------------------------------

             Summary: SQL: SHOW PIPE and SHOW PIPESERVER STATUS
                 Key: IOTDB-2830
                 URL: https://issues.apache.org/jira/browse/IOTDB-2830
             Project: Apache IoTDB
          Issue Type: Improvement
          Components: Tools/Sync
            Reporter: yanze chen
            Assignee: yanze chen


显示当前所能支持的 Pipe Sink 类型
IoTDB> SHOW PIPESINKTYPE
IoTDB>
+-----+
| type|
+-----+
|IoTDB|
+-----+
 
显示所有同步任务状态
 * create time，pipe的创建时间
 * name，pipe的名字

 * role，当前IoTDB在pipe中的角色，可能有两种角色：
 ** sender，当前IoTDB为同步发送端

 * receiver，当前IoTDB为同步接收端

 * remote，pipe的对端信息
 ** 当role为receiver时，这一字段值为发送端ip

 * 当role为sender时，这一字段值为pipeSink名称

 * status，pipe状态
 * message，pipe运行信息，当pipe正常运行时，这一字段通常为空，当出现异常时，可能出现两种状态：
 ** WARN状态，这表明发生了数据丢失或者其他错误，但是Pipe会保持运行
 ** ERROR状态，这表明发生了网络长时间中断或者接收端出现问题，Pipe被停止，置为STOP状态
{code:java}
IoTDB> SHOW PIPES
IoTDB>
+-----------------------+--------+--------+-------------+---------+-------+
| create time| name | role| remote| status|message|
+-----------------------+--------+--------+-------------+---------+-------+
|2022-03-30T20:58:30.689|my_pipe1| sender| my_pipesink| STOP| |
+-----------------------+--------+--------+-------------+---------+-------+
|2022-03-31T12:55:28.129|my_pipe2|receiver|192.168.11.11| RUNNING| |
+-----------------------+--------+--------+-------------+---------+-------+ {code}
 
 



--
This message was sent by Atlassian Jira
(v8.20.1#820001)