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" <hashut...@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 < > >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 > >> > >