Hive

Hive

!= 和 <> 和 is not null

//不会查出字段是null的数据
SELECT * FROM table WHERE IsDeleted <> true AND name LIKE '%%' ;
SELECT * FROM table WHERE IsDeleted != true AND Name LIKE '%%';//可以查出字段是null的数据
SELECT * FROM table WHERE IsDeleted is not true AND name LIKE '%%' ;//会把有内容的和内容为空的都查出来
select * from table where a is not null;
//只会把有内容的查出来
select * from table where a != ''/"";