Created: (HADOOP-2006) Aggregate Functions in select statement

Aggregate Functions in select statement
---------------------------------------

                 Key: HADOOP-2006
                 URL: htt
ps://issues.apache.org/jira/browse/HADOOP-2006
             Project: Hadoop
          Issue Type: Sub-task
            Reporter: Edward Yoon




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

     [
HTTPS://ISSUES.APACHE.ORG/JIRA/BROWSE/HADOOP-2006?PAGE=COM.A
TLASSIAN.JIRA.PLUGIN.SYSTEM.ISSUETABPANELS:ALL-TABPANEL ]

EDWARD YOON UPDATED HADOOP-2006:
--------------------------------

          COMPONENT/S: CONTRIB/HBASE
        FIX VERSION/S: 0.16.0
             PRIORITY: MINOR  (WAS: MAJOR)
          DESCRIPTION: 
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)


SELECT PRODUCER, AVG(YEAR) FROM MOVIELOG_TABLE GROUP BY
PRODUCER

    AFFECTS VERSION/S: 0.14.1

UPDATE DESCRIPTION.

> 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)
> 
> SELECT PRODUCER, AVG(YEAR) FROM MOVIELOG_TABLE GROUP BY
PRODUCER
> 

-- 
THIS MESSAGE IS AUTOMATICALLY GENERATED BY JIRA.
-
YOU CAN REPLY TO THIS EMAIL TO ADD A COMMENT TO THE ISSUE
ONLINE.

    [
HTTPS://ISSUES.APACHE.ORG/JIRA/BROWSE/HADOOP-2006?PAGE=COM.A
TLASSIAN.JIRA.PLUGIN.SYSTEM.ISSUETABPANELS:COMMENT-TABPANEL#
ACTION_12532944 ] 

UDANAX EDITED COMMENT ON HADOOP-2006 AT 10/6/07 7:19 PM:
------------------------------------------------------------
--


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'] 


      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)
> 
> SELECT PRODUCER, AVG(YEAR) FROM MOVIELOG_TABLE GROUP BY
PRODUCER
> 

-- 
THIS MESSAGE IS AUTOMATICALLY GENERATED BY JIRA.
-
YOU CAN REPLY TO THIS EMAIL TO ADD A COMMENT TO THE ISSUE
ONLINE.

    [
HTTPS://ISSUES.APACHE.ORG/JIRA/BROWSE/HADOOP-2006?PAGE=COM.A
TLASSIAN.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)
> 
> SELECT PRODUCER, AVG(YEAR) FROM MOVIELOG_TABLE GROUP BY
PRODUCER
> 

-- 
THIS MESSAGE IS AUTOMATICALLY GENERATED BY JIRA.
-
YOU CAN REPLY TO THIS EMAIL TO ADD A COMMENT TO THE ISSUE
ONLINE.