How to identify which database the user is using in hive CLI ?

Question

Is there any way to identify which database the user is using while using the command line interface ?

Answer 1

To know which database user in

hive> set hive.cli.print.current.db=true

or start hive with

hive --hiveconf hive.cli.print.current.db=true

then the prompt will display

hive (db_name)>

Answer 2

There are two ways to know the current database. One temporary in cli and second one is persistently.

1) in CLI just enter this command: set hive.cli.print.current.db=true;

2) In hive-site.xml paste this code:

    <property>
    <name>hive.cli.print.current.db</name>
    <value>true</value>
    </property>
     

 

In second scenario, you can automatically display the Hive dabatabase name when you open terminal.