phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carter Shanklin (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-1190) ASC or DESC is mandatory when ordering using WITHIN GROUP
Date Wed, 20 Aug 2014 23:07:31 GMT
Carter Shanklin created PHOENIX-1190:
----------------------------------------

             Summary: ASC or DESC is mandatory when ordering using WITHIN GROUP
                 Key: PHOENIX-1190
                 URL: https://issues.apache.org/jira/browse/PHOENIX-1190
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 5.0.0
            Reporter: Carter Shanklin
            Priority: Minor


Any reason not to default to ascending sort?

Example:

{code}
0: jdbc:phoenix:localhost:2181:/hbase-unsecur> SELECT FIRST_VALUE("value") WITHIN GROUP
(ORDER BY date) FROM first_value_table GROUP BY page_id;
Error: ERROR 603 (42P00): Syntax error. Unexpected input. Expecting "LPAREN", got "FIRST_VALUE"
at line 1, column 8. (state=42P00,code=603)

0: jdbc:phoenix:localhost:2181:/hbase-unsecur> SELECT FIRST_VALUE("value") WITHIN GROUP
(ORDER BY date ASC) FROM first_value_table GROUP BY page_id;
+-------------------------+
| null(DATE, true, value) |
+-------------------------+
| 3                       |
+-------------------------+
{code}




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

Mime
View raw message