use testdb;

INSERT OVERWRITE TABLE method_count
select method,count(1) as count,max(timestamp) as timestamp
from qa_log
group by method;