[HIVE-5607] Hive fails to parse the "%" (mod) sign after brackets. - ASF JIRA

XML

Word

Printable

JSON

Release Note:

Hide
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;

Show
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;

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

relates to

HIVE-12474 ORDER BY should handle column refs in parantheses