Hive training : Spark Databox

Hive initialization file .hiverc Print

Created by: spark databox

Modified on: Mon, 29 Jul, 2019 at 11:36 PM

Does the .hiverc execute globally or is there a .hiverc file for each user?

I would like to set the folllowing variables for my Hive sessions

set hive.cli.print.current.db=true; --print current database in prompt
set hive.cli.print.header=true; --print column headers in query’s

if there is no .hiverc for each user is there a way to execute a script from the hive> prompt?

Solution :

.hiverc is user specific. For global, you have to use hive-site.xml.

You can safely set it for your user .hiverc.

Also you can launch using -hiveconf like this hive -hiveconf hive.cli.print.current.db=true

Spark is the author of this solution article.

Did you find it helpful? Yes No

Hive initialization file .hiverc Print