dutyu opened a new pull request, #28067:
URL: https://github.com/apache/doris/pull/28067
## Proposed changes
Error log:
```java
2023-12-06 14:05:12,261 ERROR (mysql-nio-pool-28|3049)
[View.getQueryStmt():129] unexpected exception
org.apache.doris.common.UserException: errCode = 2, detailMessage = Failed
to parse view-definition statement of view: view_bjxe_xd_draw_online_inout,
stmt is SELECT
`aa`.`appl_no`, `aa`.`reqtype`, `aa`.`msg`, `aa`.`result`,
default.arraytomapnew(get_json_object(`aa`.`result`, '$.resultList'),
'item,val') as `result_map`,
`aa`.`version`, substr(trim(`aa`.`date_updated`), 1, 19) as `date_updated`,
`aa`.`pday`
FROM (
SELECT
SPLIT(`kafka_bjxe_xd_draw_online`.`message`, '\t')[0] as `appl_no`,
coalesce(SPLIT(`kafka_bjxe_xd_draw_online`.`message`, '\t')[1], '') as
`reqtype`,
coalesce(SPLIT(`kafka_bjxe_xd_draw_online`.`message`, '\t')[2], '') as `msg`,
coalesce(SPLIT(`kafka_bjxe_xd_draw_online`.`message`, '\t')[3], '') as
`result`,
coalesce(SPLIT(`kafka_bjxe_xd_draw_online`.`message`, '\t')[4], '') as
`version`,
coalesce(SPLIT(`kafka_bjxe_xd_draw_online`.`message`, '\t')[5], '') as
`date_updated`,
`kafka_bjxe_xd_draw_online`.`pday`
FROM
`ods`.`kafka_bjxe_xd_draw_online`
WHERE
`kafka_bjxe_xd_draw_online`.`pday`=CURRENT_DATE and
`kafka_bjxe_xd_draw_online`.`log_type`='inout'
UNION ALL
SELECT
`dwd_credit_bjxe_xd_credit_online_inout_pdi`.`appl_no`,
`dwd_credit_bjxe_xd_credit_online_inout_pdi`.`reqtype`,
`dwd_credit_bjxe_xd_credit_online_inout_pdi`.`msg`,
`dwd_credit_bjxe_xd_credit_online_inout_pdi`.`result`,
`dwd_credit_bjxe_xd_credit_online_inout_pdi`.`version`,
`dwd_credit_bjxe_xd_credit_online_inout_pdi`.`date_updated`,
`dwd_credit_bjxe_xd_credit_online_inout_pdi`.`pday`
FROM `credit`.`dwd_credit_bjxe_xd_credit_online_inout_pdi`
WHERE
`dwd_credit_bjxe_xd_credit_online_inout_pdi`.`pday` < CURRENT_DATE
) as `aa`
WHERE `aa`.`reqtype` in ('draw', 'finaldraw', 'firstdraw', 'firstshdraw',
'shdraw', 'yjdraw'), reason is errCode = 2, detailMessage = Syntax error
at org.apache.doris.catalog.View.init(View.java:174)
~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.catalog.View.getQueryStmt(View.java:126)
~[doris-fe.jar:1.2-SNAPSHOT]
at
org.apache.doris.analysis.InlineViewRef.<init>(InlineViewRef.java:110)
~[doris-fe.jar:1.2-SNAPSHOT]
at
org.apache.doris.analysis.Analyzer.resolveTableRef(Analyzer.java:848)
~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.analysis.FromClause.analyze(FromClause.java:132)
~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.analysis.SelectStmt.analyze(SelectStmt.java:505)
~[doris-fe.jar:1.2-SNAPSHOT]
at
org.apache.doris.qe.StmtExecutor.analyzeAndGenerateQueryPlan(StmtExecutor.java:1105)
~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.analyze(StmtExecutor.java:1014)
~[doris-fe.jar:1.2-SNAPSHOT]
at
org.apache.doris.qe.StmtExecutor.executeByLegacy(StmtExecutor.java:699)
~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:468)
~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:441)
~[doris-fe.jar:1.2-SNAPSHOT]
at
org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:358)
~[doris-fe.jar:1.2-SNAPSHOT]
at
org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:511)
~[doris-fe.jar:1.2-SNAPSHOT]
at
org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:762)
~[doris-fe.jar:1.2-SNAPSHOT]
at
org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52)
~[doris-fe.jar:1.2-SNAPSHOT]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
~[?:1.8.0_301]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
~[?:1.8.0_301]
at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_301]
2023-12-06 14:05:12,261 WARN (mysql-nio-pool-28|3049)
[StmtExecutor.analyze():1031] Analyze failed. stmt[7723,
25d427d4383841d4-a873e26b42f6d555]
java.lang.NullPointerException: null
at
org.apache.doris.analysis.InlineViewRef.<init>(InlineViewRef.java:110)
~[doris-fe.jar:1.2-SNAPSHOT]
at
org.apache.doris.analysis.Analyzer.resolveTableRef(Analyzer.java:848)
~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.analysis.FromClause.analyze(FromClause.java:132)
~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.analysis.SelectStmt.analyze(SelectStmt.java:505)
~[doris-fe.jar:1.2-SNAPSHOT]
at
org.apache.doris.qe.StmtExecutor.analyzeAndGenerateQueryPlan(StmtExecutor.java:1105)
~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.analyze(StmtExecutor.java:1014)
~[doris-fe.jar:1.2-SNAPSHOT]
at
org.apache.doris.qe.StmtExecutor.executeByLegacy(StmtExecutor.java:699)
~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:468)
~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:441)
~[doris-fe.jar:1.2-SNAPSHOT]
at
org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:358)
~[doris-fe.jar:1.2-SNAPSHOT]
at
org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:511)
~[doris-fe.jar:1.2-SNAPSHOT]
at
org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:762)
~[doris-fe.jar:1.2-SNAPSHOT]
at
org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52)
~[doris-fe.jar:1.2-SNAPSHOT]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
~[?:1.8.0_301]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
~[?:1.8.0_301]
at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_301]
2023-12-06 14:05:12,261 WARN (mysql-nio-pool-28|3049)
[StmtExecutor.executeByLegacy():808] execute Exception. stmt[7723,
25d427d4383841d4-a873e26b42f6d555]
org.apache.doris.common.AnalysisException: errCode = 2, detailMessage =
Unexpected exception: null
at org.apache.doris.qe.StmtExecutor.analyze(StmtExecutor.java:1032)
~[doris-fe.jar:1.2-SNAPSHOT]
at
org.apache.doris.qe.StmtExecutor.executeByLegacy(StmtExecutor.java:699)
~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:468)
~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:441)
~[doris-fe.jar:1.2-SNAPSHOT]
at
org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:358)
~[doris-fe.jar:1.2-SNAPSHOT]
at
org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:511)
~[doris-fe.jar:1.2-SNAPSHOT]
```
## Further comments
If this is a relatively large or complex change, kick off the discussion at
[d...@doris.apache.org](mailto:d...@doris.apache.org) by explaining why you
chose the solution you did and what alternatives you considered, etc...
--
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: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
