[ https://issues.apache.org/jira/browse/HIVE-4143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13597996#comment-13597996 ]
Ashutosh Chauhan commented on HIVE-4143: ---------------------------------------- Stack trace of failed 3rd MR job: {code} Caused by: java.lang.RuntimeException: Reduce operator initialization failed at org.apache.hadoop.hive.ql.exec.ExecReducer.configure(ExecReducer.java:162) ... 14 more Caused by: java.lang.RuntimeException: cannot find field _wcol0 from [0:_col0, 1:_col1, 2:_col2] at org.apache.hadoop.hive.serde2.objectinspector.ObjectInspectorUtils.getStandardStructFieldRef(ObjectInspectorUtils.java:366) at org.apache.hadoop.hive.serde2.objectinspector.StandardStructObjectInspector.getStructFieldRef(StandardStructObjectInspector.java:143) at org.apache.hadoop.hive.ql.exec.ExprNodeColumnEvaluator.initialize(ExprNodeColumnEvaluator.java:57) at org.apache.hadoop.hive.ql.exec.Operator.initEvaluators(Operator.java:995) at org.apache.hadoop.hive.ql.exec.Operator.initEvaluatorsAndReturnStruct(Operator.java:1021) at org.apache.hadoop.hive.ql.exec.SelectOperator.initializeOp(SelectOperator.java:60) at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:385) at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:489) at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:417) at org.apache.hadoop.hive.ql.exec.Operator.initializeOp(Operator.java:402) at org.apache.hadoop.hive.ql.exec.PTFOperator.initializeOp(PTFOperator.java:102) at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:385) at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:489) at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:417) at org.apache.hadoop.hive.ql.exec.FilterOperator.initializeOp(FilterOperator.java:78) at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:385) at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:489) at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:417) at org.apache.hadoop.hive.ql.exec.ExtractOperator.initializeOp(ExtractOperator.java:40) at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:385) at org.apache.hadoop.hive.ql.exec.ExecReducer.configure(ExecReducer.java:154) {code} If I remove last where clause {{where rnk <= 3}} query succeeds. > Incorrect column mappings with over clause > ------------------------------------------ > > Key: HIVE-4143 > URL: https://issues.apache.org/jira/browse/HIVE-4143 > Project: Hive > Issue Type: Bug > Components: PTF-Windowing > Reporter: Ashutosh Chauhan > -- 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