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;


No comments:

Post a Comment

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...