in Big Data | Hadoop by
Q:
What is RLIKE operator in Hive?

1 Answer

0 votes
by

RLIKE is an operator similar to LIKE in SQL. We use LIKE to search for string with similar text.

E.g. user_name LIKE ‘%Smith’

Hive provides RLIKE operator that can be used for  searching advanced Regular Expressions in Java.

E.g. user_name RLIKE ‘.* (Smith|Sam).*’

 

This will return user_name that has Smith or Sam in it.

Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

0 votes
asked Apr 24, 2020 in Big Data | Hadoop by Hodge
0 votes
asked Jan 12, 2020 in Big Data | Hadoop by sharadyadav1986
0 votes
asked Jan 12, 2020 in Big Data | Hadoop by sharadyadav1986
0 votes
asked Jan 12, 2020 in Big Data | Hadoop by sharadyadav1986
0 votes
asked Jan 12, 2020 in Big Data | Hadoop by sharadyadav1986
...