Partition filter not used when in clause

21

Hello @balaji.ramaswamy @Ivan_Chesnov any news?

22

Hello @balaji.ramaswamy and @Ivan_Chesnov sorry by insistence, do you have any news about this ?

23

@dacopan

Was trying to reproduce the issue but do not find the “show create table” statement for ID_SPACE, can you please give that also and will try a repro

24

Hello this is the DDL of space

CREATE TABLE lake.prod.spaces
(
    ID_SPACE varchar,
    ID_PAGE  varchar,
    RED      varchar
)
25

@dacopan Just so I am clear, spaces is also a Iceberg table and none of the columns are partition columns, correct?

26

yes is a iceber table and has few rows < 2k and this table has no partitions

27

Thanks @dacopan Was able to reproduce your exact same symptom, let me investigate on my local repro

1 Like