Show Databases In Hive. The database creates in a default location of the hive warehouse. Show tables can display tables with names matching the optional regular expression.
Among several hive ddl commands here i will be covering the most commonly used ddl commands. You can use hive cli property to show the existing database on the hive cli. Create database schema table view function index.
Hiveql ddl statements are documented here including.
The describe database statement in hive shows the name of database in hive its comment if set and its location on the file system. Create database schema table view function index. The database creates in a default location of the hive warehouse. The in clause is used to provide the database if it is not the current.
