?

?create table test_temp as select * from test t where t.add_data >= '20100817000000';

?

?create table temp as select * from T1 where ......

drop table t1?

alter table temp rename t1;