HIVE: no column names in output

Question

This is how it typical looks

I use PuTTY for running Hive queries. Query results have no column names.

Setting doesn't have obvious check-box for "add column names", not to me anyways...

Can you help please?

Thanks

More details: Issue description

Answer 1

Execute this command once in your hive session:

set hive.cli.print.header=true;

Alternatively add this command in .hiverc file in your home directory. See this for reference: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Cli#LanguageManualCli-ThehivercFile