alexey-milovidov

```
2022.08.24 14:08:36.908985 [ 2805621 ] {} <Error> ZooKeeperClient: Code: 999. Coordination::Exception: Operation timeout (no response) for request Create for path: /clickhouse/tables/7af94bd6-f5de-4f7f-bb31-c2bc6af692d3/1/part_moves_shard (Operation timeout). (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below):

0. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int, bool) @ 0xa360bfa in /usr/bin/clickhouse
1. Coordination::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, Coordination::Error, int) @ 0x168f8af5 in /usr/bin/clickhouse
2. Coordination::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, Coordination::Error) @ 0x168f8e47 in /usr/bin/clickhouse
3. Coordination::ZooKeeper::receiveThread() @ 0x1694bbd5 in /usr/bin/clickhouse
4. void std::__1::__function::__pol

alexey-milovidov

ip-172-31-22-38.eu-central-1.compute.internal :) SET max_memory_usage = '100G', max_insert_threads = 72, max_threads = 72

SET max_memory_usage = '100G', max_insert_threads = 72, max_threads = 72

Query id: 09aa6c85-71fa-44e1-a830-f51ba512b2ee

Ok.

0 rows in set. Elapsed: 0.001 sec. 

alexey-milovidov

SELECT
    CAST(time, 'Date') AS d,
    sum(hits) AS c,
    bar(c, 0, 10000000, 100)
FROM wikistat
WHERE path = 'Donald_Trump'
GROUP BY d
ORDER BY d ASC

Query id: 29b2a97b-acbb-4922-b6ab-73775eabd169

alexey-milovidov

milovidov@milovidov-desktop:~/work/ClickHouse/docs/tools$ clickhouse-client 
ClickHouse client version 22.2.1.1.
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 22.2.1 revision 54455.

milovidov-desktop :) ALTER TABLE test.hits ADD COLUMN all MATERIALIZED formatRow('TSV', *)

ALTER TABLE test.hits
    ADD COLUMN `all` MATERIALIZED formatRow('TSV', *)

alexey-milovidov

memcpy.S:

/*-*- mode:unix-assembly; indent-tabs-mode:t; tab-width:8; coding:utf-8     -*-│
│vi: set et ft=asm ts=8 tw=8 fenc=utf-8                                     :vi│
╞══════════════════════════════════════════════════════════════════════════════╡
│ Copyright 2020 Justine Alexandra Roberts Tunney                              │
│                                                                              │
│ Permission to use, copy, modify, and/or distribute this software for         │
│ any purpose with or without fee is hereby granted, provided that the         │
│ above copyright notice and this permission notice appear in all copies.      │

alexey-milovidov

# -*- coding: utf-8 -*-
import logging
import sandbox.sdk2.helpers
import subprocess

import os
from sandbox import sdk2
import sandbox.common.types.resource as ctr
import sandbox.common.types.client as ctc
from sandbox.projects.clickhouse.BaseOnCommitTask.base import NeedToRunDescription

alexey-milovidov

$ clickhouse-client 
ClickHouse client version 21.3.1.1.
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 21.3.1 revision 54447.

milovidov-desktop :) SELECT toDateTime(1234567890, 'Europe/Moscow')

SELECT toDateTime(1234567890, 'Europe/Moscow')

Query id: 99607776-8d7a-47f7-a3ca-ed00baa20c08

alexey-milovidov

#include <cstddef>
#include <cstdint>
#include <vector>
#include <iostream>


#define ALWAYS_INLINE __attribute__((__always_inline__))

namespace
{

alexey-milovidov

WITH wordShingleMinhashCaseInsensitiveUTF8(body) AS hashes
SELECT DISTINCT body
FROM github_events
WHERE (event_type = 'IssueCommentEvent') AND (action = 'created') AND ((hashes.1) = 245165191482241124)

Query id: 975b45e6-38fe-4ec6-8524-dad348549cac

┌─body───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ I license past and future contributions under the dual MIT/Apache-2.0 license, allowing licensees to chose either at their option. │
└────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘

alexey-milovidov

$ ./clickhouse-test start_and
Using queries from 'queries' directory
Using clickhouse-client as client program (expecting unbundled mode)
Connecting to ClickHouse server... OK
Found 1 parallel tests and 0 sequential tests

Running 1 stateless tests.

01526_client_start_and_exit:                                            [ FAIL ] - result differs with reference:
--- /home/milovidov/work/ClickHouse/tests/queries/0_stateless/01526_client_start_and_exit.reference     2020-12-20 08:29:23.986871802 +0300