[IMPALA-10184] Iceberg PARTITION SPEC missing from SHOW CREATE TABLE

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Impala 4.0.0
• Component/s: Frontend
• Labels: impala-iceberg
• Epic Link: Iceberg support in Impala
• Target Version: Impala 4.0.0
• Epic Color: ghx-label-14
• Assignee: Gabor Kaszab
• Reporter: Gabor Kaszab
• Created: 22/Sep/20 13:53
• Updated: 28/Jul/21 08:39
• Resolved: 06/Oct/20 06:10

Description

The PARTITION SPEC is missing from the SHOW CREATE TABLE output for Iceberg tables.

This is how I created a table:

create table iceberg_tmp2 (
  i int, 
  s string, 
  p1 string,
  p2 timestamp
) 
partition by spec (
  p1 identity, 
  p2 Day
) 
stored as iceberg;

And this is the output of SHOW CREATE TABLE for the same table:

+-----------------------------------------------------------+
| CREATE EXTERNAL TABLE default.iceberg_tmp2 (
|   i INT,
|   s STRING, 
|   p1 STRING,
|   p2 TIMESTAMP
| )
| STORED AS ICEBERG 
| LOCATION 'hdfs://localhost:20500/test-warehouse/iceberg_tmp2'                                                        | TBLPROPERTIES ('OBJCAPABILITIES'='EXTREAD,EXTWRITE', 'external.table.purge'='TRUE', 'iceberg_file_format'='parquet')
+----------------------------------------------------------------------+