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 < thiru...@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" 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 < > >amareshw...@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
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" 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 < >amareshw...@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
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 < amareshw...@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 >
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