1. Categories >> Software >> Big Data >> Hadoop >> Apache Hive
  2. Suggest New Category

What is the difference between like and rlike operators in hive?

Question Posted / aishwerya


What is the difference between like and rlike operators in hive?..

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

More Apache Hive Interview Questions

What database are supported by Hive?

1 Answers  

What is bag?

1 Answers  

In Hive, how can you enable buckets?

1 Answers  

What happened after creating a table in hive ?

1 Answers  

Can we run unix shell commands from hive? Give example?

1 Answers  

Can you overwrite Hadoop MapReduce configuration in Hive?

1 Answers  

What is dynamic partitioning and when is it used?

1 Answers  

Explain bucketing in Hive?

1 Answers  

Can we load data into a view?

1 Answers  

what are the different modes of Hive?

1 Answers  

What is the use of explode in Hive?

1 Answers  

How can you configure remote metastore mode in Hive?

1 Answers  

For more Apache Hive Interview Questions Click Here
Categories