You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by "Bulvik, Noam" <No...@teoco.com> on 2017/11/30 13:52:05 UTC

case of bulk loader use CurrentSCN

Hi
Is it possible to set CurrentSCN in a way that it will be used when inserting data using the bulk loader?

Assuming I have TTL of 3 month and I am loading historical data from a month ago using the bulk loader, is there a way to set the  CurrentSCN so that timestamp of the loaded data will be set to correct date and it will be deleted on the correct time
( I can't use raw timestamp because I have indexes on the table and it is mutable table so having row_timestamp is not allowed )

Regards,

Noam



________________________________

PRIVILEGED AND CONFIDENTIAL
PLEASE NOTE: The information contained in this message is privileged and confidential, and is intended only for the use of the individual to whom it is addressed and others who have been specifically authorized to receive it. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, or if any problems occur with transmission, please contact sender. Thank you.