Hello friends, I’ve a error In last version of Dremio 22.0 when try query a table, this table is iceberg table from oracle use ‘cast’, “create table xx as select * from oracle_table”, an error is reported only “select * from table”,but query the wrong column individually is normal.
DATA_READ ERROR: Failed to decode column aka063::varchar
Total records decoded and sent upstream 0
PLAIN encoded pages read 0
DICTIONARY encoded pages read 0
Total records decoded in current page and sent upstream after passing filter 0
File path /xxx/xxx/xxx/xxx/xxx/1d2092aa-9c12-b768-426c-21036ab2b700/0_0_3.parquet
Rowgroup index 0
SqlOperatorImpl TABLE_FUNCTION
Location 1:0:2
Fragment 1:0
[Error Id: 9f08c8ab-0f21-4675-901b-7167a724d68a on c70:0]
(java.io.IOException) can not read class org.apache.parquet.format.PageHeader: java.io.IOException: software.amazon.awssdk.core.exception.SdkClientException: Unable to execute HTTP request: The target server failed to respond
org.apache.parquet.format.Util.read():225
org.apache.parquet.format.Util.readPageHeader():78
com.dremio.parquet.pages.IncrementalPageReaderIterator.next():79
com.dremio.parquet.pages.MemoizingPageIterator.next():32
com.dremio.parquet.pages.PageIterator.nextPage():108
com.dremio.parquet.pages.PageIterator.hasNextPage():63
com.dremio.parquet.reader.column.generics.VarCharSimpleReader.evalNextBatch():143
com.dremio.parquet.reader.SimpleRowGroupReader.eval():43
com.dremio.extra.exec.store.dfs.parquet.ParquetVectorizedReader.next():786
com.dremio.exec.store.parquet.UnifiedParquetReader.readEnsuringReadersReturnSameNumberOfRecords():383
com.dremio.exec.store.parquet.UnifiedParquetReader.next():358
com.dremio.exec.store.parquet.TransactionalTableParquetReader.next():233
com.dremio.exec.store.parquet.ParquetCoercionReader.next():125
com.dremio.exec.store.parquet.ScanTableFunction.processRow():186
com.dremio.sabot.op.tablefunction.TableFunctionOperator.outputData():103
com.dremio.sabot.driver.SmartOp$SmartSingleInput.outputData():193
com.dremio.sabot.driver.StraightPipe.pump():56
com.dremio.sabot.driver.Pipeline.doPump():111
com.dremio.sabot.driver.Pipeline.pumpOnce():101
com.dremio.sabot.exec.fragment.FragmentExecutor$DoAsPumper.run():418
com.dremio.sabot.exec.fragment.FragmentExecutor.run():355
com.dremio.sabot.exec.fragment.FragmentExecutor.access$1600():97
com.dremio.sabot.exec.fragment.FragmentExecutor$AsyncTaskImpl.run():820
com.dremio.sabot.task.AsyncTaskWrapper.run():120
com.dremio.sabot.task.slicing.SlicingThread.mainExecutionLoop():247
com.dremio.sabot.task.slicing.SlicingThread.run():171
Caused By (shaded.parquet.org.apache.thrift.transport.TTransportException) java.io.IOException: software.amazon.awssdk.core.exception.SdkClientException: Unable to execute HTTP request: The target server failed to respond
shaded.parquet.org.apache.thrift.transport.TIOStreamTransport.read():129
shaded.parquet.org.apache.thrift.transport.TTransport.readAll():86
shaded.parquet.org.apache.thrift.protocol.TCompactProtocol.readByte():634
shaded.parquet.org.apache.thrift.protocol.TCompactProtocol.readFieldBegin():539
org.apache.parquet.format.InterningProtocol.readFieldBegin():155
org.apache.parquet.format.PageHeader$PageHeaderStandardScheme.read():1058
org.apache.parquet.format.PageHeader$PageHeaderStandardScheme.read():1051
org.apache.parquet.format.PageHeader.read():915
org.apache.parquet.format.Util.read():222
org.apache.parquet.format.Util.readPageHeader():78
com.dremio.parquet.pages.IncrementalPageReaderIterator.next():79
com.dremio.parquet.pages.MemoizingPageIterator.next():32
com.dremio.parquet.pages.PageIterator.nextPage():108
com.dremio.parquet.pages.PageIterator.hasNextPage():63
com.dremio.parquet.reader.column.generics.VarCharSimpleReader.evalNextBatch():143
com.dremio.parquet.reader.SimpleRowGroupReader.eval():43
com.dremio.extra.exec.store.dfs.parquet.ParquetVectorizedReader.next():786
com.dremio.exec.store.parquet.UnifiedParquetReader.readEnsuringReadersReturnSameNumberOfRecords():383
com.dremio.exec.store.parquet.UnifiedParquetReader.next():358
com.dremio.exec.store.parquet.TransactionalTableParquetReader.next():233
com.dremio.exec.store.parquet.ParquetCoercionReader.next():125
com.dremio.exec.store.parquet.ScanTableFunction.processRow():186
com.dremio.sabot.op.tablefunction.TableFunctionOperator.outputData():103
com.dremio.sabot.driver.SmartOp$SmartSingleInput.outputData():193
com.dremio.sabot.driver.StraightPipe.pump():56
com.dremio.sabot.driver.Pipeline.doPump():111
com.dremio.sabot.driver.Pipeline.pumpOnce():101
com.dremio.sabot.exec.fragment.FragmentExecutor$DoAsPumper.run():418
com.dremio.sabot.exec.fragment.FragmentExecutor.run():355
com.dremio.sabot.exec.fragment.FragmentExecutor.access$1600():97
com.dremio.sabot.exec.fragment.FragmentExecutor$AsyncTaskImpl.run():820
com.dremio.sabot.task.AsyncTaskWrapper.run():120
com.dremio.sabot.task.slicing.SlicingThread.mainExecutionLoop():247
com.dremio.sabot.task.slicing.SlicingThread.run():171
Caused By (java.io.IOException) software.amazon.awssdk.core.exception.SdkClientException: Unable to execute HTTP request: The target server failed to respond
com.dremio.parquet.pages.async.SlidingWindowReader.readFully():222
com.dremio.exec.store.parquet.BulkInputStream$1.read():181
java.io.InputStream.read():170
shaded.parquet.org.apache.thrift.transport.TIOStreamTransport.read():127
shaded.parquet.org.apache.thrift.transport.TTransport.readAll():86
shaded.parquet.org.apache.thrift.protocol.TCompactProtocol.readByte():634
shaded.parquet.org.apache.thrift.protocol.TCompactProtocol.readFieldBegin():539
org.apache.parquet.format.InterningProtocol.readFieldBegin():155
org.apache.parquet.format.PageHeader$PageHeaderStandardScheme.read():1058
org.apache.parquet.format.PageHeader$PageHeaderStandardScheme.read():1051
org.apache.parquet.format.PageHeader.read():915
org.apache.parquet.format.Util.read():222
org.apache.parquet.format.Util.readPageHeader():78
com.dremio.parquet.pages.IncrementalPageReaderIterator.next():79
com.dremio.parquet.pages.MemoizingPageIterator.next():32
com.dremio.parquet.pages.PageIterator.nextPage():108
com.dremio.parquet.pages.PageIterator.hasNextPage():63
com.dremio.parquet.reader.column.generics.VarCharSimpleReader.evalNextBatch():143
com.dremio.parquet.reader.SimpleRowGroupReader.eval():43
com.dremio.extra.exec.store.dfs.parquet.ParquetVectorizedReader.next():786
com.dremio.exec.store.parquet.UnifiedParquetReader.readEnsuringReadersReturnSameNumberOfRecords():383
com.dremio.exec.store.parquet.UnifiedParquetReader.next():358
com.dremio.exec.store.parquet.TransactionalTableParquetReader.next():233
com.dremio.exec.store.parquet.ParquetCoercionReader.next():125
com.dremio.exec.store.parquet.ScanTableFunction.processRow():186
com.dremio.sabot.op.tablefunction.TableFunctionOperator.outputData():103
com.dremio.sabot.driver.SmartOp$SmartSingleInput.outputData():193
com.dremio.sabot.driver.StraightPipe.pump():56
com.dremio.sabot.driver.Pipeline.doPump():111
com.dremio.sabot.driver.Pipeline.pumpOnce():101
com.dremio.sabot.exec.fragment.FragmentExecutor$DoAsPumper.run():418
com.dremio.sabot.exec.fragment.FragmentExecutor.run():355
com.dremio.sabot.exec.fragment.FragmentExecutor.access$1600():97
com.dremio.sabot.exec.fragment.FragmentExecutor$AsyncTaskImpl.run():820
com.dremio.sabot.task.AsyncTaskWrapper.run():120
com.dremio.sabot.task.slicing.SlicingThread.mainExecutionLoop():247
com.dremio.sabot.task.slicing.SlicingThread.run():171
Caused By (software.amazon.awssdk.core.exception.SdkClientException) Unable to execute HTTP request: The target server failed to respond
software.amazon.awssdk.core.exception.SdkClientException$BuilderImpl.build():98
software.amazon.awssdk.core.exception.SdkClientException.create():43
software.amazon.awssdk.core.internal.http.pipeline.stages.utils.RetryableStageHelper.setLastException():198
software.amazon.awssdk.core.internal.http.pipeline.stages.RetryableStage.execute():66
software.amazon.awssdk.core.internal.http.pipeline.stages.RetryableStage.execute():34
software.amazon.awssdk.core.internal.http.pipeline.RequestPipelineBuilder$ComposingRequestPipelineStage.execute():206
software.amazon.awssdk.core.internal.http.StreamManagingStage.execute():56
software.amazon.awssdk.core.internal.http.StreamManagingStage.execute():36
software.amazon.awssdk.core.internal.http.pipeline.stages.ApiCallTimeoutTrackingStage.executeWithTimer():80
software.amazon.awssdk.core.internal.http.pipeline.stages.ApiCallTimeoutTrackingStage.execute():60
software.amazon.awssdk.core.internal.http.pipeline.stages.ApiCallTimeoutTrackingStage.execute():42
software.amazon.awssdk.core.internal.http.pipeline.stages.ApiCallMetricCollectionStage.execute():48
software.amazon.awssdk.core.internal.http.pipeline.stages.ApiCallMetricCollectionStage.execute():31
software.amazon.awssdk.core.internal.http.pipeline.RequestPipelineBuilder$ComposingRequestPipelineStage.execute():206
software.amazon.awssdk.core.internal.http.pipeline.RequestPipelineBuilder$ComposingRequestPipelineStage.execute():206
software.amazon.awssdk.core.internal.http.pipeline.stages.ExecutionFailureExceptionReportingStage.execute():37
software.amazon.awssdk.core.internal.http.pipeline.stages.ExecutionFailureExceptionReportingStage.execute():26
software.amazon.awssdk.core.internal.http.AmazonSyncHttpClient$RequestExecutionBuilderImpl.execute():193
software.amazon.awssdk.core.internal.handler.BaseSyncClientHandler.invoke():135
software.amazon.awssdk.core.internal.handler.BaseSyncClientHandler.doExecute():161
software.amazon.awssdk.core.internal.handler.BaseSyncClientHandler.lambda$execute$0():84
software.amazon.awssdk.core.internal.handler.BaseSyncClientHandler.measureApiCallSuccess():169
software.amazon.awssdk.core.internal.handler.BaseSyncClientHandler.execute():62
software.amazon.awssdk.core.client.handler.SdkSyncClientHandler.execute():52
software.amazon.awssdk.awscore.client.handler.AwsSyncClientHandler.execute():62
software.amazon.awssdk.services.s3.DefaultS3Client.getObject():4371
software.amazon.awssdk.services.s3.S3Client.getObjectAsBytes():8123
com.dremio.plugins.s3.store.S3AsyncByteReaderUsingSyncClient$S3SyncReadObject.lambda$run$0():165
com.dremio.plugins.s3.store.S3AsyncByteReaderUsingSyncClient$RetryableInvoker.invoke():106
com.dremio.plugins.s3.store.S3AsyncByteReaderUsingSyncClient$S3SyncReadObject.run():165
java.util.concurrent.CompletableFuture$AsyncRun.run():1640
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():750
Caused By (org.apache.http.NoHttpResponseException) The target server failed to respond
org.apache.http.impl.conn.DefaultHttpResponseParser.parseHead():141
org.apache.http.impl.conn.DefaultHttpResponseParser.parseHead():56
org.apache.http.impl.io.AbstractMessageParser.parse():259
org.apache.http.impl.DefaultBHttpClientConnection.receiveResponseHeader():163
org.apache.http.impl.conn.CPoolProxy.receiveResponseHeader():157
org.apache.http.protocol.HttpRequestExecutor.doReceiveResponse():273
org.apache.http.protocol.HttpRequestExecutor.execute():125
org.apache.http.impl.execchain.MainClientExec.execute():272
org.apache.http.impl.execchain.ProtocolExec.execute():186
org.apache.http.impl.client.InternalHttpClient.doExecute():185
org.apache.http.impl.client.CloseableHttpClient.execute():83
org.apache.http.impl.client.CloseableHttpClient.execute():56
software.amazon.awssdk.http.apache.internal.impl.ApacheSdkHttpClient.execute():72
software.amazon.awssdk.http.apache.ApacheHttpClient.execute():253
software.amazon.awssdk.http.apache.ApacheHttpClient.access$500():106
software.amazon.awssdk.http.apache.ApacheHttpClient$1.call():232
software.amazon.awssdk.http.apache.ApacheHttpClient$1.call():229
software.amazon.awssdk.core.internal.util.MetricUtils.measureDurationUnsafe():64
software.amazon.awssdk.core.internal.http.pipeline.stages.MakeHttpRequestStage.executeHttpRequest():76
software.amazon.awssdk.core.internal.http.pipeline.stages.MakeHttpRequestStage.execute():55
software.amazon.awssdk.core.internal.http.pipeline.stages.MakeHttpRequestStage.execute():39
software.amazon.awssdk.core.internal.http.pipeline.RequestPipelineBuilder$ComposingRequestPipelineStage.execute():206
software.amazon.awssdk.core.internal.http.pipeline.RequestPipelineBuilder$ComposingRequestPipelineStage.execute():206
software.amazon.awssdk.core.internal.http.pipeline.RequestPipelineBuilder$ComposingRequestPipelineStage.execute():206
software.amazon.awssdk.core.internal.http.pipeline.RequestPipelineBuilder$ComposingRequestPipelineStage.execute():206
software.amazon.awssdk.core.internal.http.pipeline.stages.ApiCallAttemptTimeoutTrackingStage.execute():73
software.amazon.awssdk.core.internal.http.pipeline.stages.ApiCallAttemptTimeoutTrackingStage.execute():42
software.amazon.awssdk.core.internal.http.pipeline.stages.TimeoutExceptionHandlingStage.execute():78
software.amazon.awssdk.core.internal.http.pipeline.stages.TimeoutExceptionHandlingStage.execute():40
software.amazon.awssdk.core.internal.http.pipeline.stages.ApiCallAttemptMetricCollectionStage.execute():50
software.amazon.awssdk.core.internal.http.pipeline.stages.ApiCallAttemptMetricCollectionStage.execute():36
software.amazon.awssdk.core.internal.http.pipeline.stages.RetryableStage.execute():64
software.amazon.awssdk.core.internal.http.pipeline.stages.RetryableStage.execute():34
software.amazon.awssdk.core.internal.http.pipeline.RequestPipelineBuilder$ComposingRequestPipelineStage.execute():206
software.amazon.awssdk.core.internal.http.StreamManagingStage.execute():56
software.amazon.awssdk.core.internal.http.StreamManagingStage.execute():36
software.amazon.awssdk.core.internal.http.pipeline.stages.ApiCallTimeoutTrackingStage.executeWithTimer():80
software.amazon.awssdk.core.internal.http.pipeline.stages.ApiCallTimeoutTrackingStage.execute():60
software.amazon.awssdk.core.internal.http.pipeline.stages.ApiCallTimeoutTrackingStage.execute():42
software.amazon.awssdk.core.internal.http.pipeline.stages.ApiCallMetricCollectionStage.execute():48
software.amazon.awssdk.core.internal.http.pipeline.stages.ApiCallMetricCollectionStage.execute():31
software.amazon.awssdk.core.internal.http.pipeline.RequestPipelineBuilder$ComposingRequestPipelineStage.execute():206
software.amazon.awssdk.core.internal.http.pipeline.RequestPipelineBuilder$ComposingRequestPipelineStage.execute():206
software.amazon.awssdk.core.internal.http.pipeline.stages.ExecutionFailureExceptionReportingStage.execute():37
software.amazon.awssdk.core.internal.http.pipeline.stages.ExecutionFailureExceptionReportingStage.execute():26
software.amazon.awssdk.core.internal.http.AmazonSyncHttpClient$RequestExecutionBuilderImpl.execute():193
software.amazon.awssdk.core.internal.handler.BaseSyncClientHandler.invoke():135
software.amazon.awssdk.core.internal.handler.BaseSyncClientHandler.doExecute():161
software.amazon.awssdk.core.internal.handler.BaseSyncClientHandler.lambda$execute$0():84
software.amazon.awssdk.core.internal.handler.BaseSyncClientHandler.measureApiCallSuccess():169
software.amazon.awssdk.core.internal.handler.BaseSyncClientHandler.execute():62
software.amazon.awssdk.core.client.handler.SdkSyncClientHandler.execute():52
software.amazon.awssdk.awscore.client.handler.AwsSyncClientHandler.execute():62
software.amazon.awssdk.services.s3.DefaultS3Client.getObject():4371
software.amazon.awssdk.services.s3.S3Client.getObjectAsBytes():8123
com.dremio.plugins.s3.store.S3AsyncByteReaderUsingSyncClient$S3SyncReadObject.lambda$run$0():165
com.dremio.plugins.s3.store.S3AsyncByteReaderUsingSyncClient$RetryableInvoker.invoke():106
com.dremio.plugins.s3.store.S3AsyncByteReaderUsingSyncClient$S3SyncReadObject.run():165
java.util.concurrent.CompletableFuture$AsyncRun.run():1640
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():750