Showing posts with label show database name which is in use; show database in which we are currently working; database name in hive prompt; hive to show database name. Show all posts
Showing posts with label show database name which is in use; show database in which we are currently working; database name in hive prompt; hive to show database name. Show all posts

Saturday, August 15, 2020

Showing the database name in Hive Prompt

Unlike in traditional RDBMS systems, it is difficult to know in which database we are currently working in Hive due to its command-line interface. It always shows the hive prompt.

However, there is a trick!

Set a property to print the current database as part of the prompt to know the database which you are currently in.

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


Big Data & SQL

Hi Everybody, Please do visit my new blog that has much more information about Big Data and SQL. The site covers big data and almost all the...