Using not equal symbol in hive query

Question

I need to use '!=' symbol in my hive query with partitions. I tried something like ``` from sample_table insert overwrite table sample1 partition (src='a') select * where act=10 insert overwrite table sample1 partition (src!='a') select * where act=20 ``` But it is showing error at '!=' symbol. How can i replace !=

Accepted Answer

Try to use rlike/regex function in hive to specify condition.

I think you can also use not operator `<>` not `!=`

Using not equal symbol in hive query

Solution

Problem