[
https://issues.apache.org/jira/browse/HIVE-5607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13924361#comment-13924361
]
Prasad Mujumdar commented on HIVE-5607:
---------------------------------------
[~xuefuz] I think that makes sense. You can also argue that there's a
workaround to (by simply removing the parenthesis) for the possible
incompatibility this fix will introduce. However there's no work around for
regression introduced by the HIVE-1367 patch.
You might want to update the syntax in LanguageManual under the
[sorttBy|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+SortBy]
section once the patch committed. It would be a good idea to mention the
versions when the behavior changed for application migration.
+1
> 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)
