impala-reviews mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zach Amsden (Code Review)" <ger...@cloudera.org>
Subject [Impala-ASF-CR] IMPALA-5003: [DRAFT] Generic constant propagation in planner
Date Tue, 14 Mar 2017 17:41:09 GMT
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 <zamsden@cloudera.com>
Gerrit-Reviewer: Alex Behm <alex.behm@cloudera.com>
Gerrit-Reviewer: Dan Hecht <dhecht@cloudera.com>
Gerrit-Reviewer: Zach Amsden <zamsden@cloudera.com>
Gerrit-HasComments: No

Mime
View raw message