You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Laljo John Pullokkaran (JIRA)" <ji...@apache.org> on 2014/08/25 19:58:59 UTC

[jira] [Updated] (HIVE-7720) CBO: rank translation to Optiq RelNode tree failing

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

Laljo John Pullokkaran updated HIVE-7720:
-----------------------------------------

    Assignee: Laljo John Pullokkaran

> CBO: rank translation to Optiq RelNode tree failing
> ---------------------------------------------------
>
>                 Key: HIVE-7720
>                 URL: https://issues.apache.org/jira/browse/HIVE-7720
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Query Processor
>            Reporter: Harish Butani
>            Assignee: Laljo John Pullokkaran
>
> Following query:
> {code}
> explain select p_name
> from (select p_mfgr, p_name, p_size, rank() over(partition by p_mfgr order by p_size) as r from part) a
> where r <= 2;
> {code}
> fails with 
> {quote}
> org.apache.hadoop.hive.ql.exec.UDFArgumentTypeException: One or more arguments are expected.
> 	at org.apache.hadoop.hive.ql.udf.generic.GenericUDAFRank.getEvaluator(GenericUDAFRank.java:61)
> 	at org.apache.hadoop.hive.ql.udf.generic.AbstractGenericUDAFResolver.getEvaluator(AbstractGenericUDAFResolver.java:47)
> 	at org.apache.hadoop.hive.ql.exec.FunctionRegistry.getGenericUDAFEvaluator(FunctionRegistry.java:1110)
> 	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getGenericUDAFEvaluator(SemanticAnalyzer.java:3506)
> 	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer$OptiqBasedPlanner.getHiveAggInfo(SemanticAnalyzer.java:12496)
> 	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer$OptiqBasedPlanner.genWindowingProj(SemanticAnalyzer.java:12858)
> {quote}



--
This message was sent by Atlassian JIRA
(v6.2#6252)