use testdb;

INSERT INTO TABLE biz_data_response
select method,biz_data,uid,timestamp,response
from qa_log
where method is not null and method!='N/A' and method='${hivevar:mytemp}';