You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@sqoop.apache.org by Κωνσταντίνος Αρετάκης <ka...@gmail.com> on 2013/06/23 18:00:19 UTC
sqoop selective export
Hi,
Is there any option to pass sql queries at sqoop-export command so that we
export selected data to the rdbms?
Thanks
Re: sqoop selective export
Posted by Jarek Jarcec Cecho <ja...@apache.org>.
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 <ja...@apache.org>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
> >
Re: sqoop selective export
Posted by Κωνσταντίνος Αρετάκης <ka...@gmail.com>.
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 <ja...@apache.org>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
>
Re: sqoop selective export
Posted by Jarek Jarcec Cecho <ja...@apache.org>.
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