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
signature.asc
Description: Digital signature
