Join this group to access featured content and participate in discussions related to DMX.
I have a task for transferring a table from Oracle to Vertica. This is done using pipes for intermediate data holder.While transferring other tables i do not get error. But When i transfer a table with a Timestamp data type column, the data in the particular column gets truncated and a default value of 1900-01-01 00:00:00 gets inserted.
The error is
invalid data found converting column CURTIME data to field value X'30342D4A554E2D31332030393A34343A33322E3030' at position 15 in record
I have used the TODATE function, still the issue persists.
Can anyone have anyidea how to transfer Timestamp data type records??