I am using CDH5.7.0 and sqoop to ingest data from Oracle to AVRO or Parquet (has not made my mind yet).
The problem I am having is with fixed precision numbers (decimal type e.g. number(12,4)) and sqoop creating schemas for these columns using string type.
I tried to explicitely use --map-column-java AMOUNT=java.math.BigDecimal or just Decimal and it does not work.
I do not really want to use float or double type as I need exact fixed precision as in the source.
I know that AVRO supports java.math.BigDecimal and also logical type for Decimal(n,n) so it must be a sqoop issue.
looks like this is addressed in sqoop 1.4.7
the only question when it gets to CDH