Create a database in Hadoop Metastore | Using Cloudera Hue
Hello Everyone, This article is part of Cloudera Hue tutorial series. In this article we will learn:-
-
Create database using Cloudera Hue – With Default Storage Location.
-
Create Database using Cloudera Hue – With External storage location.
Create Database using Cloudera Hue – With Default storage location.
- Open Hue page.
- Click on “Data Browser” and select “Metastore Manager” from drop down list.
This will redirect you to “Metastore Manager” page. Learn more about Metastore Manager. - Click on “Databases” to see all available database name. By default, only one database “default” will show.
- Click on “+” sign in right hand to create new database.
- Enter Database name and description and click “next“.
My database name is “testhue” and description is optional. - Here you can able to see as by default, /user/hive/warehouse/database_name is the location name.
- And then, Click on “create database“.
You can check created database using Step 4.
Create Database using Cloudera Hue – With External storage location.
- Open Hue page.
- Click on “Data Browser” and select “Metastore Manager” from drop down list.
This will redirect you to “Metastore Manager” page. Learn more about Metastore Manager. - Click on “Databases” to see all available database name. By default, only one database “default” will show.
- Click on “+” sign in right hand to create new database.
- Enter Database name and description and click “next“.
My database name is “testhue” and description is optional. - In next page, If you want to specify any specific external location then unchecked the “check box” and then enter the “external location” name.
- And then, Click on “create database“.
You can check created database using Step 4.
I hope you like this short article, for more articles about Cloudera / Big Data, please visit my website and feel free to post your comments below.
1 Comment
Nice post. I learn something new and challenging on sites I stumbleupon on a daily basis.
It will always be interesting to read content from other authors and use something from
other sites.