8000
建表语句 CREATE MEASUREMENT t_monitor_0000000003_4_6_1 (itemCode TAG, itemValue STRING) WITH ENGINETYPE = COLUMNSTORE SHARDKEY itemCode PRIMARYKEY itemCode SORTKEY itemCode,time
No response
可以提供更详细的信息吗?比如openGemini的版本,是单机还是集群?或许你可以参考我的方式看能否解决问题。 我用最新源码编译的openGemini,然后启了一个单机的数据库,按照你的方式进行了建表,然后插入了几条数据,测试没有复现出你所遇到的问题。
> CREATE MEASUREMENT t_monitor_0000000003_4_6_1 (itemCode TAG, itemValue STRING) WITH ENGINETYPE = COLUMNSTORE SHARDKEY itemCode PRIMARYKEY itemCode SORTKEY itemCode,time > select * from t_monitor_0000000003_4_6_1 name: t_monitor_0000000003_4_6_1 +---------------------+------------+-----------+ | time | itemCode | itemValue | +---------------------+------------+-----------+ | 1755565790901288300 | workStatus | 2 | | 1755566105512529800 | txzt | 3 | | 1755565773014009600 | wd | 27.0 | | 1755565766099936900 | wd | 26.0 | | 1755566113462521700 | txzt | 89.5 | | 1755566108703479500 | txzt | 7 | +---------------------+------------+-----------+ 3 columns, 6 rows in set > select * from t_monitor_0000000003_4_6_1 where time >= 1755565766099936900 and time <= 1755565790901288300 and (itemCode in('wd','txzt','workStatus')) order by time desc limit 20 offset 0 name: t_monitor_0000000003_4_6_1 +---------------------+------------+-----------+ | time | itemCode | itemValue | +---------------------+------------+-----------+ | 1755565790901288300 | workStatus | 2 | | 1755565773014009600 | wd | 27.0 | | 1755565766099936900 | wd | 26.0 | +---------------------+------------+-----------+ 3 columns, 3 rows in set > select * from t_monitor_0000000003_4_6_1 where time >= 1755565766099936900 and time <= 1755565790901288300 and (itemCode in('workStatus','txzt','wd')) order by time desc limit 20 offset 0 name: t_monitor_0000000003_4_6_1 +---------------------+------------+-----------+ | time | itemCode | itemValue | +---------------------+------------+-----------+ | 1755565790901288300 | workStatus | 2 | | 1755565773014009600 | wd | 27.0 | | 1755565766099936900 | wd | 26.0 | +---------------------+------------+-----------+ 3 columns, 3 rows in set >
Activity
TDroyal commentedon Aug 19, 2025
可以提供更详细的信息吗?比如openGemini的版本,是单机还是集群?或许你可以参考我的方式看能否解决问题。
我用最新源码编译的openGemini,然后启了一个单机的数据库,按照你的方式进行了建表,然后插入了几条数据,测试没有复现出你所遇到的问题。
852814453 commentedon Nov 17, 2025