Size: a a a
ДБ
VS
КТ
O
КТ
SELECT 123456789 % 100
┌─modulo(123456789, 100)─┐
│ 89 │
└────────────────────────┘
SL
O
SELECT 123456789 % 100
┌─modulo(123456789, 100)─┐
│ 89 │
└────────────────────────┘
O
ДБ
max_partitions_per_insert_block = 100 нифига не просто так? Что найдя способ вставить в КХ за раз кучу партиций вы в итоге выстрелите себе в ногу? Например перезапустите КХ и он будет стартовать два часаSP
Code: 514. DB::Exception: Received from localhost:9000. DB::Exception: Not found a storage to insert userS
max_partitions_per_insert_block = 100 нифига не просто так? Что найдя способ вставить в КХ за раз кучу партиций вы в итоге выстрелите себе в ногу? Например перезапустите КХ и он будет стартовать два часаSP
D
SL
max_partitions_per_insert_block = 100 нифига не просто так? Что найдя способ вставить в КХ за раз кучу партиций вы в итоге выстрелите себе в ногу? Например перезапустите КХ и он будет стартовать два часаSL
MU
storage policies: есть параметр move_factor - по заполнению диска на определенный процент, какие данные будут переносится на следующий диск: новые вставляемые или старые?MU
IB
rabbitmq_format = 'JSONAsString’, на выходе пустая строка, хотя с JSONEachRow все ок. У кого-нибудь был опыт похожий?АА
2020.08.03 10:48:17.604931 [ 1 ] {} <Warning> Application: Listen [::]:8123 failed: Poco::Exception. Code: 1000, e.code() = 0, e.displayText() = DNS error: EAI: Address family for hostname not supported (version 20.5.2.7 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
2020.08.03 10:48:17.605250 [ 1 ] {} <Warning> Application: Listen [::]:9000 failed: Poco::Exception. Code: 1000, e.code() = 0, e.displayText() = DNS error: EAI: Address family for hostname not supported (version 20.5.2.7 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
2020.08.03 10:48:17.605503 [ 1 ] {} <Warning> Application: Listen [::]:9010 failed: Poco::Exception. Code: 1000, e.code() = 0, e.displayText() = DNS error: EAI: Address family for hostname not supported (version 20.5.2.7 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
2020.08.03 10:48:18.107166 [ 54 ] {} <Error> void DB::DDLWorker::runMainThread(): Code: 999, e.displayText() = Coordination::Exception: All connection tries failed while connecting to ZooKeeper. nodes: 192.168.96.2:2183, 192.168.96.4:2181, 192.168.96.3:2182
Poco::Exception. Code: 1000, e.code() = 111, e.displayText() = Connection refused (version 20.5.2.7 (official build)), 192.168.96.2:2183
Code: 33, e.displayText() = DB::Exception: Cannot read all data. Bytes read: 0. Bytes expected: 4.: while receiving handshake from ZooKeeper (version 20.5.2.7 (official build)), 192.168.96.4:2181
Poco::Exception. Code: 1000, e.code() = 111, e.displayText() = Connection refused (version 20.5.2.7 (official build)), 192.168.96.3:2182
Poco::Exception. Code: 1000, e.code() = 111, e.displayText() = Connection refused (version 20.5.2.7 (official build)), 192.168.96.2:2183
Code: 33, e.displayText() = DB::Exception: Cannot read all data. Bytes read: 0. Bytes expected: 4.: while receiving handshake from ZooKeeper (version 20.5.2.7 (official build)), 192.168.96.4:2181
Poco::Exception. Code: 1000, e.code() = 111, e.displayText() = Connection refused (version 20.5.2.7 (official build)), 192.168.96.3:2182
Poco::Exception. Code: 1000, e.code() = 111, e.displayText() = Connection refused (version 20.5.2.7 (official build)), 192.168.96.2:2183
Code: 33, e.displayText() = DB::Exception: Cannot read all data. Bytes read: 0. Bytes expected: 4.: while receiving handshake from ZooKeeper (version 20.5.2.7 (official build)), 192.168.96.4:2181
Poco::Exception. Code: 1000, e.code() = 111, e.displayText() = Connection refused (version 20.5.2.7 (official build)), 192.168.96.3:2182АА