Tdengine 创建流计算一直报错

开源版问题专区
1

【TDengine 使用环境】
测试

【TDengine 版本】3.4.1.13 社区版

【操作系统以及版本】

【部署方式】docker部署

CREATE STREAM avg_vol_s INTO avg_vol AS

SELECT _wstart, count(*), avg(voltage)

FROM meters

PARTITION BY tbname

INTERVAL(1m) SLIDING(30s);

执行 SQL 错误 [9728]: TDengine ERROR (0x2600): sql: CREATE STREAM avg_vol_s INTO avg_vol AS

SELECT _wstart, count(*), avg(voltage)

FROM meters

PARTITION BY tbname

INTERVAL(1m) SLIDING(30s)

, desc: syntax error near "into avg_vol as

select _wstart, count(*), avg(voltage)

from meters

partition by tbname

interval(1m) sliding(30s)"

2

在 TDengine 中，更正确的写法是：

sql

CREATE STREAM avg_vol_s AS
SELECT _wstart, count(*), avg(voltage)
FROM meters
PARTITION BY tbname
INTERVAL(1m) SLIDING(30s)
INTO avg_vol;
3

taos> CREATE STREAM avg_vol_s AS SELECT _wstart, count(*), avg(voltage) FROM meters PARTITION BY tbname INTERVAL(1m) SLIDING(30s) INTO avg_vol;

DB error: syntax error near “as select _wstart, count(*), avg(voltage) from meters partition by tbname interval(1m) sliding(30s) into avg_vol;” [0x80002600] (0.000064s)
在服务器上登录taos，执行还是不行，不知道是不是版本问题，3.4.1.13社区版

4

你这种写法是 3.3.6.x及以前版本的语法，3.4.x.x版本的流相关语句有变化了。

请参考官网语法说明：