What is the difference between LIKE and RLIKE operators in Hive?

1.	What is the difference between LIKE and RLIKE operators in Hive?
Answer» The LIKE operator behaves the same way as the regular SQL operators used in select queries. Example − street_name like ‘%Chi’ But the RLIKE operator uses more advance regular expressions which are available in java Example − street_name RLIKE ‘.(Chi\|Oho).’ which will select any word which has either chi or oho in it.

Answer»

The LIKE operator behaves the same way as the regular SQL operators used in select queries. Example −

street_name like ‘%Chi’

But the RLIKE operator uses more advance regular expressions which are available in java

Example − street_name RLIKE ‘.*(Chi|Oho).*’ which will select any word which has either chi or oho in it.

Discussion