David Rorke created IMPALA-11618:
------------------------------------

             Summary: Impala fails to read Iceberg snapshot tables created by 
Spark using call spark_catalog.system.snapshot() 
                 Key: IMPALA-11618
                 URL: https://issues.apache.org/jira/browse/IMPALA-11618
             Project: IMPALA
          Issue Type: Bug
          Components: Catalog
    Affects Versions: Impala 4.1.0
            Reporter: David Rorke


I get an exception from catalog when Impala tries to read an Iceberg "snapshot" 
table created by a spark job using this API:  
[https://iceberg.apache.org/docs/latest/spark-procedures/#snapshot]


{noformat}
Query submitted at: 2022-09-27 09:43:15 (Coordinator: 
http://coordinator-0.coordinator-int.impala-1662757723-t7hk.svc.cluster.local:25000)
ERROR: AnalysisException: Failed to load metadata for table: 
'customer_iceberg_snapshot'
CAUSED BY: TableLoadingException: Could not load table 
tpcds_3000_string_parquet_external.customer_iceberg_snapshot from catalog
CAUSED BY: TException: 
TGetPartialCatalogObjectResponse(status:TStatus(status_code:GENERAL, 
error_msgs:[IcebergTableLoadingException: Error loading metadata for Iceberg 
table 
s3a://drorke-dwxperf2/warehouse/tablespace/external/hive/tpcds_3000_string_parquet_external.db/customer_iceberg_snapshot
CAUSED BY: RuntimeException: FileSystem returned an unexpected path 
s3a://drorke-dwxperf2/warehouse/tablespace/external/hive/tpcds_3000_string_parquet_external.db/customer/0b443b4d91612be0-af2edb1b00000000_1194661597_data.0.parq
 for a file within 
s3a://drorke-dwxperf2/warehouse/tablespace/external/hive/tpcds_3000_string_parquet_external.db/customer_iceberg_snapshot]),
 lookup_status:OK)
Looks like Impala gets confused in FileSystemUtils.relativizePath() because the 
final directory component in the new snapshot table name 
(customer_iceberg_snapshot) is different from the corresponding path component 
in the file.
{noformat}

It looks like Impala gets confused in FileSystemUtils.relativizePath() because 
the final directory component in the new snapshot table name 
(customer_iceberg_snapshot) is different from the corresponding path component 
in the file.





--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to