insert overwrite table table_name partition(key='111')
select col
,col2
,col3
from table_name where key='111' and col <> '2311'
尼玛,不等于的null值不参与比较。
得这么玩
insert overwrite table table_name partition(key='111')
select col
,col2
,col3
from table_name where key='111' and (col <> '2311' or col is null or col ='' );