sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jazz Yao-Tsung Wang <jazzwang...@gmail.com>
Subject Re: Import from Table with special character field name
Date Tue, 02 Jun 2015 02:15:35 GMT
Hi Abe,

Great thanks for your prompt response.
I'll first give it a try with "quoting column names" after
"--map-column-java".

PS. I'm using Sqoop 1.4.3-cdh4.7.1 now. Planning to migrate to CDH5.4 for
sure.

- Jazz


On Mon, Jun 1, 2015 at 10:53 PM, Abraham Elmahrek <abe@cloudera.com> wrote:

> Hey man,
>
> Send over your exception?
>
> If you're having difficulty sending special characters is the terminal,
> you might be able to get away with quoting your column names. If you're
> importing data that should be treated differently in Sqoop,
> "--map-column-java" will do the trick. You can use a "free-form" query to
> cast the data types as well. See
> http://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_free_form_query_imports
> for more information there.
>
> -Abe
>
> On Mon, Jun 1, 2015 at 2:28 PM, Jazz Yao-Tsung Wang <jazzwang.tw@gmail.com
> > wrote:
>
>> If the import table is with special character in field name and
>> unsupported data type,
>> what can I do with `sqoop --map-column-java` ?
>>
>> Such as Oracle Table
>>
>> @MABCNO    GRAPHIC(12)
>> VECTOR$      RAW
>>
>> I try following command but fail. Is there any suggestions ?
>>
>> sqoop import --connect "jdbc:db2://X.X.X.X:50000/DBSRC" --username jazz
>> -P --map-column-java _MABCNO=STRING
>>
>> - Jazz
>>
>
>

Mime
View raw message