[jira] [Created] (PHOENIX-1190) ASC or DESC is mandatory when ordering using WITHIN GROUP

[Carter Shanklin (JIRA)]

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)