English 中文(简体)
• 如何将时间(战线作为正常栏目)分类,添加过滤装置,并将数据实地值结果归帕帕帕奇·艾洛德布?
原标题:How to group the time (treat as normal columns), add device filtering condtions, and sum the data field value results in Apache IoTDB?

任何人都知道如何设计时间序列的道路,以及如何在阿帕帕奇·伊洛德布撰写这种格言? 我想根据具体时间价值范围将<代码> 日一栏分类,并添加一些装置过滤条件,然后将特定领域的相应数据价值汇总起来。 在我的前一个数据库中(该数据库以斜体为基础),这一片段的一个例子是:select time,sum(power) as power from def.grid_h where Project_id in (4, 7) and time >= 2024-02-18 20:00 and time < 2024-02-18 20:10:00 and time <= 现在() partition by time。 我很想知道,我如何在IoTDB中找到同样的问题,因为我知道IoTDB的图表并非完全一样。

问题回答

现在,帕帕奇·伊洛德布的问候语与卡勒克语相似,但并非完全一样。 目前,实现你想要的问答的唯一途径是使用<条码>电子电网_4.*.power + grid_7.*.power from fundamental.*.*.*。 这样,结果随时间推移而调整,但如果“power field>的时间不一致,结果将无效。 如果目前确实有数据,你需要改变数据。 今后,已经计划实施基于SchoodB标准表模式。





相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签