steve flitcroft redsquare

I hereby claim:

To claim this, I am signing this object:

	<!--
	NOTE: User and query level settings are set up in "users.xml" file.
	If you have accidentally specified user-level settings here, server won't start.
	You can either move the settings to the right place inside "users.xml" file
	or add <skip_check_for_incorrect_settings>1</skip_check_for_incorrect_settings> here.
	-->
	<clickhouse>
	<logger>
	<!-- Possible levels [1]:

	Handle the map as an array and then via ARRAY JOIN bring it into multiple rows, so you can use more complex SQL features. with argMax you could then get the latest value per key.
	Then you need to regroup it again:

	SELECT source, integration_id, transaction_id, min(min_event_time), groupArray((field_key, field_value))::Map(String, String)
	FROM (
	SELECT source, integration_id, transaction_id, min(event_time) AS min_event_time, field.1 AS field_key, argMax(field.2, event_time) AS field_value
	FROM events
	ARRAY JOIN fields AS field
	GROUP BY source, integration_id, transaction_id, field.1
	)

	SELECT
	table,
	partition_id,
	count(name) AS parts,
	formatReadableSize(sum(bytes_on_disk)) AS size
	FROM system.parts
	WHERE (table = 'qw_3_requests_quotes') AND active AND (toUInt32(partition_id) < 20231001)
	GROUP BY
	table,
	partition_id

	SELECT
	table,
	partition_id,
	count(name) AS parts,
	formatReadableSize(sum(bytes_on_disk)) AS size
	FROM system.parts
	WHERE (table = 'qw_3_requests_quotes') AND active AND (toUInt32(partition_id) < 20231001)
	GROUP BY
	table,
	partition_id

	#dump table ddl's

	clickhouse-client --host your_clickhouse_host -q "SHOW TABLES FROM db_name" \| while read -r table_name; do
	clickhouse-client --host your_clickhouse_host -q "SHOW CREATE TABLE db_name.\`$table_name\`" >> db_structure.sql
	done

	#restore
	clickhouse-client --host target_clickhouse_host < db_structure.sql

	#also in /var/lib/clickhouse/metadata/

	:) CREATE TABLE ranges (id UInt64, date_start Date, date_end Date) ENGINE = TinyLog;

	:) INSERT INTO ranges SELECT rowNumberInAllBlocks() AS id, least(dates[1], dates[2]) AS date_start, greatest(dates[1], dates[2]) AS date_end FROM (SELECT arrayJoin(arrayMap(d -> [today() - d - rand64(d) % 10, yesterday() - d - rand(d) % 10], range(10))) AS dates);

	:) CREATE TABLE dates (id UInt64, date Date) ENGINE = TinyLog;

	:) INSERT INTO dates SELECT rowNumberInAllBlocks() AS id, date FROM (SELECT arrayJoin(arrayMap(d -> today() - rand64(d) % 10, range(10))) AS date);

	name: Register & Deploy Prefect flows

	on:
	push:
	workflow_dispatch:
	inputs:
	pattern:
	description: "Project Name or prohect name Pattern? (defaults to all)"
	required: false
	default: ".*"

	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Net.Security;
	using System.Security.Cryptography.X509Certificates;
	using System.Text;
	using System.Threading;
	using System.Threading.Tasks;
	using StackExchange.Redis;

	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="utf-8"/>
	<title>t1</title>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/benchmark/1.0.0/benchmark.min.js"></script>
	<script src="./suite.js"></script>
	</head>
	<body>
	<h1>Open the console to view the results</h1>