hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alan Gates <alanfga...@gmail.com>
Subject Re: question on create database
Date Thu, 02 Apr 2015 15:29:23 GMT
When someone creates a table in your 'abc' database it should by default 
be in '/my/preferred/directory/_tablename_'.  However, users can specify 
locations for their tables which may not be in that directory.  AFAIK 
there's no way to prevent that.

Alan.

> Chen Song <mailto:chen.song.82@gmail.com>
> April 2, 2015 at 8:15
> I have a dumb question on DDL statement "create database"
>
> Say if I create a database
> |CREATE| |DATABASE| abc
> |LOCATION||'/my/preferred/directory'||;|
> When later on someone needs to create a table in this database, is 
> there a way to force the location of the table to be under 
> /my/preferred/directory?
>
> I searched around but could not find a way to enforce this.
>
>
> -- 
> Chen Song
>

Mime
View raw message