Issue:  Impala-  Create Database-> provide database storage location path option 

 

Steps to reproduce:

Start  Cloudera Quickstart VM CDH5                    [or you can use other Cloudera version ] 
 

1.While Creating database through ADS Visual editor, currently no option is provided to user, to select the Storage Location path of the database.

2. Following script can be used to Create Database and store it at particular location.

 CREATE DATABASE <DATABASENAME> LOCATION <PATH>

eg.

CREATE DATABASE financials  LOCATION '/user/hive/'
GO
//user has created directory '/user/hive' in OS.