| # 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) |
| ==== |
| # IMPALA-7784: Test partition pruning on unescaped string values |
| select * from functional.part_strings_with_quotes where p = "\"" and p=concat("", '"') |
| ---- 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.part_strings_with_quotes.i, functional.part_strings_with_quotes.p |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | |
| 00:SCAN HDFS [functional.part_strings_with_quotes] |
| partition predicates: p = '"' |
| HDFS partitions=1/4 files=1 size=2B |
| stored statistics: |
| table: rows=4 size=8B |
| partitions: 1/1 rows=1 |
| columns: all |
| extrapolated-rows=disabled max-scan-range-rows=4 |
| mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=1 |
| tuple-ids=0 row-size=16B cardinality=1 |
| in pipelines: 00(GETNEXT) |
| ==== |
| # IMPALA-7784: Test partition pruning on unescaped string values |
| select * from functional.part_strings_with_quotes where p = '\'' |
| ---- 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.part_strings_with_quotes.i, functional.part_strings_with_quotes.p |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | |
| 00:SCAN HDFS [functional.part_strings_with_quotes] |
| partition predicates: p = '\'' |
| HDFS partitions=1/4 files=1 size=2B |
| stored statistics: |
| table: rows=4 size=8B |
| partitions: 1/1 rows=1 |
| columns: all |
| extrapolated-rows=disabled max-scan-range-rows=4 |
| mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=1 |
| tuple-ids=0 row-size=16B cardinality=1 |
| in pipelines: 00(GETNEXT) |
| ==== |
| # IMPALA-7784: Test partition pruning on unescaped string values |
| select * from functional.part_strings_with_quotes where p = "\\\"" |
| ---- 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.part_strings_with_quotes.i, functional.part_strings_with_quotes.p |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | |
| 00:SCAN HDFS [functional.part_strings_with_quotes] |
| partition predicates: p = '\\"' |
| HDFS partitions=1/4 files=1 size=2B |
| stored statistics: |
| table: rows=4 size=8B |
| partitions: 1/1 rows=1 |
| columns: all |
| extrapolated-rows=disabled max-scan-range-rows=4 |
| mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=1 |
| tuple-ids=0 row-size=16B cardinality=1 |
| in pipelines: 00(GETNEXT) |
| ==== |
| # IMPALA-7784: Test partition pruning on unescaped string values |
| select * from functional.part_strings_with_quotes where p = '\\\'' |
| ---- 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.part_strings_with_quotes.i, functional.part_strings_with_quotes.p |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | |
| 00:SCAN HDFS [functional.part_strings_with_quotes] |
| partition predicates: p = '\\\'' |
| HDFS partitions=1/4 files=1 size=2B |
| stored statistics: |
| table: rows=4 size=8B |
| partitions: 1/1 rows=1 |
| columns: all |
| extrapolated-rows=disabled max-scan-range-rows=4 |
| mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=1 |
| tuple-ids=0 row-size=16B cardinality=1 |
| in pipelines: 00(GETNEXT) |
| ==== |
| # IMPALA-7784: Test partition pruning on unescaped string values |
| select * from functional.part_strings_with_quotes where p in ("\"", "\\\"") |
| ---- 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.part_strings_with_quotes.i, functional.part_strings_with_quotes.p |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | |
| 00:SCAN HDFS [functional.part_strings_with_quotes] |
| partition predicates: p IN ('"', '\\"') |
| HDFS partitions=2/4 files=2 size=4B |
| stored statistics: |
| table: rows=4 size=8B |
| partitions: 2/2 rows=2 |
| columns: all |
| extrapolated-rows=disabled max-scan-range-rows=2 |
| mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=1 |
| tuple-ids=0 row-size=16B cardinality=2 |
| in pipelines: 00(GETNEXT) |
| ==== |