You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Phabricator (JIRA)" <ji...@apache.org> on 2013/08/22 07:58:52 UTC
[jira] [Updated] (HIVE-4293) Predicates following UDTF operator are
removed by PPD
[ https://issues.apache.org/jira/browse/HIVE-4293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Phabricator updated HIVE-4293:
------------------------------
Attachment: HIVE-4293.D9933.5.patch
navis updated the revision "HIVE-4293 [jira] Predicates following UDTF operator are removed by PPD".
Rebased to trunk
Reviewers: JIRA
REVISION DETAIL
https://reviews.facebook.net/D9933
CHANGE SINCE LAST DIFF
https://reviews.facebook.net/D9933?vs=35949&id=38595#toc
AFFECTED FILES
ql/src/java/org/apache/hadoop/hive/ql/exec/LateralViewJoinOperator.java
ql/src/java/org/apache/hadoop/hive/ql/exec/ReduceSinkOperator.java
ql/src/java/org/apache/hadoop/hive/ql/optimizer/ColumnPrunerProcFactory.java
ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
ql/src/java/org/apache/hadoop/hive/ql/plan/LateralViewJoinDesc.java
ql/src/java/org/apache/hadoop/hive/ql/ppd/ExprWalkerInfo.java
ql/src/java/org/apache/hadoop/hive/ql/ppd/OpProcFactory.java
ql/src/java/org/apache/hadoop/hive/ql/ppd/PredicatePushDown.java
ql/src/test/queries/clientpositive/lateral_view_ppd.q
ql/src/test/queries/clientpositive/ppd_udtf.q
ql/src/test/results/clientpositive/cluster.q.out
ql/src/test/results/clientpositive/ctas_colname.q.out
ql/src/test/results/clientpositive/lateral_view_ppd.q.out
ql/src/test/results/clientpositive/ppd2.q.out
ql/src/test/results/clientpositive/ppd_gby.q.out
ql/src/test/results/clientpositive/ppd_gby2.q.out
ql/src/test/results/clientpositive/ppd_udtf.q.out
ql/src/test/results/clientpositive/udtf_json_tuple.q.out
ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out
ql/src/test/results/compiler/plan/join1.q.xml
ql/src/test/results/compiler/plan/join2.q.xml
ql/src/test/results/compiler/plan/join3.q.xml
ql/src/test/results/compiler/plan/join4.q.xml
ql/src/test/results/compiler/plan/join5.q.xml
ql/src/test/results/compiler/plan/join6.q.xml
ql/src/test/results/compiler/plan/join7.q.xml
ql/src/test/results/compiler/plan/join8.q.xml
To: JIRA, navis
> Predicates following UDTF operator are removed by PPD
> -----------------------------------------------------
>
> Key: HIVE-4293
> URL: https://issues.apache.org/jira/browse/HIVE-4293
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Navis
> Assignee: Navis
> Attachments: HIVE-4293.D9933.1.patch, HIVE-4293.D9933.2.patch, HIVE-4293.D9933.3.patch, HIVE-4293.D9933.4.patch, HIVE-4293.D9933.5.patch
>
>
> For example,
> {noformat}
> explain SELECT value from (
> select explode(array(key, value)) as (value) from (
> select * FROM src WHERE key > 200
> ) A
> ) B WHERE value > 300
> ;
> {noformat}
> Makes plan like this, removing last predicates
> {noformat}
> TableScan
> alias: src
> Filter Operator
> predicate:
> expr: (key > 200.0)
> type: boolean
> Select Operator
> expressions:
> expr: array(key,value)
> type: array<string>
> outputColumnNames: _col0
> UDTF Operator
> function name: explode
> Select Operator
> expressions:
> expr: col
> type: string
> outputColumnNames: _col0
> File Output Operator
> compressed: false
> GlobalTableId: 0
> table:
> input format: org.apache.hadoop.mapred.TextInputFormat
> output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
> {noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira