Harish Butani created HIVE-7720:
-----------------------------------
Summary: 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
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)
