apache / apache/iotdb-client-csharp

ALIGN BY DEVICE 查询结果错误

Abierto
#3 2 comentarios 0 reacciones 0 asignados Ver en GitHub
Lenguaje dominante
C#
Estrellas
24
Forks
6
Métricas de merge de PR
Sin PR fusionados en 30 d

Descripción

版本:Apache.IoTDB.Data 1.0.0.3

查询这样的语句,第2行获取不到数据。
sql:select FIRST_VALUE(ctwingCmdBody) as ctwingCmdBody ,MIN_TIME(ctwingCmdBody) as ts from root.beijingheat.commandCreate.IOT16810103.T10495873.P16810103.* where Time >= 2012-05-22T21:51:48.929 and Time < 2023-10-19T13:51:48.929 ALIGN BY DEVICE

cli的执行有结果:

![1697696411896](https://github.com/apache/iotdb-client-csharp/assets/10105646/aaaf2ee6-c525-451a-b780-d3223b3730a7)

测试代码如下:

using System.Data;
using Apache.IoTDB.Data;
using Microsoft.Extensions.Logging;

namespace ConsoleApp2
{
internal class Program
{
static void Main(string[] args)
{
string sql = "select FIRST_VALUE(ctwingCmdBody) as ctwingCmdBody ,MIN_TIME(ctwingCmdBody) as ts from root.beijingheat.commandCreate.IOT16810103.T10495873.P16810103.* where Time >= 2012-05-22T21:51:48.929 and Time < 2023-10-19T13:51:48.929 ALIGN BY DEVICE ";

IoTDBConnection _ioTDB= new IoTDBConnection("DataSource=192.168.1.101;Port=6667;Username=root;Password=root;Compression=false"); ;

Apache.IoTDB.SessionPool _session= _ioTDB.SessionPool;

Task.Run(async () =>
{
_session.Open();

var query =await _session.ExecuteQueryStatementAsync(sql);
while (query.HasNext())
{
var next = query.Next();
var values = next.Values;
var time = next.GetDateTime();
foreach (var item in values)
{
Console.WriteLine($"{item}");
}

}

});
Console.ReadLine();
}
}
}

执行结果如下:
![image](https://github.com/apache/iotdb-client-csharp/assets/10105646/c080d514-ff55-47e5-9473-99e2bd312e6d)

Guía de contribución

No hay ninguna guía de contribución indexada para este repositorio

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.