Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
> >>
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB