Sql below will get all partitions from metastore, which put much burden on metastore;
CREATE TABLE test (value INT) PARTITIONED BY (dt STRING)
SELECT * from test where dt=2017
The reason is that the the analyzed attribute dt is wrapped in Cast and HiveShim fails to generate a proper partition filter.
Could we fix this? Sql like SELECT * from test where dt=2017 is common in my warehouse.