BlackYooi opened a new issue, #3828:
URL: https://github.com/apache/doris-website/issues/3828
### 直接查询
`SELECT fssj FROM es_.default_db.theme_jzxxb LIMIT 10;`
可以正常得到结果 比如：2024-11-04 18:46:40
### 执行cte查询报错
WITH node_xxx AS (
SELECT
yjsj
FROM es_.default_db.theme_jzxxb
)
SELECT * FROM node_xxx LIMIT 10;
### 错误日志：
org.jkiss.dbeaver.model.sql.DBSQLException: SQL 错误 [1105] [HY000]: errCode =
2, detailMessage = Input slot(s) not in child's output: yjsj#18 in plan:
LogicalProject[63] ( distinct=false, projects=[yjsj#18 AS `yjsj`#9] )
child output is: [address#19, content#20, fssj#21, groupName#22, mtype#23,
rawContent#24, tzzhm#25, tzzlx#26, yjsj#27]
plan tree:
LogicalProject[63] ( distinct=false, projects=[yjsj#18 AS `yjsj`#9] )
+--LogicalEsScan ( qualified=es_10_18_20_131_9200.default_db.theme_jzxxb,
output=[address#19, content#20, fssj#21, groupName#22, mtype#23, rawContent#24,
tzzhm#25, tzzlx#26, yjsj#27] )
at
org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:130)
at
org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:657)
at
org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$2(SQLQueryJob.java:550)
at
org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:189)
at
org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:569)
at
org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:1043)
at
org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:4326)
at
org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:128)
at
org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:189)
at
org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:126)
at
org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:5112)
at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:119)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
Caused by: java.sql.SQLException: errCode = 2, detailMessage = Input slot(s)
not in child's output: yjsj#18 in plan: LogicalProject[63] ( distinct=false,
projects=[yjsj#18 AS `yjsj`#9] )
child output is: [address#19, content#20, fssj#21, groupName#22, mtype#23,
rawContent#24, tzzhm#25, tzzlx#26, yjsj#27]
plan tree:
LogicalProject[63] ( distinct=false, projects=[yjsj#18 AS `yjsj`#9] )
+--LogicalEsScan ( qualified=es_10_18_20_131_9200.default_db.theme_jzxxb,
output=[address#19, content#20, fssj#21, groupName#22, mtype#23, rawContent#24,
tzzhm#25, tzzlx#26, yjsj#27] )
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130)
at
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at
com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:767)
at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:652)
at
org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:344)
at
org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:128)
... 12 more
--
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]
