Support Questions
Find answers, ask questions, and share your expertise

[Student Need Help] HIVE Shell logs

Highlighted

[Student Need Help] HIVE Shell logs

New Contributor

Hello everyone!

As a student working on a big data project, i wanted to ask you about purging data with HIVE SHELL.

We can for instance use that command: DELETE * FROM TableA WHERE (date < 02/02/2018)

My question is: Is it possible to make with HIVE a log file, that reports, after the query is completed :

-the date of the query
-starting hour of the query
-ending hour
-amount of data deleted
-...

Thank you very much for your help !

2 REPLIES 2
Highlighted

Re: [Student Need Help] HIVE Shell logs

@Alfred George

Try to below parameter in you shell and run the query. It will provide you all the stats.

set hive.server2.logging.operation.level=PERFORMANCE;

Hope this helps you.

Highlighted

Re: [Student Need Help] HIVE Shell logs

New Contributor

Yes you are right, Thanks for sharing this.

Don't have an account?