UnicornLee opened a new issue, #18079: URL: https://github.com/apache/doris/issues/18079
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Description 1. 使用客户端查询Doris数据库，SQL语句报错，有些提示信息很不详细，排查问题很不方便。 2. 比如以下这种错误提示： `[2023-03-24 09:52:37] [HY000][1105] IllegalStateException, msg: java.lang.IllegalStateException: null` 3. 希望提示信息能尽可能详细一些，大概哪里出现了问题，便于排查定位问题。 ### Use case 1. 建表SQL ```sql CREATE TABLE `cdsy_secucode` ( `EID` decimalv3(18, 0) NOT NULL, `ESEQID` decimalv3(29, 0) NOT NULL, `EITIME` datetimev2 NOT NULL, `EUTIME` datetimev2 NOT NULL, `EGETTIME` datetimev2 NOT NULL, `EISDEL` char(1) DEFAULT '0', `USESTATE` char(2) DEFAULT NULL, `LISTDATE` datetimev2 DEFAULT NULL, `ENDDATE` datetimev2 DEFAULT NULL, `LISTSTATE` varchar(72) DEFAULT NULL, `CODETYPE` varchar(72) DEFAULT NULL, `SECURITYCODE` varchar(480) DEFAULT NULL, `CURRENCY` varchar(480) DEFAULT NULL, `SECINNERCODE` varchar(600) DEFAULT NULL, `SECURITYTYPE` varchar(1200) DEFAULT NULL, `COMPANYCODE` varchar(1200) DEFAULT NULL, `TRADEMARKETCODE` varchar(1200) DEFAULT NULL, `SECURITYTYPECODE` varchar(1200) DEFAULT NULL, `TRADEMARKET` varchar(1200) DEFAULT NULL, `SPELL` varchar(2400) DEFAULT NULL, `SECURITYSNAME` varchar(2400) DEFAULT NULL, `SECURITYNAME` varchar(4800) DEFAULT NULL, `ESOURCEMEMO` varchar(300) DEFAULT NULL, `EXPAND_NAME_ABBR` varchar(1200) DEFAULT NULL, `PREDICT_LTD` datetimev2 DEFAULT NULL, `EXPAND_NAME_PINYIN` varchar(300) DEFAULT NULL ) ENGINE = OLAP UNIQUE KEY(`EID`) DISTRIBUTED BY HASH(`EID`) BUCKETS AUTO PROPERTIES ( "replication_num" = "3", "light_schema_change" = "true" ); CREATE TABLE `index_ba_sample` ( `EID` decimalv3(18, 0) NOT NULL, `ESEQID` decimalv3(29, 0) NOT NULL, `EITIME` datetimev2 NOT NULL, `EUTIME` datetimev2 NOT NULL, `EGETTIME` datetimev2 NOT NULL, `EISDEL` char(1) DEFAULT '0', `OPDATE` datetimev2 DEFAULT NULL, `TYPE` varchar(120) DEFAULT NULL, `SECURITYCODE` varchar(240) DEFAULT NULL, `EMSECURITYCODE` varchar(240) DEFAULT NULL, `EMSECINNERCODE` varchar(300) DEFAULT NULL, `SECINNERCODE` varchar(300) DEFAULT NULL, `ESOURCEMEMO` varchar(300) DEFAULT NULL, `TRADEMARKETCODE` varchar(600) DEFAULT NULL, `EMSECURITYNAME` varchar(600) DEFAULT NULL ) ENGINE = OLAP UNIQUE KEY(`EID`) DISTRIBUTED BY HASH(`EID`) BUCKETS AUTO PROPERTIES ( "replication_num" = "3", "light_schema_change" = "true" ); ``` 2. 报错SQL ```sql SELECT emsecuritycode, any_value(emsecurityname), any_value(t1.TRADEMARKETCODE) as trademarketcode FROM cdsy_secucode t1 LEFT JOIN index_ba_sample t ON t.EMSECURITYCODE = t1.SECURITYCODE AND t.eisdel = '0' AND t.type = '1' -- 纳入 AND NOT EXISTS( SELECT 1 FROM index_ba_sample s WHERE s.secinnercode = t.secinnercode AND s.emsecuritycode = t.emsecuritycode AND s.type = '0' -- 剔除 AND s.opdate > t.opdate AND s.eisdel = '0' ) AND (t.trademarketcode LIKE '069001001%' OR t.trademarketcode LIKE '069001002%') WHERE t1.SECURITYCODE = '601668' AND (t1.TRADEMARKETCODE = '069001002002' OR t.secinnercode IN ('1000157500', '1000158881')) GROUP BY t.emsecuritycode; ``` ### Related issues _No response_ ### Are you willing to submit PR? - [X] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
