use testdb;

INSERT OVERWRITE TABLE huo_dong_ru_kou_debug
select method,biz_data,uid,timestamp,response
from qa_log_debug
where method is not null and method!='N/A'
and (method='com.lejane.handler.common.sidebar.operate.query.new.v3' or method='com.lejane.handler.common.sidebar.operate.query.list')
and timestamp>'${hivevar:myTimestamp}';