You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Carter Shanklin (JIRA)" <ji...@apache.org> on 2014/08/21 01:07:31 UTC
[jira] [Created] (PHOENIX-1190) ASC or DESC is mandatory when
ordering using WITHIN GROUP
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)