- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
About SQL history query log on Hive, Impala
- Labels:
-
Apache Hive
-
Apache Impala
Created on 11-30-2022 11:01 PM - edited 11-30-2022 11:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created 12-01-2022 02:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created 12-01-2022 02:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created 12-06-2022 12:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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:
Created on 12-08-2022 07:18 PM - edited 12-08-2022 07:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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