You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by amareshwari sriramdasu <am...@gmail.com> on 2013/09/19 13:52:17 UTC
Operators && and || do not work
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
Re: Operators && and || do not work
Posted by amareshwari sriramdasu <am...@gmail.com>.
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 <
thiruvel@yahoo-inc.com> 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" <ha...@apache.org> 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 <
> >amareshwari@gmail.com> 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
> >>
>
>
Re: Operators && and || do not work
Posted by amareshwari sriramdasu <am...@gmail.com>.
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 <
thiruvel@yahoo-inc.com> 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" <ha...@apache.org> 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 <
> >amareshwari@gmail.com> 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
> >>
>
>
Re: Operators && and || do not work
Posted by Thiruvel Thirumoolan <th...@yahoo-inc.com>.
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" <ha...@apache.org> 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 <
>amareshwari@gmail.com> 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
>>
Re: Operators && and || do not work
Posted by Thiruvel Thirumoolan <th...@yahoo-inc.com>.
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" <ha...@apache.org> 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 <
>amareshwari@gmail.com> 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
>>
Re: Operators && and || do not work
Posted by Ashutosh Chauhan <ha...@apache.org>.
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 <
amareshwari@gmail.com> 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
>
Re: Operators && and || do not work
Posted by Ashutosh Chauhan <ha...@apache.org>.
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 <
amareshwari@gmail.com> 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
>