[jira] Commented: (HADOOP-2006) Aggregate Functions in select statement

["Edward Yoon (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HADOOP-2006?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12532944 ] 

Edward Yoon commented on HADOOP-2006:
-------------------------------------

SELECT { column_name [, column_name] ... | * | expr[alias] }
    FROM table_name
    [WHERE selection_condition] 
    [GROUP BY expr [,expr] ...]
    [ORDER BY {expr|position} 
    [ASC|DESC][,expr|position}[ASC|DESC]

    [NUM_VERSIONS = version_count]
    [TIMESTAMP 'timestamp']
    [LIMIT = row_count]
    [INTO FILE 'file_name'] 

> Aggregate Functions in select statement
> ---------------------------------------
>
>                 Key: HADOOP-2006
>                 URL: https://issues.apache.org/jira/browse/HADOOP-2006
>             Project: Hadoop
>          Issue Type: Sub-task
>          Components: contrib/hbase
>    Affects Versions: 0.14.1
>            Reporter: Edward Yoon
>            Priority: Minor
>             Fix For: 0.16.0
>
>
> Aggregation functions on collections of data values: average, minimum, maximum, sum, count.
> Group rows by value of an columnfamily and apply aggregate function independently to each group of rows.
>  * <Grouping columnfamilies>  ƒ ~function_list~ (Relation)
> {code}
> select producer, avg(year) from movieLog_table group by producer
> {code}

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.