Hive : Create database in different folder

When database is created in Hive, its usually saved in default folder  /user/hive/warehouse/yourdabase.db

If alternate location is needed, then

create database <yourdatabase> location  ‘/db/path/yourdatabase.db’    [single quotes]

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.