Zach Amsden has posted comments on this change.
Change subject: IMPALA-5003: [DRAFT] Generic constant propagation in planner
......................................................................
Patch Set 2:
I was not returning the result. Surely there must be a short-hand for such
list assignment that I am missing.
Now this is done, inline views just automatically work:
[localhost:21000] > show create table zhiddenpart;
Query: show create table zhiddenpart
+----------------------------------------------------------------------------------------------------------+
| result
|
+----------------------------------------------------------------------------------------------------------+
| CREATE VIEW `default`.zhiddenpart AS
|
| SELECT o_orderstatus, o_custkey, o_orderkey FROM `default`.zparted WHERE
partition_id = o_orderkey % 100 |
+----------------------------------------------------------------------------------------------------------+
Fetched 1 row(s) in 0.01s
[localhost:21000] > explain select * from zhiddenpart where o_orderkey = 1;
Query: explain select * from zhiddenpart where o_orderkey = 1
+------------------------------------------------------------------------------------+
| Explain String
|
+------------------------------------------------------------------------------------+
| Estimated Per-Host Requirements: Memory=32.00MB VCores=1
|
| WARNING: The following tables are missing relevant table and/or column
statistics. |
| default.zparted
|
|
|
| PLAN-ROOT SINK
|
| |
|
| 01:EXCHANGE [UNPARTITIONED]
|
| |
|
| 00:SCAN HDFS [default.zparted]
|
| partitions=1/100 files=1 size=235.39KB
|
| predicates: default.zparted.o_orderkey = 1
|
+------------------------------------------------------------------------------------+
Fetched 11 row(s) in 4.22s
--
To view, visit http://gerrit.cloudera.org:8080/6389
To unsubscribe, visit http://gerrit.cloudera.org:8080/settings
Gerrit-MessageType: comment
Gerrit-Change-Id: I79750a8edb945effee2a519fa3b8192b77042cb4
Gerrit-PatchSet: 2
Gerrit-Project: Impala-ASF
Gerrit-Branch: master
Gerrit-Owner: Zach Amsden <[email protected]>
Gerrit-Reviewer: Alex Behm <[email protected]>
Gerrit-Reviewer: Dan Hecht <[email protected]>
Gerrit-Reviewer: Zach Amsden <[email protected]>
Gerrit-HasComments: No
