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
|