Hi YouPeng,
Sqoop 1 do not supports custom insert query when exporting data from HDFS. I think that in
your use case you can use parameter --columns to specify which columns and in what order are
present on HDFS, for example:
sqoop ... --columns ID,TIMEID,COLA,COLB
Jarcec
On Wed, May 22, 2013 at 02:49:04PM +0800, YouPeng Yang wrote:
> Hi
> I want to export data on the HDFS to the oracle database with
> sqoop-1.4(sqoop-1.4.1-cdh4.1.2). However the columns betwean HDFS and
> Oracle table are not exactly same to each other.
>
> For example,Data on HDFS:
> -------------------------------------------------------------
> | ID | TIMEID | COLA | COLB |
> -------------------------------------------------------------
> | 6 | 201305221335 | 0 | 20 |
> -------------------------------------------------------------
>
> the Oracle table:
> ------------------------------------------------------------------------
> | ID | TIMEID | COLC | COLB | COLA |
> ------------------------------------------------------------------------
> | 7 | 201305221335 | kk | 20 | 1 |
> ------------------------------------------------------------------------
> Note:Additional COLC and unsame order.
>
>
> I notice the sqoop export command:
> --export-dir HDFS source path for the export
> --table Table to populate.
> It seams not to export the data to oracle in free from just as Free-form
> Query Imports
> using the --query argument.
>
> Could I acheive that goal ?
>
> Thanks very much
>
> Regards
|