[jira] [Created] (IOTDB-5890) The exception messages for order by queries need to be optimised

["xiaozhihong (Jira)" <ji...@apache.org>]

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)