You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@iceberg.apache.org by "AllenWee1106 (via GitHub)" <gi...@apache.org> on 2023/12/06 02:52:23 UTC
[I] Flink SQL encountered an exception while reading the iceberg table [iceberg]
AllenWee1106 opened a new issue, #9228:
URL: https://github.com/apache/iceberg/issues/9228
### Query engine
flink 1.16.2 iceberg 1.3.1
### Question
`flink 1.16.2 iceberg 1.3.1`
`tabenv.executeSql("create catalog jdbc with " +
"('type'='iceberg'," +
"'catalog-impl'='org.apache.iceberg.jdbc.JdbcCatalog'," +
"'io-impl'='org.apache.iceberg.aws.s3.S3FileIO'," +
"'uri'='jdbc:postgresql://***:****/jdbc'," +
"'jdbc.user'='******'," +
"'jdbc.password'='*****'," +
"'warehouse'='s3://warehouse/'," +
"'clients'='5'," +
"'s3.endpoint'='http://***:***'," +
"'s3.access-key-id'='******'," +
"'s3.secret-access-key'='****'," +
"'client.region'='cn-east-1'," +
"'s3.path-style-access'='true'" +
")");`
`Table tableResult = tabenv.sqlQuery(
"select * from jdbc.datalake.ods_vtc_tracking " +
"where datetime >= '2023-11-07' " +
"and datetime <= '2023-11-08'");`
**When executing the above SQL query, the following exception：**
2023-12-06 10:32:45 WARN S3InputStream:237 - Unclosed input stream created by:
org.apache.iceberg.aws.s3.S3InputStream.<init>(S3InputStream.java:74)
org.apache.iceberg.aws.s3.S3InputFile.newStream(S3InputFile.java:85)
org.apache.iceberg.orc.FileIOFSUtil$InputFileSystem.open(FileIOFSUtil.java:125)
org.apache.iceberg.shaded.org.apache.orc.impl.ReaderImpl.extractFileTail(ReaderImpl.java:779)
org.apache.iceberg.shaded.org.apache.orc.impl.ReaderImpl.<init>(ReaderImpl.java:567)
org.apache.iceberg.shaded.org.apache.orc.OrcFile.createReader(OrcFile.java:385)
org.apache.iceberg.orc.ORC.newFileReader(ORC.java:780)
org.apache.iceberg.orc.OrcIterable.iterator(OrcIterable.java:83)
org.apache.iceberg.io.CloseableIterable$ConcatCloseableIterable$ConcatCloseableIterator.hasNext(CloseableIterable.java:257)
org.apache.iceberg.io.CloseableIterable$7$1.hasNext(CloseableIterable.java:197)
org.apache.iceberg.io.CloseableIterable$7$1.hasNext(CloseableIterable.java:197)
org.apache.iceberg.relocated.com.google.common.collect.Iterators.addAll(Iterators.java:366)
org.apache.iceberg.relocated.com.google.common.collect.Iterables.addAll(Iterables.java:337)
org.apache.iceberg.deletes.Deletes.toEqualitySet(Deletes.java:116)
org.apache.iceberg.data.DeleteFilter.applyEqDeletes(DeleteFilter.java:192)
org.apache.iceberg.data.DeleteFilter.applyEqDeletes(DeleteFilter.java:211)
org.apache.iceberg.data.DeleteFilter.filter(DeleteFilter.java:154)
org.apache.iceberg.flink.source.RowDataFileScanTaskReader.open(RowDataFileScanTaskReader.java:97)
org.apache.iceberg.flink.source.DataIterator.openTaskIterator(DataIterator.java:139)
org.apache.iceberg.flink.source.DataIterator.updateCurrentIterator(DataIterator.java:129)
org.apache.iceberg.flink.source.DataIterator.hasNext(DataIterator.java:109)
org.apache.iceberg.flink.source.FlinkInputFormat.reachedEnd(FlinkInputFormat.java:125)
org.apache.flink.streaming.api.functions.source.InputFormatSourceFunction.run(InputFormatSourceFunction.java:89)
org.apache.flink.streaming.api.operators.StreamSource.run(StreamSource.java:110)
org.apache.flink.streaming.api.operators.StreamSource.run(StreamSource.java:67)
org.apache.flink.streaming.runtime.tasks.SourceStreamTask$LegacySourceFunctionThread.run(SourceStreamTask.java:333)
--
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: issues-unsubscribe@iceberg.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
Re: [I] Flink SQL encountered an exception while reading the iceberg table [iceberg]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #9228:
URL: https://github.com/apache/iceberg/issues/9228#issuecomment-2597166187
This issue has been closed because it has not received any activity in the last 14 days since being marked as 'stale'
--
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: issues-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
Re: [I] Flink SQL encountered an exception while reading the iceberg table [iceberg]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #9228: Flink SQL encountered an exception while reading the iceberg table
URL: https://github.com/apache/iceberg/issues/9228
--
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: issues-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org