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 selective export


+
Κωνσταντίνος Αρετάκης 2013-06-23, 16:00
+
Jarek Jarcec Cecho 2013-06-23, 16:18
+
Κωνσταντίνος Αρετάκης 2013-06-23, 16:32
Copy link to this message
-
Re: sqoop selective export
It seems that we do not have much examples there yet, so just fill the "sql" parameter for export with your insert query, e.g. something like:

  INSERT INTO table VALUES(?, ?, ?...)

Jarcec

On Sun, Jun 23, 2013 at 07:32:03PM +0300, Κωνσταντίνος Αρετάκης wrote:
> Thank you so much!!!
>
> So I have to refer at Sqoop2.
> At Sqoop2 documentation though I don't see any example invocations of the
> export operation with the custom INSERT statement. Is there any resource
> with examples invocations?
>
>
> On Sun, Jun 23, 2013 at 7:18 PM, Jarek Jarcec Cecho <[EMAIL PROTECTED]>wrote:
>
> > Hi sir,
> > Sqoop 1 do not have option to specify your custom INSERT statement during
> > export operation. We have however implemented this feature in Sqoop 2.
> >
> > Jarcec
> >
> > On Sun, Jun 23, 2013 at 07:00:19PM +0300, Κωνσταντίνος Αρετάκης wrote:
> > > Hi,
> > > Is there any option to pass sql queries at sqoop-export command so that
> > we
> > > export selected data to the rdbms?
> > >
> > > Thanks
> >
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