Skip to content

Upgrade

Jump to bottom
Lorenzo Mangani edited this page Mar 10, 2023 · 9 revisions

Major Upgrades

2.0 to 2.1

The project has been renamed to qryn. Please update your repositories and procedures to reflect the new name and URLs.

1.x to 2.x

Version 2 introduces breaking changes to the samples table. qryn will create a new samples table to support the new schema, the data that has previously been written will still be available, but with a slightly slower performance.

To migrate the data after qryn v2.x has been installed and run, please follow below steps:

  • Log into clickhouse via it's client cli
clickhouse-client --host 127.0.0.1 --user=default --password=yourClickhousePassword
  • Navigate to your qryn database, via the USE command (default database name is qryn)
USE qryn;
  • Migrate past data from samples_v2 and samples tables with the below commands
INSERT INTO samples_v3 (fingerprint, timestamp_ns, value, string) SELECT fingerprint, timestamp_ms * 1000000 as timestamp_ms, value, string from samples_v2
INSERT INTO samples_v3 (fingerprint, timestamp_ns, value, string) SELECT fingerprint, timestamp_ms * 1000000 as timestamp_ms, value, string from samples
  • After successful completion of the INSERT into samples_v3, you delete the old tables via
DROP TABLE samples
DROP TABLE samples_v2
Clone this wiki locally