[jira] [Updated] (HIVE-3849) Aliased column in where clause for multi-groupby single reducer cannot be resolved
[ https://issues.apache.org/jira/browse/HIVE-3849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-3849: - Resolution: Fixed Fix Version/s: 0.11.0 Hadoop Flags: Reviewed Status: Resolved (was: Patch Available) Committed. Thanks Navis 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 Fix For: 0.11.0 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, HIVE-3849.D7713.8.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
[jira] [Updated] (HIVE-3849) Aliased column in where clause for multi-groupby single reducer cannot be resolved
[ https://issues.apache.org/jira/browse/HIVE-3849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-3849: Status: Patch Available (was: Open) 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
[jira] [Updated] (HIVE-3849) Aliased column in where clause for multi-groupby single reducer cannot be resolved
[ 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.8.patch navis updated the revision HIVE-3849 [jira] Columns are not extracted for multi-groupby single reducer case somtimes. Addressed comments and rebased to trunk Reviewers: JIRA REVISION DETAIL https://reviews.facebook.net/D7713 CHANGE SINCE LAST DIFF https://reviews.facebook.net/D7713?vs=27243id=28815#toc AFFECTED FILES ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.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, HIVE-3849.D7713.8.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
[jira] [Updated] (HIVE-3849) Aliased column in where clause for multi-groupby single reducer cannot be resolved
[ 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=26973id=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
[jira] [Updated] (HIVE-3849) Aliased column in where clause for multi-groupby single reducer cannot be resolved
[ https://issues.apache.org/jira/browse/HIVE-3849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-3849: Status: Patch Available (was: Open) 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 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
[jira] [Updated] (HIVE-3849) Aliased column in where clause for multi-groupby single reducer cannot be resolved
[ https://issues.apache.org/jira/browse/HIVE-3849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-3849: - Status: Open (was: Patch Available) comments 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 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
[jira] [Updated] (HIVE-3849) Aliased column in where clause for multi-groupby single reducer cannot be resolved
[ https://issues.apache.org/jira/browse/HIVE-3849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-3849: --- Status: Open (was: Patch Available) All the tests passed except groupby_multi_single_reducer3.q Navis can you take a look. 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 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
[jira] [Updated] (HIVE-3849) Aliased column in where clause for multi-groupby single reducer cannot be resolved
[ https://issues.apache.org/jira/browse/HIVE-3849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-3849: Status: Patch Available (was: Open) HIVE-3699 changed test result. Fixed that. 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 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
[jira] [Updated] (HIVE-3849) Aliased column in where clause for multi-groupby single reducer cannot be resolved
[ 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.5.patch navis updated the revision HIVE-3849 [jira] Columns are not extracted for multi-groupby single reducer case somtimes. Reviewers: JIRA Fixed test result which is affected by HIVE-3699 REVISION DETAIL https://reviews.facebook.net/D7713 AFFECTED FILES ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.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 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
[jira] [Updated] (HIVE-3849) Aliased column in where clause for multi-groupby single reducer cannot be resolved
[ https://issues.apache.org/jira/browse/HIVE-3849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-3849: - Status: Open (was: Patch Available) minor comments 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 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
[jira] [Updated] (HIVE-3849) Aliased column in where clause for multi-groupby single reducer cannot be resolved
[ 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.4.patch navis updated the revision HIVE-3849 [jira] Columns are not extracted for multi-groupby single reducer case somtimes. Reviewers: JIRA Addressed comments REVISION DETAIL https://reviews.facebook.net/D7713 AFFECTED FILES ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.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 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
[jira] [Updated] (HIVE-3849) Aliased column in where clause for multi-groupby single reducer cannot be resolved
[ https://issues.apache.org/jira/browse/HIVE-3849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-3849: - Status: Open (was: Patch Available) comments on phabricator 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 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
[jira] [Updated] (HIVE-3849) Aliased column in where clause for multi-groupby single reducer cannot be resolved
[ https://issues.apache.org/jira/browse/HIVE-3849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-3849: Summary: Aliased column in where clause for multi-groupby single reducer cannot be resolved (was: Columns are not extracted for multi-groupby single reducer case somtimes) 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 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
[jira] [Updated] (HIVE-3849) Aliased column in where clause for multi-groupby single reducer cannot be resolved
[ https://issues.apache.org/jira/browse/HIVE-3849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-3849: Status: Patch Available (was: Open) 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 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
[jira] [Updated] (HIVE-3849) Aliased column in where clause for multi-groupby single reducer cannot be resolved
[ 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.3.patch navis updated the revision HIVE-3849 [jira] Columns are not extracted for multi-groupby single reducer case somtimes. Reviewers: JIRA Removed MapJoin hint from test case REVISION DETAIL https://reviews.facebook.net/D7713 AFFECTED FILES ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.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 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