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 >
