hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Phabricator (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-3849) Aliased column in where clause for multi-groupby single reducer cannot be resolved
Date Tue, 05 Feb 2013 03:16:16 GMT

     [ https://issues.apache.org/jira/browse/HIVE-3849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Phabricator updated HIVE-3849:
------------------------------

    Attachment: HIVE-3849.D7713.7.patch

navis updated the revision "HIVE-3849 [jira] Columns are not extracted for multi-groupby single
reducer case somtimes".

  For addressing comment, I've generified some important entities and found it's affeting
many classes.
  @namit; I think this is not what you expected, or is it?

Reviewers: JIRA

REVISION DETAIL
  https://reviews.facebook.net/D7713

CHANGE SINCE LAST DIFF
  https://reviews.facebook.net/D7713?vs=26973&id=27243#toc

AFFECTED FILES
  ql/src/java/org/apache/hadoop/hive/ql/exec/Operator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/Task.java
  ql/src/java/org/apache/hadoop/hive/ql/index/IndexPredicateAnalyzer.java
  ql/src/java/org/apache/hadoop/hive/ql/lib/DefaultGraphWalker.java
  ql/src/java/org/apache/hadoop/hive/ql/lib/DefaultRuleDispatcher.java
  ql/src/java/org/apache/hadoop/hive/ql/lib/Dispatcher.java
  ql/src/java/org/apache/hadoop/hive/ql/lib/GraphWalker.java
  ql/src/java/org/apache/hadoop/hive/ql/lib/Node.java
  ql/src/java/org/apache/hadoop/hive/ql/lib/NodeProcessor.java
  ql/src/java/org/apache/hadoop/hive/ql/lib/PreOrderWalker.java
  ql/src/java/org/apache/hadoop/hive/ql/lib/Rule.java
  ql/src/java/org/apache/hadoop/hive/ql/lib/RuleExactMatch.java
  ql/src/java/org/apache/hadoop/hive/ql/lib/RuleRegExp.java
  ql/src/java/org/apache/hadoop/hive/ql/lib/TaskGraphWalker.java
  ql/src/java/org/apache/hadoop/hive/ql/lib/Utils.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/AbstractBucketJoinProc.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/BucketMapJoinOptimizer.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/ColumnPruner.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/ColumnPrunerProcFactory.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/GenMRFileSink1.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/GenMROperator.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/GenMRRedSink1.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/GenMRRedSink2.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/GenMRRedSink3.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/GenMRTableScan1.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/GenMRUnion1.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/GroupByOptimizer.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/MapJoinFactory.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/MapJoinProcessor.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/PrunerExpressionOperatorFactory.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/PrunerOperatorFactory.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/ReduceSinkDeDuplication.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/SamplePruner.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/SkewJoinOptimizer.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/SortedMergeBucketMapJoinOptimizer.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/index/RewriteCanApplyCtx.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/index/RewriteCanApplyProcFactory.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/index/RewriteQueryUsingAggregateIndex.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/index/RewriteQueryUsingAggregateIndexCtx.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/lineage/ExprProcFactory.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/lineage/OpProcFactory.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/pcr/PcrExprProcFactory.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/pcr/PcrOpProcFactory.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/BucketingSortingOpProcFactory.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/CommonJoinResolver.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/LocalMapJoinProcFactory.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/MapJoinResolver.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/MetadataOnlyOptimizer.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/SkewJoinProcFactory.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/SkewJoinResolver.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/index/IndexWhereProcessor.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/index/IndexWhereTaskDispatcher.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/unionproc/UnionProcFactory.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/ASTNode.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/BaseSemanticAnalyzer.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/PrintOpTreeProcessor.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/TableAccessAnalyzer.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java
  ql/src/java/org/apache/hadoop/hive/ql/plan/ExprNodeDesc.java
  ql/src/java/org/apache/hadoop/hive/ql/ppd/ExprWalkerProcFactory.java
  ql/src/java/org/apache/hadoop/hive/ql/ppd/OpProcFactory.java
  ql/src/java/org/apache/hadoop/hive/ql/ppd/PredicateTransitivePropagate.java
  ql/src/java/org/apache/hadoop/hive/ql/tools/LineageInfo.java
  ql/src/test/queries/clientpositive/groupby_multi_insert_common_distinct.q
  ql/src/test/queries/clientpositive/groupby_mutli_insert_common_distinct.q
  ql/src/test/queries/clientpositive/groupby_multi_single_reducer3.q
  ql/src/test/results/clientpositive/groupby_multi_insert_common_distinct.q.out
  ql/src/test/results/clientpositive/groupby_mutli_insert_common_distinct.q.out
  ql/src/test/results/clientpositive/groupby_multi_single_reducer3.q.out

To: JIRA, navis
Cc: njain

                
> Aliased column in where clause for multi-groupby single reducer cannot be resolved
> ----------------------------------------------------------------------------------
>
>                 Key: HIVE-3849
>                 URL: https://issues.apache.org/jira/browse/HIVE-3849
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Navis
>            Assignee: Navis
>            Priority: Minor
>         Attachments: HIVE-3849.D7713.1.patch, HIVE-3849.D7713.2.patch, HIVE-3849.D7713.3.patch,
HIVE-3849.D7713.4.patch, HIVE-3849.D7713.5.patch, HIVE-3849.D7713.6.patch, HIVE-3849.D7713.7.patch
>
>
> Verifying HIVE-3847, I've found an exception is thrown before meeting the error situation
described in it. Something like, 
> FAILED: SemanticException [Error 10025]: Line 40:6 Expression not in GROUP BY key 'crit5'

--
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

Mime
View raw message