About SQL history query log on Hive, Impala

[#1]

Hello.
I would like to help about check the history log of sql query command of each account on Impala and Hive. 
I have been check on `/var/log/hive` (the Hive log) but not expected.
Can you figure out for me where is the log save on ? And any have another way to check it ?.

Thank you for you help.

[#2 · Accepted solution]

Hi @HopVH  ,

For impala queries you can check under Impala>Queries> Query profile

For Hive it should have generated YARN application id you can trace its logs by navigating to JHS or with

yarn logs -applicationId application_xxxx_xx

Regards,

Asim

[#3]

@HopVH Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks

[#4]

Thank you very much for the support. I see the log I want.
I also want to ask about, Any have a way to create a workflow with Oozie editor to send these logs to someone? For everyday

ˈou(ə)r

của chúng tôi

---

đại từ

của chúng ta, của chúng tôi