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 <[email protected]> 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 <[email protected] > > 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 >> > >
