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 ?

Accepted Answer

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)>
```

Solution