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
Thank you Jarcec and Ranjith for your inputs.

Good wishes,always !
Santosh
On Tue, Jan 8, 2013 at 11:27 AM, Ranjith <[EMAIL PROTECTED]>wrote:

> 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