(iotdb) branch tsbs/iot updated: align with TDengine

[jackietien]

This is an automated email from the ASF dual-hosted git repository.

jackietien pushed a commit to branch tsbs/iot
in repository https://gitbox.apache.org/repos/asf/iotdb.git


The following commit(s) were added to refs/heads/tsbs/iot by this push:
     new 9a973bfbc16 align with TDengine
9a973bfbc16 is described below

commit 9a973bfbc16486086bfe1bf6e17da69ab98dc431
Author: JackieTien97 <jackietie...@gmail.com>
AuthorDate: Sat May 11 18:21:42 2024 +0800

    align with TDengine
---
 .../iotdb/db/protocol/thrift/impl/ClientRPCServiceImpl.java       | 8 ++------
 1 file changed, 2 insertions(+), 6 deletions(-)

diff --git 
a/iotdb-core/datanode/src/main/java/org/apache/iotdb/db/protocol/thrift/impl/ClientRPCServiceImpl.java
 
b/iotdb-core/datanode/src/main/java/org/apache/iotdb/db/protocol/thrift/impl/ClientRPCServiceImpl.java
index f2c40a35835..88593390da5 100644
--- 
a/iotdb-core/datanode/src/main/java/org/apache/iotdb/db/protocol/thrift/impl/ClientRPCServiceImpl.java
+++ 
b/iotdb-core/datanode/src/main/java/org/apache/iotdb/db/protocol/thrift/impl/ClientRPCServiceImpl.java
@@ -349,9 +349,7 @@ public class ClientRPCServiceImpl implements 
IClientRPCServiceWithHandler {
           + FUEL_CONSUMPTION_COLUMN_NAME
           + "), count("
           + FUEL_CONSUMPTION_COLUMN_NAME
-          + ") from root.readings.** where "
-          + VELOCITY_COLUMN_NAME
-          + " > 1 ALIGN BY DEVICE";
+          + ") from root.readings.** ALIGN BY DEVICE";
 
   private static final List<String> AVG_VS_PROJ_FUEL_CONSUMPTION_HEADERS =
       ImmutableList.of(
@@ -382,9 +380,7 @@ public class ClientRPCServiceImpl implements 
IClientRPCServiceWithHandler {
   private static final String AVG_DAILY_DRIVING_DURATION_SQL_TEMPLATE =
       "select avg("
           + VELOCITY_COLUMN_NAME
-          + ") from root.readings.** GROUP BY([%d, %d), 10m) HAVING avg("
-          + VELOCITY_COLUMN_NAME
-          + ") > 1 ALIGN BY DEVICE";
+          + ") from root.readings.** GROUP BY([%d, %d), 10m) ALIGN BY DEVICE";
 
   private static final List<String> AVG_DAILY_DRIVING_DURATION_HEADERS =
       ImmutableList.of(FLEET_COLUMN_NAME, NAME_COLUMN_NAME, 
DRIVER_COLUMN_NAME, "avg_daily_hours");