[
https://issues.apache.org/jira/browse/HIVE-5607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13924294#comment-13924294
]
Xuefu Zhang commented on HIVE-5607:
-----------------------------------
Thanks, [~prasadm]. Your concern is valid. However, I think we should be okay
because:
1. HIVE-1367 broke the backward compatibility in the first place. The current
JIRA is only to revert that regression.
2. Syntactically, the current JIRA restores to align with standard SQL.
3. The regression introduced by HIVE-1367 prevents any expression in the list
from having parenthesis. This seems a big limitation.
>From this, personally I think the restoration should proceed. However, I'm
>open to further discussions.
> 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
> 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)
