Can we use LIKE operator in Hive

Question

Can anyone suggest we can use LIKE operator in hive? If yes then how?

Answer 1

Hey,

Yes, Hive supports LIKE operator, but it doesn’t support multi-value LIKE queries like below:

SELECT * FROM user_table WHERE first_name LIKE ANY ( ‘root~%’ , ‘user~%’ );

So you can easily use LIKE operator in Hive as and when you require. Also, when you have to use a multi-like operator, break it so that it can work in Hive, as shown below:

WHERE table2.product LIKE concat(‘%’, table1.brand, ‘%’)

Comments

Hi ,

I need to pass values directly from table, instead of passing column names, is that possible inhive?

WHERE table2.product LIKE concat(‘%’, table1.brand, ‘%’)

Instead of

WHERE table2.product LIKE concat(‘%’, select table.product from tablename table, ‘%’)

---

Hi

Did you try passing values directly? Try and see what happens.