如何在TDengine中停止流计算？

Question

我在TDengine中创建了一些流表。我怎么才能把这些桌子停下来？如果我停止了这些表，我可以重新启动它们吗？

Answer 1

可以在sql下面停止流。

taos> show streams;
       streamId       |           user           |           dest table           |        ip:port         |      created time       |        exec time        |       time(us)        |              sql               |   cycles    |
=======================================================================================================================================================================================================================================
 9:1                  | _root                    | query_res                      | 192.168.1.98:35806     | 2021-12-24 16:45:28.287 | 2021-12-24 16:43:30.000 |                     0 | select count(*)    from stb... |           0 |
Query OK, 1 row(s) in set (0.004967s)

taos> kill stream 9:1;
Query OK, 0 row(s) in set (0.000837s)

taos> show streams;
Query OK, 0 row(s) in set (0.003737s)