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

Harish Butani commented on HIVE-7275:
-------------------------------------

1. most of these are UDFs: 
coalesce 
floor 
sign 
abs 
ltrim 
substring 
to_char
nvl 
cast 
decode 

nothing to be done for these.

2. ranking fns already support streaming.

3. We need streaming for count, row_num, mean, stddev. Also HIVE-7062 didn't 
add streaming for fVal, lVal.


> optimize these functions for windowing function.
> ------------------------------------------------
>
>                 Key: HIVE-7275
>                 URL: https://issues.apache.org/jira/browse/HIVE-7275
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.11.0, 0.12.0, 0.13.0
>         Environment: Hadoop 2.4.0, Hive 13.0
>            Reporter: Kiet Ly
>
> Please apply the window streaming optimization from issue HIVE-7143/7062 to 
> these functions if they are applicable.
> row_number 
> count 
> rank 
> dense_rank  
> nvl 
> rank 
> dense_rank  
> nvl  
> cast  
> decode  
> median  
> stddev  
> coalesce  
> floor  
> sign  
> abs  
> ltrim  
> substring  
> to_char 



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

Reply via email to