Issue: Hive-> Create Database-> provide database storage location path option
1.While Creating database through ADS, currently no option is provided to user, to select the Storage Location path of the database and enter the DBPROPERTIES values.
While creating table , in storage tab, provision for entering Table Storage Location and Table Properties is Provided.
Similar kind of provision should be provided for Database also.
a] Following script can be used to Create Database and store it at particular location.
CREATE DATABASE <DATABASENAME> LOCATION <PATH>
eg.
CREATE DATABASE financials LOCATION '/home/hduser/databasetest'
b] Following script can be used to associate key-value properties with the database
Issue #10019 |
Closed |
Completion |
No due date |
No fixed build |
No time estimate |
2 issue links |
relates to #12183
Issue #12183Impala- Create Database-> provide database storage location path option |
relates to #10051
Issue #10051Create Database DDL options for Hive |