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