hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xuefu Zhang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-5607) Hive fails to parse the "%" (mod) sign after brackets.
Date Fri, 07 Mar 2014 20:26:43 GMT

    [ 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)

Mime
View raw message