hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashutosh Chauhan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-4101) Partition By field must be in select field list
Date Fri, 01 Mar 2013 18:17:13 GMT

    [ https://issues.apache.org/jira/browse/HIVE-4101?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13590789#comment-13590789
] 

Ashutosh Chauhan commented on HIVE-4101:
----------------------------------------

This is same as HIVE-4085. It is caused by HIVE-4035, before which such a query used to succeed.
                
> Partition By field must be in select field list
> -----------------------------------------------
>
>                 Key: HIVE-4101
>                 URL: https://issues.apache.org/jira/browse/HIVE-4101
>             Project: Hive
>          Issue Type: Bug
>          Components: PTF-Windowing
>            Reporter: Brock Noland
>
> This following query:
> {noformat}
> SELECT year, quarter, sales,avg(sales) OVER (PARTITION BY department, year)
> FROM quarterly_sales
> WHERE department = 'Appliances';
> {noformat}
> fails as below. If department is moved to the select field list it passes.
> {noformat}
> Diagnostic Messages for this Task:java.lang.RuntimeException: Error in configuring object
>      at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:93)
>      at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:64)
>      at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117)
>      at org.apache.hadoop.mapred.ReduceTask.runOldReducer(ReduceTask.java:485)
>      at org.apache.hadoop.mapred.ReduceTask.run(ReduceTask.java:420)
>      at org.apache.hadoop.mapred.Child$4.run(Child.java:255)
>      at java.security.AccessController.doPrivileged(Native Method)
>      at javax.security.auth.Subject.doAs(Subject.java:396)
>      at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1121)
>      at org.apache.hadoop.mapred.Child.main(Child.java:249)
> Caused by: java.lang.reflect.InvocationTargetException
>      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>      at java.lang.reflect.Method.invoke(Method.java:597)
>      at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:88)
>      ... 9 more
> Caused by: java.lang.RuntimeException: Reduce operator initialization failed
>      at org.apache.hadoop.hive.ql.exec.ExecReducer.configure(ExecReducer.java:160)
>      ... 14 more
> Caused by: java.lang.RuntimeException: cannot find field _col0 from [0:_col1, 1:_col2,
2:_col3]
>      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.PTFOperator.setupKeysWrapper(PTFOperator.java:193)
>      at org.apache.hadoop.hive.ql.exec.PTFOperator.initializeOp(PTFOperator.java:100)
>      at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:377)
>      at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:481)
>      at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:409)
>      at org.apache.hadoop.hive.ql.exec.ExtractOperator.initializeOp(ExtractOperator.java:40)
>      at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:377)
>      at org.apache.hadoop.hive.ql.exec.ExecReducer.configure(ExecReducer.java:152)
>      ... 14 more
> {noformat}

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