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