max_timestamp.hql 153 Bytes
use testdb;

INSERT OVERWRITE TABLE project_config_debug
select max(timestamp) as timestamp
from qa_log_debug
where method is not null and method!='N/A';