You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "gb198871 (via GitHub)" <gi...@apache.org> on 2023/06/26 02:46:01 UTC
[GitHub] [doris] gb198871 opened a new issue, #21163: [Bug]SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = Unknown table '_table_valued_function_s3'
gb198871 opened a new issue, #21163:
URL: https://github.com/apache/doris/issues/21163
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
### Version
version 1.2.2
### What's Wrong?
SELECT * FROM s3(
"URI" = "http://xxxx:xxx/shuibaseb/test/test/test/dinggoudingdan/1405878438250816.parquet",
"ACCESS_KEY"= "xxxxxxxxx",
"SECRET_KEY" = "xxxxxxxxxxxxxxxx",
"Format" = "parquet",
"use_path_style"="true");
result is OK;
but
CREATE VIEW v2 AS
SELECT * FROM s3(
"URI" = "http://xxxx:xxx/shuibaseb/test/test/test/dinggoudingdan/1405878438250816.parquet",
"ACCESS_KEY"= "xxxxxxxxx",
"SECRET_KEY" = "xxxxxxxxxxxxxxxx",
"Format" = "parquet",
"use_path_style"="true");
SELECT * FROM dinggoudingdan2 limit 10;
org.jkiss.dbeaver.model.sql.DBSQLException: SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = Unknown table '_table_valued_function_s3'
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:133)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:575)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$1(SQLQueryJob.java:484)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:172)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:491)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:878)
at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:3526)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:118)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:172)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:116)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:4868)
at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
Caused by: java.sql.SQLException: errCode = 2, detailMessage = Unknown table '_table_valued_function_s3'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)
at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:329)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.lambda$0(JDBCStatementImpl.java:131)
at org.jkiss.dbeaver.utils.SecurityManagerUtils.wrapDriverActions(SecurityManagerUtils.java:94)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:131)
... 12 more
### What You Expected?
do well
### How to Reproduce?
_No response_
### Anything Else?
_No response_
### Are you willing to submit PR?
- [ ] 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: commits-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] stalary commented on issue #21163: [Bug]SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = Unknown table '_table_valued_function_s3'
Posted by "stalary (via GitHub)" <gi...@apache.org>.
stalary commented on issue #21163:
URL: https://github.com/apache/doris/issues/21163#issuecomment-1611447894
I can't find dinggoudingdan2 in your info
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] stalary closed issue #21163: [Bug]SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = Unknown table '_table_valued_function_s3'
Posted by "stalary (via GitHub)" <gi...@apache.org>.
stalary closed issue #21163: [Bug]SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = Unknown table '_table_valued_function_s3'
URL: https://github.com/apache/doris/issues/21163
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org