I hereby claim:
- I am redsquare on github.
- I am redsquare (https://keybase.io/redsquare) on keybase.
- I have a public key ASBXSLaKvqYBgD34X1I2FSTC5hTdJqkr6lKhzu4__ZYE8Qo
To claim this, I am signing this object:
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: ".*" |
I hereby claim:
To claim this, I am signing this object:
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> |
$scope.updateview = function (iteration, $event) { | |
var _this = $("#" + $event.target.id); | |
$http.get('../issues?size=25&iteration=' + iteration).success(function (data) { | |
$scope.issueList = data; | |
_this.addClass("tab-selected"); | |
}); | |
}; |
//r = require('rethinkdb') | |
var MongoClient = require('mongodb').MongoClient, | |
format = require('util').format; | |
var querystring = require('querystring'); | |
var https = require('https'); | |
var Inserter = function (collection) { | |
this.collection = collection; |