× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
anilkalshetti reported 2013-09-17T06:40:18Z  · SachinPrakash last modified 2014-04-29T17:32:10Z

Hive -> Create Database-> provide database storage location path option


Dev
Jenny Nishimura
JennyNishimura
QA
Tariq Rahiman
tariqrahiman
Priority Minor
Complexity Unknown
Component Hive
Version Future - .9
Aqua Data Studio 14.0.0-rc-20
Operating Environment: Windows 8 (6.2, x86)
Database :Apache Hive 0.11.0

 

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

CREATE DATABASE financials WITH DBPROPERTIES ('creator' = anil', 'date' = '2013-01-02')

 

Issue #10019

Closed
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017