CODEWITHSUNDEEP
hivehiveql
P. Camilleri
P. Camilleri

Reputation: 13218

Always print header before output in Hive QL

I run lots of Hive queries everyday, and I have to write SET hive.cli.print.header = TRUE; at the beginning of each one every time. Is there a config file I could edit so printing the header would be the default behavior ?

If it is not possible, is there a reason for this ?

Upvotes: 4

Views: 332

Answers (1)

lhoworko
lhoworko

Reputation: 1191

Take a look at this thread

HIve: writing column headers to local file?

One answer says to put the set statement in .hiverc in your home directory.

Upvotes: 2

Related Questions