[jira] [Updated] (HIVE-3849) Aliased column in where clause for multi-groupby single reducer cannot be resolved

2013-02-28 Thread Namit Jain (JIRA)

 [ 
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

2013-02-27 Thread Navis (JIRA)

 [ 
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

2013-02-27 Thread Phabricator (JIRA)

 [ 
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

2013-02-04 Thread Phabricator (JIRA)

 [ 
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

2013-01-31 Thread Navis (JIRA)

 [ 
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

2013-01-31 Thread Namit Jain (JIRA)

 [ 
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

2013-01-20 Thread Ashutosh Chauhan (JIRA)

 [ 
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

2013-01-20 Thread Navis (JIRA)

 [ 
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

2013-01-20 Thread Phabricator (JIRA)

 [ 
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

2013-01-20 Thread Namit Jain (JIRA)

 [ 
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

2013-01-15 Thread Phabricator (JIRA)

 [ 
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

2013-01-08 Thread Namit Jain (JIRA)

 [ 
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

2013-01-03 Thread Navis (JIRA)

 [ 
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

2013-01-03 Thread Navis (JIRA)

 [ 
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

2013-01-03 Thread Phabricator (JIRA)

 [ 
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