NOT LIKE Function in Hadoop Hive

In SQL usually the query is the following:

select * from table_name where column_name not like '%something%';

In Hive this doesn't work. Instead do the following:

select * from table_name where not (column_name like '%something%');