use testdb;

INSERT OVERWRITE TABLE method_count_debug
select method,count(1) as count,max(timestamp) as timestamp
from (select * from qa_log_debug where method is not null and method!='N/A' and timestamp>${hivevar:myTimestamp}) my_debug
group by method;