use testdb;

INSERT OVERWRITE TABLE biz_data_count
select method,biz_data,count(1) as count,max(timestamp) as timestamp
from qa_log
where method is not null and method!='N/A' and method='${hivevar:method}'
group by method,biz_data;