You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-dev@hadoop.apache.org by "Edward Yoon (JIRA)" <ji...@apache.org> on 2007/10/07 04:20:50 UTC
[jira] Issue Comment Edited: (HADOOP-2006) Aggregate Functions in
select statement
[ 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.