1.原数据全是null的情况(能清空)
hive> select * from testNull;
OK
NULL
NULL
NULL
Time taken: 0.08 seconds, Fetched: 3 row(s)
hive> insert overwrite table testNull select * from testNull where 1=0;
hive> select * from testNull;
OK
Time taken: 0.089 seconds
2.原数据全正常的情况(能清空)
hive> insert into testNull values(1),(2),(3);
hive> select * from testNull;
OK
1
2
3
Time taken: 0.081 seconds, Fetched: 3 row(s)
hive> insert overwrite table testNull select * from testNull where 1=0;
hive> select * from testNull;
OK
Time taken: 0.067 seconds
3.原数据为null和正常数据混合(能清空)
hive> insert into testNull values(1),(null),(3);
hive> select * from testNull;
OK
1
NULL
3
Time taken: 0.071 seconds, Fetched: 3 row(s)
hive> insert overwrite table testNull select * from testNull where 1=0;
hive> select * from testNull;
OK
Time taken: 0.078 seconds