use testdb;

INSERT OVERWRITE TABLE biz_data_response_debug
select method,biz_data,uid,timestamp,response
from qa_log_debug
where method is not null and method!='N/A';