Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Operators && and || do not work


Copy link to this message
-
Re: Operators && and || do not work
Yes, should not be because of HIVE-2439. Even in hive-0.7, it is not
working, not sure if it worked at any version. Will create a jira to track.

Thanks
Amareshwari
On Fri, Sep 20, 2013 at 6:03 AM, Thiruvel Thirumoolan <
[EMAIL PROTECTED]> wrote:

> Hi Amareshwari/Ashutosh,
>
> Ashutosh is probably right, I doubt if this ever worked. I couldn't find a
> clientpositive test case which uses && or ||.
>
> I also modified a unit test case in Hive9 to use "&&" instead of "AND" and
> that failed with the same error Amareshwari saw. Hive9 does not have
> HIVE-2439.
>
> -Thiruvel
>
> On 9/19/13 7:21 AM, "Ashutosh Chauhan" <[EMAIL PROTECTED]> wrote:
>
> >I have not tested it on historical versions, so don't know on which
> >versions it used to work (if ever), but possibly antlr upgrade [1] may
> >have
> >impacted this.
> >
> >[1] : https://issues.apache.org/jira/browse/HIVE-2439
> >
> >Ashutosh
> >
> >
> >On Thu, Sep 19, 2013 at 4:52 AM, amareshwari sriramdasu <
> >[EMAIL PROTECTED]> wrote:
> >
> >> Hello,
> >>
> >> Though the documentation
> >> https://cwiki.apache.org/Hive/languagemanual-udf.html says they are
> same
> >> as
> >> AND and OR, they do not even get parsed. User gets parsing when they are
> >> used. Was that intentional or is it a regression?
> >>
> >> hive> select key from src where key=a || key =b;
> >> FAILED: Parse Error: line 1:33 cannot recognize input near '|' 'key'
> >>'=' in
> >> expression specification
> >>
> >> hive> select key from src where key=a && key =b;
> >> FAILED: Parse Error: line 1:33 cannot recognize input near '&' 'key'
> >>'=' in
> >> expression specification
> >>
> >> Thanks
> >> Amareshwari
> >>
>
>