Oracle
The following table describes the data movement, data domain profiling, and data masking operations that you can perform on the Oracle data types when the target is Hive or HDFS:
Data Types | Hive | HDFS | Comments |
|---|
Blob | Yes | No | |
Char | Yes | Yes | |
Clob | Yes | Yes | |
Decimal(P,S) | Yes | Yes | You can enter a precision value up to 28. |
Float | Yes | Yes | You can enter a precision value up to 28. |
Integer | Yes | Yes | |
Long | Yes | Yes | |
Longraw | Yes | No | |
Longvarchar | Yes | Yes | |
Nchar | Yes | Yes | |
Nclob | Yes | Yes | |
Number | Yes | Yes | You can enter a precision value up to 28 and scale value up to 27. |
Nvarchar2(N) | Yes | Yes | |
Raw | Yes | No | |
Real | Yes | Yes | |
Smallint | Yes | Yes | |
Timestamp | Yes | Yes | When you move data from Oracle to HDFS, TDM truncates nanoseconds value and displays zeroes for the data types Timestamp (1) to Timestamp (9). |
Varchar2(N) | Yes | Yes | |
When the target is Hive or HDFS, you cannot perform data movement, data domain profiling, and data masking operations on the following Oracle data types:
- •Anydata
- •Anydataset
- •Anytype
- •Bfile
- •Binary_Double
- •Binary_Float
- •Date
- •Dburitype
- •Httpuritype
- •Interval day to second and Interval day(9) to second
- •Interval year to month and Interval year(9) to month
- •Ordaudio
- •Orddicom
- •Orddoc
- •Ordimage
- •Ordimagesignature
- •Ordvideo
- •Rowid
- •Sdo_Geometry
- •Sdo_Georaster
- •Sdo_Topo_Geometry
- •SI_Averagecolor
- •SI_Color
- •SI_Colorhistogram
- •SI_Featurelist
- •SI_Positionalcolor
- •SI_Stillimage
- •SI_Texture
- •Timestamp with local time zone, Timestamp (6) with local time zone, and Timestamp (9) with local time zone
- •Timestamp with time zone, Timestamp (6) with time zone and Timestamp (9) with time zone
- •Uritype
- •Urowid
- •XML
- •Xdburitype