Hi, I want to upset historic data to a table with indexes, I have there TTL defined and I want to load the data as if it was loaded in the correct time so it will be cleaned automatically using the TTL mechanism. I implemented a small java code to load the data after setting "CurrentSCN" to older date ( based on this link https://phoenix.apache.org/faq.html#Can_phoenix_work_on_tables_with_arbitrary_timestamp_as_flexible_as_HBase_API)
But I get java.sql.SQLException: ERROR 518 (25502): Mutations are not permitted for a read-only connection on each upset. The same code without setting CurrentSCN property works fine I am using phoenix 4.13.1 - is this a bug? If not , is there something missing in the documentation on how to set "CurrentSCN" 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.
