| ==== |
| ---- QUERY |
| # IMPALA-14569: failing partition pruning due to mismatchig partition types |
| create table a(id int) partitioned by (date_stored_as_string string); |
| create table b(id int) partitioned by (date_stored_as_date date); |
| insert into a(id, date_stored_as_string) values(1, '2025-12-12'); |
| insert into a(id, date_stored_as_string) values(1, '2025-12-10'); |
| insert into b(id, date_stored_as_date) values(1, '2025-12-12'); |
| select * from b |
| left outer join a on date_stored_as_date = date_stored_as_string |
| where date_stored_as_date in ( '2025-12-12'); |
| ---- RESULTS |
| 1,2025-12-12,1,'2025-12-12' |
| ---- TYPES |
| INT,DATE,INT,STRING |
| ---- RUNTIME_PROFILE |
| row_regex: partitions=1/2 files=1 size= |
