Show Databases In Hive. Alter database schema table view. Unfortunately there is no way to know which database is in use currently selected in hive shell.
Unfortunately there is no way to know which database is in use currently selected in hive shell. Hive ddl database commands. Msck repair table or alter table recover partitions show databases schemas tables.
Show tables can display tables with names matching the optional regular expression.
There is no command to show the current database but this property will keep printing the current database name as suffix in the command line prompt as shown in below examples. One option is to always use use database command to be sure every time you need to check the working database. Hiveql ddl statements are documented here including. Among several hive ddl commands here i will be covering the most commonly used ddl commands.
