Is there a Hive equivalent of SQL "not like"

syntax hive sql-like
CMaury picture CMaury · Apr 11, 2011 · Viewed 60.4k times · Source

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

HAL9000 picture HAL9000 · Apr 14, 2011

Try this:

Where Not (Col_Name like '%whatever%')

also works with rlike:

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

Related questions

Hive: writing column headers to local file?

Hive documentation lacking again: I'd like to write the results of a query to a local file as well as the names of the columns. Does Hive support this? Insert overwrite local directory 'tmp/blah.blah' select * from table_name; …

Read More
How to concatenate string variables in Bash

In PHP, strings are concatenated together as follows: $foo = "Hello"; $foo .= " World"; Here, $foo becomes "Hello World". How is this accomplished in Bash?

Read More
Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (…

Read More