How to set column headers in Hive

To print column headers along with the output, the following hive conf property should be set to true before executing the query.

set hive.cli.print.header=true;

if you wants this property to be ON permanently, then set this property hive.cli.print.header to true in hive-default.xml or hive-site.xml.