Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

About SQL history query log on Hive, Impala

New Contributor

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.

1 ACCEPTED SOLUTION

Rising Star

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 solution in original post

3 REPLIES 3

Rising Star

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

Community Manager

@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


Regards,

Diana Torres,
Community Moderator


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community:

New Contributor

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.