You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "xiaozhihong (Jira)" <ji...@apache.org> on 2023/05/17 07:04:00 UTC
[jira] [Created] (IOTDB-5890) The exception messages for order by queries need to be optimised
xiaozhihong created IOTDB-5890:
----------------------------------
Summary: The exception messages for order by queries need to be optimised
Key: IOTDB-5890
URL: https://issues.apache.org/jira/browse/IOTDB-5890
Project: Apache IoTDB
Issue Type: Bug
Components: Core/Query
Affects Versions: master branch
Reporter: xiaozhihong
Assignee: yang caiyin
Branch : MasterĀ
commit ab43262e3974574334ca7ff131e8d11e7f5da69f
Question1 : When executing aggregation and raw order by queries, the msg returned need to be optimised and the current message is unclear.
{code:java}
IoTDB> select s3,s4 from root.sg.d1 order by mode(s1) desc;
Msg: 301: ComparatorChains must contain at least one Comparator
IoTDB> select sum(s1),max_value(s1) from root.sg.d1 order by s6 desc align by device;
Msg: 701: Raw data and aggregation hybrid query is not supported.
{code}
Question2 : The prompt message has an internal error message when executing last query.
{code:java}
IoTDB> select last * from root.sg.d1 order by s1 desc;
Msg: 305: [INTERNAL_SERVER_ERROR(305)] Exception occurred: "select last * from root.sg.d1 order by s1 desc". executeStatement failed. Last queries only support sorting by timeseries now.
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)