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)
