Is there a Hive equivalent of SQL "not like"

Question

While Hive supports positive like queries: ex.

select * from table_name where column_name like 'root~%';

Hive Does not support negative like queries: ex.

select * from table_name where column_name not like 'root~%';

Does anyone know an equivalent solution that Hive does support?

Answer 1

Try this:

Where Not (Col_Name like '%whatever%') 

also works with rlike:

Where Not (Col_Name rlike '.*whatever.*')