Home | About | Sematext search-lucene.com search-hadoop.com
 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
> >