Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> Export in free from


Copy link to this message
-
Re: Export in free from
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB