Skip to main content
HopVH
HopVH
Silver ⭐️
December 1, 2022
Solved

About SQL history query log on Hive, Impala

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.

AsimShaikh
AsimShaikhAnswer
Gold ⭐️
December 1, 2022

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

View in thread

3 replies

AsimShaikh
Gold ⭐️
AsimShaikhAnswer
Gold ⭐️
December 1, 2022

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

Translate
    DianaTorres
    Community Manager
    DianaTorres
    Community Manager
    December 6, 2022

    @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

    Translate
    Regards, Diana Torres, Senior Community Moderator
      HopVH
      HopVHAuthor
      Silver ⭐️
      December 9, 2022

      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

      Translate
      Terms & ConditionsAccessibility statement