What is the difference between like and rlike operators in hive?
- 1 Answers
- 859 Views
- I also Faced
- E-Mail Answers
Answer Posted / Neeraj Mishra
The LIKE operator in Hive performs pattern matching on the left side of the comparison. It uses a wildcard character '%' for partial matches and '_' for exact single character matches. On the other hand, the RLIKE operator is case-insensitive regular expression matching, which allows more complex pattern matching using regex.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different types of tables available in Hive?
What is the stable version of Hive ?
Can We Change settings within Hive Session? If Yes, How?
When to choose "External Table" in Hive?
What is a Hive variable? What for we use it?
Where does the data of a Hive table gets stored?
When we are using queries instead of scripting?
When to use explode in Hive?
How can I delete the above index named index_bonuspay?
How to skip header rows from a table in Hive?
