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