[ 
https://issues.apache.org/jira/browse/HIVE-5607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Xuefu Zhang updated HIVE-5607:
------------------------------

       Resolution: Fixed
    Fix Version/s: 0.14.0
     Release Note: 
>From 0.10.0 to 0.13.0, the following syntax for order by is allowed (though 
>the doc doesn't specify):

select * from table order by (expr1, exp2);

>From 0.14, the above syntax is illegal. Instead, the following should be used:

select * from table order by expr1, exp2;

           Status: Resolved  (was: Patch Available)

Patch committed to trunk. Thanks Prasad for the review.

> Hive fails to parse the "%" (mod) sign after brackets.
> ------------------------------------------------------
>
>                 Key: HIVE-5607
>                 URL: https://issues.apache.org/jira/browse/HIVE-5607
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.10.0
>            Reporter: dima machlin
>            Assignee: Xuefu Zhang
>            Priority: Minor
>             Fix For: 0.14.0
>
>         Attachments: HIVE-5607.1.patch, HIVE-5607.patch
>
>
> the scenario :
> create table t(a int);
> select * from t order by (a)%7;
> will fail with the following exception :
> FAILED: ParseException line 1:28 mismatched input '%' expecting EOF near ')'
> I must mention that this *does* work in 0.7.1 and doesn't work in 0.10



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

Reply via email to