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


+
Santosh Achhra 2013-01-07, 11:52
+
Jarek Jarcec Cecho 2013-01-07, 12:23
+
Ranjith 2013-01-08, 03:27
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