tc_response_debug.hql 4.83 KB
use testdb;

INSERT OVERWRITE TABLE tc_response_debug
select method,biz_data,uid,timestamp,response
from qa_log_debug
where method is not null and method!='N/A'
and (method='com.ai.handler.card.list'
    or method='com.ai.handler.card.tips.query'
    or method='com.ai.handler.card.check'
    or method='com.ai.handler.card.agent.location'
    or method='com.ai.handler.supervise.tips'
    or method='com.ai.handler.card.discuss.list'
    or method='com.ai.handler.card.reply.list'
    or method='com.ai.handler.card.discuss.save'
    or method='com.ai.handler.supervise.code.query'
    or method='com.ai.handler.supervise.code.search'
    or method='com.ai.handler.card.share.save'
    or method='com.ai.handler.card.share.reply.save'
    or method='com.ai.handler.card.share.info'
    or method='com.ai.handler.card.detail.query'
    or method='com.ai.handler.card.like.save'
    or method='com.ai.handler.card.discuss.like.save'
    or method='com.ai.handler.plan.info'
    or method='com.ai.handler.plan.item.list'
    or method='com.ai.handler.plan.card.query.v2'
    or method='com.ai.handler.plan.supervise.type.card.query'
    or method='com.ai.handler.plan.supervise.manage.card.query'
    or method='com.insurance.handler.insurance.config'
    or method='com.ai.handler.ugc.link.query'
    or method='com.ai.handler.ugc.save'
    or method='com.ai.handler.ugc.query'
    or method='com.ai.handler.ugc.delete'
    or method='com.ai.handler.card.recommend.query'
    or method='com.ai.handler.card.query'
    or method='com.ai.handler.card.same.query'
    or method='com.ai.handler.ugc.detail.list'
    or method='com.ai.handler.card.msg.query'
    or method='com.ai.handler.card.like.query'
    or method='com.ai.handler.card.msg.read'
    or method='com.ai.handler.supervise.detail.list.query'
    or method='com.insurance.handler.user.agent.info.update'
    or method='com.lejane.act.handler.user.combine.award.list.query'
    or method='com.borui.health.user.account'
    or method='com.borui.health.user.accounthistories'
    or method='com.insurance.handler.user.ask.feedback.count.query'
    or method='com.insurance.handler.ask.feedback.question.upload'
    or method='com.insurance.handler.user.ask.feedback.answer.query'
    or method='com.insurance.handler.user.ask.feedback.cancel.query'
    or method='com.insurance.handler.user.assistant.banner.query'
    or method='com.insurance.handler.ask.question.query'
    or method='com.insurance.handler.ask.config.question.page.query'
    or method='com.insurance.handler.user.ask.query'
    or method='com.insurance.handler.user.ask.like'
    or method='com.insurance.handler.user.main.banner.query'
    or method='com.insurance.handler.user.agent.total.info'
    or method='com.insurance.handler.user.banner.type.query'
    or method='com.lejane.act.handler.scan.sign.apply.act.list.query'
    or method='com.insurance.handler.user.goal.info.query'
    or method='com.ai.handler.plan.bubble.info'
    or method='com.ai.handler.plan.talk.type.list'
    or method='com.ai.handler.plan.talk.list'
    or method='com.ai.handler.plan.talk.like'
    or method='com.ai.handler.plan.talk.more'
    or method='com.ai.handler.plan.talk.answer.save'
    or method='com.ai.handler.plan.talk.answer.list'
    or method='com.insurance.handler.user.visit.share.save'
    or method='com.insurance.handler.user.visit.share.notice'
    or method='com.lejane.act.handler.act.share.query'
    or method='com.lejane.act.handler.act.share.add'
    or method='com.ai.handler.plan.card.notice.query'
    or method='com.ai.handler.plan.sms.send.query'
    or method='com.insurance.handler.user.rights.invite.single'
    or method='com.ai.handler.agent.info'
    or method='com.ai.handler.agent.plan.progress'
    or method='com.insurance.handler.user.version.save'
    or method='com.insurance.handler.user.assistant.article.query'
    or method='com.insurance.handler.user.tool.query'
    or method='com.insurance.handler.user.tool.choose'
    or method='com.ai.handler.user.assistant.rank.tab.query'
    or method='com.ai.handler.user.assistant.rank.list.query'
    or method='com.insurance.handler.ask.question.change'
    or method='com.insurance.handler.user.agent.tasknotice.query'
    or method='com.ai.handler.user.plan.item.award.query'
    or method='com.lejane.act.handler.user.plan.award.query'
    or method='com.lejane.act.handler.user.award.data.query'
    or method='com.ai.handler.supervise.user.query'
    or method='com.ai.handler.supervise.query'
    or method='com.ai.handler.supervise.info.save'
    or method='com.ai.handler.supervise.info.check'
    or method='com.ai.handler.supervise.info.list.query'
    or method='com.ai.handler.supervise.operation.list.query'
    or method='com.ai.handler.supervise.info.cancel'
    or method='com.ai.handler.supervise.tab.type.query'
    or method='com.ai.handler.supervise.msg.query'
    or method='com.ai.handler.supervise.msg.process');