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
Sqoop >> mail # user >> Sqoop and creating external table


Copy link to this message
-
Re: Sqoop and creating external table
Another option is to use the .hiverc file and set the property to make it external. This will default the tables to being external. It is a hack but you ca avoid the alter table command.

Thanks,
Ranjith

On Jan 7, 2013, at 6:23 AM, Jarek Jarcec Cecho <[EMAIL PROTECTED]> wrote:

> Hi Santosh,
> Sqoop is not supporting HIVE external tables at the moment.
>
> Feel free to file a JIRA [1] to add such support.
>
> Jarcec
>
> Links:
> 1: https://issues.apache.org/jira/browse/SQOOP
>
> On Mon, Jan 07, 2013 at 07:52:17PM +0800, Santosh Achhra wrote:
>> Hello,
>>
>> Is creating external tables not supported in Sqoop ? When I execute sqoop
>> import command with --hiveimport option, by default a managed tables is
>> getting created, then I have to fire Alter command to change table
>> properties to change table to external table
>>
>> Good wishes,always !
>> Santosh
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