#10051: Create Database DDL options for Hive

tariqrahiman reported 2013-09-18T18:14:58Z · last modified 2014-04-29T17:32:50Z

Create Database DDL options for Hive

Dev	JennyNishimura
QA	tariqrahiman

Priority	Minor
Complexity	Unknown

Component	Hive
Version	Future - .9

Version: 14.0.0-rc-21

Build #: 33999

Build Date: 2013-Sep-16 10:49:46 AM

1. No provision to add comments in Database

2. No place to add location

3. No place to add Owner in the WITH clause

If i have a database as below, when I script it back all the comments and location information is missing

CREATE DATABASE hadoop

comment 'hello'

location 'hdfs://usrv70:54310/user/hive/warehouse/test.db/erd_1'

Complete Create Database ddl is below:

CREATE DATABASE

CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] database_name
     [COMMENT database_comment]
     [LOCATION hdfs_path]
     [WITH DBPROPERTIES] (property_name=property_value, ...)];

Take a look at postgreSQL create database UI.

1 attachment

Screen Shot 2013-09-18 at 11.15.25 AM.png

2013-09-18T18:14:58Z

18 KB

All Comments (0) Change History

Search Tips

Aqua Data Studio / nhilam

Create Database DDL options for Hive

CREATE DATABASE

1 attachment

Issue #10051

Completion

1 issue link

Issue #10019

Search Tips

Aqua Data Studio / nhilam

Title

Create Database DDL options for Hive

CREATE DATABASE

1 attachment

Issue #10051

Completion

1 issue link

Issue #10019