Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Changing table types from managed to external


Copy link to this message
-
Re: Changing table types from managed to external
Try
ALTER TABLE <table> SET TBLPROPERTIES('EXTERNAL'='TRUE');

It worked for me.

igor
decide.com

On Mon, Aug 6, 2012 at 11:08 PM, Babe Ruth <[EMAIL PROTECTED]>wrote:

>  Hello,
>   I created a managed table in HIVE when i intended for it to be external,
> is it possible for me to change the table back to external?
>
> OR do I have to copy the data to a new directory, drop the table, then
> copy it back?
>
>
> Thanks,
> George
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB