Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB