Re: Anyone tried 'analyze table' on partitioned Iceberg tables?

[Denys Kuzmenko]

below test-case works as expected:

create external table src_ice(
    a int,
    b string,
    c int
)
stored by iceberg;

insert into src_ice values
    (1, 'one', 50),
    (2, 'two', 51),
    (2, 'two', 51),
    (2, 'two', 51),
    (3, 'three', 52),
    (4, 'four', 53),
    (5, 'five', 54),
    (111, 'one', 55),
    (333, 'two', 56);

create external table tbl_ice(
    a int,
    b string
)
partitioned by (c int)
stored by iceberg;

insert overwrite table tbl_ice select * from src_ice;
delete from tbl_ice where a <= 2;

analyze table tbl_ice compute statistics for columns A, C;
explain select min(a), max(c) from tbl_ice;
select count(*) from tbl_ice;
desc formatted tbl_ice C;