Oracle int data type issues #84
Description
In Cloud Data Fusion, i am using oracle plugin provided to get data from Oracle 18c database. When using this for source, I able to successfully extract varchar data, but the number/integer types are not successful. Oracle table values are:
|ID (int) | NAME(varchar2) |
----------------------------
|501 | raja |
|502 | praveen |
Preview on DataFusion shows as below, notice the ID column, the values are different :
|ID(decimal) | NAME (string) |
--------------------------------
|[1,-11] | raja |
|[1,-10] | praveen |
On the output file, i can see the values as:
[B@5f50fd07,raja
[B@6787d919,praveen
What are these values on ID column getting translated to? For decimals in oracle table, i get values like [0,-61,-66]. Are there implicit conversion of number types in data fusion. I'm using the oracle drivers provided by Data fusion.