'Sqoop import Oracle Number datatype
In Oracle, a table contains column defined as Number(without precision and scale), and actual values in this column could be integer or decimal.
When using sqoop in informatica to import oracle table to AWS s3 as parquet files, all these number column are loaded as integer. and the column definition in HIVE is defined as decimal(38,0). So all numbers after the decimal point are lost.
Is there a solution?
example
Oracle: 1.34 Number
Parquet: 1 Decimal(38,0)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|