Hi, Some of our Hive tables are partitioned on a STRING column "datepartition" whose format is "yyyy-mm-dd-hh". Usually, when users want to read only a specific day of data, they'll specify WHERE datepartition = '2016-11-28-00', for example. However, sometimes users accidentally forget the quotes around the datepartition value (e.g.: WHERE datepartition = 2016-11-28-00), and all partitions end up being scanned (though no results are returned). I'm wondering why Hive tries to scan all partitions when the quotes are omitted. Without the quotes, shouldn't 2016-11-28-00 get evaluated as an arithmetic expression, then get cast to a string, and then partitioning pruning still occur?
Best, Anthony
