es外表cte查询报错
- Dominant language
- MDX
- Stars
- 133
- Forks
- 464
- Avg merge
- 1d 1h
- Merged PRs (30d)
- 50
Description
### 直接查询
`SELECT yjsj 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_.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_.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
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.