You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Chinna Rao Lalam (Commented) (JIRA)" <ji...@apache.org> on 2011/11/08 17:01:52 UTC

[jira] [Commented] (HIVE-2512) After HIVE-2145, Hive disallow any use of function in cluster-by clause

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

Chinna Rao Lalam commented on HIVE-2512:
----------------------------------------

select key, count(1) cnt from src group by key order by count(1) limit 10;

Here order by is requested with the aggregate function in execution flow of this query in org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory.DefaultExprProcessor.getXpathOrFuncExprNodeDesc(ASTNode, boolean, ArrayList<ExprNodeDesc>, TypeCheckCtx) while constructing ExprNodeGenericFuncDesc it is expecting GenericUDF() but here it is requested with aggregate function so it is returning null and it is throwing NullPointerException

So before constructing ExprNodeGenericFuncDesc added a check if it is UDAF throw exception

And it should work with below queries ,

select key,min(key) from src group by key having min(key) > 100;
select key,min(key) as mininum from src group by key order by mininum;
                
> After HIVE-2145, Hive disallow any use of function in cluster-by clause
> -----------------------------------------------------------------------
>
>                 Key: HIVE-2512
>                 URL: https://issues.apache.org/jira/browse/HIVE-2512
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Ning Zhang
>            Assignee: Chinna Rao Lalam
>         Attachments: HIVE-2512.1.patch, HIVE-2512.2.patch, HIVE-2512.patch
>
>
> After HIVE-2145, the following query returns a semantic analysis error: 
> FROM src SELECT * cluster by rand();
> FAILED: Error in semantic analysis: functions are not supported in order by
> Looking back at HIVE-2145, it's clear that the patch is more restrictive than necessary. 
> Chinna, are you able to work on it? Please let me know if you don't have cycles to do it now. 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira