hadoop hive 檢索字串

檢索不包含某字元

Try this: Where Not (Col_Name like '%whatever%')
also works with rlike:
Where Not (Col_Name rlike '.whatever.')