Re: [I] Cannot query iceberg with 1.20.1 (drill)

[via GitHub]

Maegor commented on issue #2644:
URL: https://github.com/apache/drill/issues/2644#issuecomment-1568401670

   Hi,
   I have problems reading an Apache Iceberg table hosted in S3 (I commented 
this problem on Slack but I share it here too). My **Drill version is 1.21.1** 
(updated recently)
   
   The Storage Plugin configuration is saved as "S3_iceberg", this is the xml:
   
   ```
   {
     "type": "file",
     "connection": "s3a://xxx-data-lake",
     "config": {
       "fs.s3a.secret.key": "1111",
       "fs.s3a.access.key": "111"
     },
     "workspaces": {
       "default": {
         "location": "/iceberg-data-lake",
         "writable": false,
         "defaultInputFormat": null,
         "allowAccessOutsideWorkspace": false
       },
       "root": {
         "location": "/iceberg-data-lake",
         "writable": false,
         "defaultInputFormat": null,
         "allowAccessOutsideWorkspace": false
       }
     },
     "formats": {
       "iceberg": {
         "type": "iceberg",
         "properties": {
           "read.split.target-size": "536870912",
           "read.split.metadata-target-size": "33554432"
         },
         "caseSensitive": true,
         "includeColumnStats": true,
         "ignoreResiduals": null,
         "snapshotId": null,
         "snapshotAsOfTime": null,
         "fromSnapshotId": null,
         "toSnapshotId": null
       }
     },
   
     "authMode": "SHARED_USER",
     "enabled": true
   }
   ```
   
   The command "SHOW FILES IN s3_iceberg" returns
   
![image](https://github.com/apache/drill/assets/772950/58ae3a78-1450-4518-a5bd-cfb866bd5131)
   
   "SHOW FILES IN s3_iceberg.iceberg_accumulated_exposure" returns
   
![image](https://github.com/apache/drill/assets/772950/9ebf29f4-69eb-437d-9248-b32fe2caf46a)
   
   When I launch this query "_ANALYZE TABLE 
s3_iceberg.iceberg_accumulated_exposure REFRESH METADATA;_"
    I get
   
![image](https://github.com/apache/drill/assets/772950/e8c4d7cf-7d4a-4827-95b3-987968b65b72)
   
   The query "_select * from s3_iceberg.iceberg_accumulated_exposure_" returns 
same error
   
   
![image](https://github.com/apache/drill/assets/772950/4ad5e720-0964-42c4-a2ac-c932566f62a4)
   
   Can you share a configuration that you know works? 
   
   Thank you.
   
   


-- 
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: dev-unsubscr...@drill.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org