Hi all, I am trying to create an external catalog to query s3 files, CREATE EXTERNAL CATALOG

kap_catalog

PROPERTIES ( "aws.s3.access_key" = "******", "iceberg.catalog.jdbc.driver" = "org.postgresql.Driver", "aws.s3.secret_key" = "******", "aws.s3.endpoint" = "https://storage.googleapis.com", "aws.s3.enable_path_style_access" = "true", "iceberg.catalog.uri" = "jdbcpostgresql//postgres-host-ip:5432/warehouse", "type" = "iceberg", "aws.s3.use_aws_sdk_default_behavior" = "false", "iceberg.catalog.jdbc.user" = "postgres", "aws.s3.region" = "asia-south1", "aws.s3.use_instance_profile" = "false", "iceberg.catalog.warehouse" = "s3://warehouse", "iceberg.catalog.type" = "jdbc", "iceberg.catalog.jdbc.password" = "postgres-password" ) I am able to run below queries: show catalogs set catalog kap_catalog show databases use database_name show tables But I am unable to run: select *count*(*) from table_name Or any other select query. The query is running infinitely in this case. Please help

This seems interesting, you are trying to use GCS S3 Compatibility with a JDBC based catalog but adding also iceberg ? Seems like conflicting parameters