sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From YouPeng Yang <yypvsxf19870...@gmail.com>
Subject Export in free from
Date Wed, 22 May 2013 06:49:04 GMT
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

Mime
View raw message