TDengine icon indicating copy to clipboard operation
TDengine copied to clipboard

I created a stream but the supertable doesn't exist

Open q742694312 opened this issue 1 year ago • 4 comments

在刚开始创建流式计算的时候 是可以通过 vibration_stream_stb 表名 查询的, 过了几天就 1716873827678

SHOW STABLES;

vibration_t vibration_stream_stb vibration

超级表 vibration_stream_stb 不存在,超级表vibration_stream_stb 的子表都在 也有数据,

//

SELECT * from information_schema.ins_streams;

1716873682911 1716873703851

q742694312 avatar May 28 '24 05:05 q742694312

版本号是?

yu285 avatar May 28 '24 05:05 yu285

其提供sql语句,我们复现

yu285 avatar May 28 '24 05:05 yu285

版本号3.2.2.0

--CREATE DATABASE TcpDataBase KEEP 36500     
--
--use TcpDataBase;


CREATE STABLE vibration ( ts TIMESTAMP ,
	ax FLOAT,
	sx FLOAT,
	fx FLOAT,
	ay FLOAT,
	sy FLOAT,
	fy FLOAT,
	az FLOAT,
	sz FLOAT,
	fz FLOAT)
	TAGS (code varchar(100));

create stream if not exists vibration_stream fill_history 1  trigger at_once  into vibration_stream_stb   SUBTABLE(CONCAT(code,'_stream_stb')) as 
select  _wstart as wstart, _wend as wend, LAST(*) ,code  from vibration 
where  sx >= 5 or  sy>=5 or sx<=-5 or  sy<=-5 or ax>=180 or ax <=-180  or ay>=180 or ay <=-180  PARTITION BY  code  INTERVAL(10m)

1716874912279

q742694312 avatar May 28 '24 05:05 q742694312

版本号3.2.2.0

q742694312 avatar May 28 '24 07:05 q742694312