_hypercore_manual_workflow.md

import EarlyAccess from "versionContent/_partials/_early_access_2_18_0.mdx";

1. Stop the jobs that are automatically adding $CHUNKs to the $COLUMNSTORE

   Retrieve the list of $JOBs from the timescaledb_information.jobs view to find the $JOB you need to alter_job.

   SELECT alter_job(JOB_ID, scheduled => false);

2. Convert a $CHUNK to update back to the $ROWSTORE

   CALL convert_to_rowstore('_timescaledb_internal._hyper_2_2_chunk');

3. Update the data in the $CHUNK you added to the $ROWSTORE

   Best practice is to structure your INSERT statement to include appropriate partition key values, such as the timestamp. $TIMESCALE_DB adds the data to the correct $CHUNK:

   INSERT INTO metrics (time, value)
   VALUES ('2025-01-01T00:00:00', 42);

4. Convert the updated $CHUNKs back to the $COLUMNSTORE

   CALL convert_to_columnstore('_timescaledb_internal._hyper_1_2_chunk');

5. Restart the $JOBs that are automatically converting $CHUNKs to the $COLUMNSTORE

   SELECT alter_job(JOB_ID, scheduled => true);