question Re: About SQL history query log on Hive, Impala in Support Questions

About SQL history query log on Hive, Impala

HopVH — Thu, 01 Dec 2022 07:03:03 GMT

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.

Re: About SQL history query log on Hive, Impala

AsimShaikh — Thu, 01 Dec 2022 10:17:30 GMT

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

Re: About SQL history query log on Hive, Impala

DianaTorres — Tue, 06 Dec 2022 20:48:40 GMT

@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

Re: About SQL history query log on Hive, Impala

HopVH — Fri, 09 Dec 2022 03:21:36 GMT

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ừ

của chúng ta, của chúng tôi