- Notifications
You must be signed in to change notification settings - Fork 4
Open
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的执行有结果:
测试代码如下:
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(); } } }
Metadata
Metadata
Assignees
Labels
No labels

