Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

查询时 order by 与 limit 同时使用的情况可能提示 Unknown datatype: STRING #14307

Closed
HTHou opened this issue Dec 4, 2024 Discussed in #14173 · 1 comment · Fixed by #14323
Closed

查询时 order by 与 limit 同时使用的情况可能提示 Unknown datatype: STRING #14307

HTHou opened this issue Dec 4, 2024 Discussed in #14173 · 1 comment · Fixed by #14323

Comments

@HTHou
Copy link
Contributor

HTHou commented Dec 4, 2024

Discussed in #14173

Originally posted by ptma November 22, 2024
IoTDB 版本: 1.3.3
操作系统:WIndows 11
运行环境:WSL 内的 Docker

复现步骤

create database root.test;

create aligned timeseries root.test.dev (name STRING  encoding=PLAIN compressor=LZ4, enum STRING encoding=DICTIONARY compressor=LZ4, ts INT64 encoding=TS_2DIFF compressor=LZ4, context TEXT encoding=PLAIN compressor=LZ4);

insert into root.test.dev(timestamp, name, enum, ts, context) aligned values(1732186175000, 'n1', 'e1', 1732186175000, null),(1732186175001, 'n2', 'e2', 1732186175001, null),(1732186175002, 'n3', 'e3', 1732186175002, null),(1732186175003, 'n4', 'e4', 1732186175003, 'empty context');

select * from root.test.dev order by ts desc limit 1 offset 0 align by device;

以上SQL均通过 /rest/v2 相应接口执行。

执行最后的查询语句时, 返回结果是:

{
    "code": 301,
    "message": "Unsupported dataType: Unknown datatype: STRING"
}

去除 order by 或 limit offset 后查询结果均符合预期。

Copy link

github-actions bot commented Dec 4, 2024

Hi, this is your first issue in IoTDB project. Thanks for your report. Welcome to join the community!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant