hadoop-common-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Edward Yoon (JIRA)" <j...@apache.org>
Subject [jira] Issue Comment Edited: (HADOOP-2006) Aggregate Functions in select statement
Date Sun, 07 Oct 2007 02:20:50 GMT

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

udanax edited comment on HADOOP-2006 at 10/6/07 7:19 PM:
--------------------------------------------------------------

{code}
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'] 
{code}

      was (Author: udanax):
    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.


Mime
View raw message