Silent Mode Execution in Hive

It might be unpleasant to watch the full progress that is displayed on the screen after executing a query in Apache Hive. We can simply alter the configuration property “silent” to “ON” to prevent printing execution progress.

SELECT deptno, SUM(sal) FROM emp GROUP BY deptno;
The command above will use the mapreduce engine to obtain the desired data. You’ll notice that a lot of progress information is presented on the screen. To avoid it, use the command below.

hive> SET silent=on;
Execute the preceding SELECT statement. Nothing but the output of the SELECT query will be shown.

If you want Hive to print the progress then change the flag value to “false” as shown below.

hive> set silent=false;


Hope you find this post helpful.

Please do follow for more interesting updates.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s