# IMPALA-5336: Test partition pruning when the string partition col is implicitly cast
# to TIMESTAMP
select * from functional.stringpartitionkey
where string_col=cast("2009-01-01 00:00:00" as timestamp);
---- PLAN
F00:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=32.00MB mem-reservation=8.00KB thread-reservation=2
PLAN-ROOT SINK
|  output exprs: functional.stringpartitionkey.id, functional.stringpartitionkey.string_col
|  mem-estimate=0B mem-reservation=0B thread-reservation=0
|
00:SCAN HDFS [functional.stringpartitionkey]
   partition predicates: CAST(string_col AS TIMESTAMP) = TIMESTAMP '2009-01-01 00:00:00'
   HDFS partitions=1/2 files=1 size=2B
   stored statistics:
     table: rows=1 size=2B
     partitions: 1/1 rows=1
     columns: all
   extrapolated-rows=disabled max-scan-range-rows=1
   mem-estimate=32.00MB mem-reservation=8.00KB thread-reservation=1
   tuple-ids=0 row-size=16B cardinality=1
   in pipelines: 00(GETNEXT)
====