apache / apache/iotdb-client-csharp

ALIGN BY DEVICE 查询结果错误

Open
#3 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
24
Forks
6
PR merge metrics
No merged PRs in 30d

Description

版本: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)

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.