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.
Example:
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.
Big Data and SQL 