| # 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) |
| ==== |