Synchronizing local and UTC timestamps

If you have existing Kudu tables written in local time, you must rewrite them if you decide to enable UTC conversion globally.

Example: Moving data to a UTC-enabled table

The following example shows how to move data from a local-time table to a UTC-enabled table.

Set the session to read the existing local timestamps without conversion:

SET convert_kudu_utc_timestamps=false;

Enable UTC conversion for the new write operation:

SET write_kudu_utc_timestamps=true;

Run the following command to rewrite the data into the new table:

INSERT INTO TABLE new_utc_table SELECT * FROM old_local_table;