[
https://issues.apache.org/jira/browse/HIVE-2340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Phabricator updated HIVE-2340:
------------------------------
Attachment: HIVE-2340.D1209.13.patch
navis updated the revision "HIVE-2340 [jira] optimize orderby followed by a
groupby".
Rolled back removing schema of FIL on CP optimization (made problem with some
joins)
Reviewers: JIRA
REVISION DETAIL
https://reviews.facebook.net/D1209
CHANGE SINCE LAST DIFF
https://reviews.facebook.net/D1209?vs=27669&id=27729#toc
AFFECTED FILES
common/src/java/org/apache/hadoop/hive/conf/HiveConf.java
conf/hive-default.xml.template
ql/src/java/org/apache/hadoop/hive/ql/optimizer/ColumnPrunerProcFactory.java
ql/src/java/org/apache/hadoop/hive/ql/optimizer/MapJoinProcessor.java
ql/src/java/org/apache/hadoop/hive/ql/optimizer/Optimizer.java
ql/src/java/org/apache/hadoop/hive/ql/optimizer/ReduceSinkDeDuplication.java
ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/CommonJoinResolver.java
ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/SkewJoinProcFactory.java
ql/src/java/org/apache/hadoop/hive/ql/plan/ExprNodeDescUtils.java
ql/src/java/org/apache/hadoop/hive/ql/plan/JoinDesc.java
ql/src/test/queries/clientpositive/auto_join26.q
ql/src/test/queries/clientpositive/groupby_distinct_samekey.q
ql/src/test/queries/clientpositive/reduce_deduplicate.q
ql/src/test/queries/clientpositive/reduce_deduplicate_extended.q
ql/src/test/results/clientpositive/auto_join19.q.out
ql/src/test/results/clientpositive/auto_join9.q.out
ql/src/test/results/clientpositive/bucketmapjoin1.q.out
ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out
ql/src/test/results/clientpositive/cluster.q.out
ql/src/test/results/clientpositive/filter_join_breaktask.q.out
ql/src/test/results/clientpositive/groupby2.q.out
ql/src/test/results/clientpositive/groupby2_map_skew.q.out
ql/src/test/results/clientpositive/groupby_cube1.q.out
ql/src/test/results/clientpositive/groupby_distinct_samekey.q.out
ql/src/test/results/clientpositive/groupby_rollup1.q.out
ql/src/test/results/clientpositive/index_auto_mult_tables.q.out
ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out
ql/src/test/results/clientpositive/index_auto_self_join.q.out
ql/src/test/results/clientpositive/index_bitmap3.q.out
ql/src/test/results/clientpositive/index_bitmap_auto.q.out
ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out
ql/src/test/results/clientpositive/index_bitmap_compression.q.out
ql/src/test/results/clientpositive/infer_bucket_sort.q.out
ql/src/test/results/clientpositive/input39_hadoop20.q.out
ql/src/test/results/clientpositive/join38.q.out
ql/src/test/results/clientpositive/join9.q.out
ql/src/test/results/clientpositive/join_map_ppr.q.out
ql/src/test/results/clientpositive/lateral_view_ppd.q.out
ql/src/test/results/clientpositive/louter_join_ppr.q.out
ql/src/test/results/clientpositive/noalias_subq1.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_gby_join.q.out
ql/src/test/results/clientpositive/ppd_repeated_alias.q.out
ql/src/test/results/clientpositive/reduce_deduplicate.q.out
ql/src/test/results/clientpositive/reduce_deduplicate_extended.q.out
ql/src/test/results/clientpositive/router_join_ppr.q.out
ql/src/test/results/clientpositive/semijoin.q.out
ql/src/test/results/clientpositive/smb_mapjoin9.q.out
ql/src/test/results/clientpositive/sort_merge_join_desc_1.q.out
ql/src/test/results/clientpositive/sort_merge_join_desc_2.q.out
ql/src/test/results/clientpositive/sort_merge_join_desc_3.q.out
ql/src/test/results/clientpositive/sort_merge_join_desc_4.q.out
ql/src/test/results/clientpositive/stats11.q.out
ql/src/test/results/clientpositive/union24.q.out
ql/src/test/results/clientpositive/union26.q.out
ql/src/test/results/clientpositive/union_view.q.out
ql/src/test/results/compiler/plan/case_sensitivity.q.xml
ql/src/test/results/compiler/plan/cast1.q.xml
ql/src/test/results/compiler/plan/input1.q.xml
ql/src/test/results/compiler/plan/input6.q.xml
ql/src/test/results/compiler/plan/input9.q.xml
ql/src/test/results/compiler/plan/input_part1.q.xml
ql/src/test/results/compiler/plan/input_testxpath2.q.xml
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
ql/src/test/results/compiler/plan/sample7.q.xml
ql/src/test/results/compiler/plan/subq.q.xml
ql/src/test/results/compiler/plan/udf1.q.xml
ql/src/test/results/compiler/plan/union.q.xml
To: JIRA, navis
Cc: hagleitn, njain
> optimize orderby followed by a groupby
> --------------------------------------
>
> Key: HIVE-2340
> URL: https://issues.apache.org/jira/browse/HIVE-2340
> Project: Hive
> Issue Type: Sub-task
> Components: Query Processor
> Reporter: Navis
> Assignee: Navis
> Priority: Minor
> Labels: perfomance
> Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2340.D1209.1.patch,
> ASF.LICENSE.NOT.GRANTED--HIVE-2340.D1209.2.patch,
> ASF.LICENSE.NOT.GRANTED--HIVE-2340.D1209.3.patch,
> ASF.LICENSE.NOT.GRANTED--HIVE-2340.D1209.4.patch,
> ASF.LICENSE.NOT.GRANTED--HIVE-2340.D1209.5.patch, HIVE-2340.12.patch,
> HIVE-2340.13.patch, HIVE-2340.1.patch.txt, HIVE-2340.D1209.10.patch,
> HIVE-2340.D1209.11.patch, HIVE-2340.D1209.12.patch, HIVE-2340.D1209.13.patch,
> HIVE-2340.D1209.6.patch, HIVE-2340.D1209.7.patch, HIVE-2340.D1209.8.patch,
> HIVE-2340.D1209.9.patch, testclidriver.txt
>
>
> Before implementing optimizer for JOIN-GBY, try to implement RS-GBY
> optimizer(cluster-by following group-by).
--
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
