Download Partitioning pruning with explicit partition expression #28800 book pdf free download link or read online here in PDF. Read online Partitioning pruning with explicit partition expression #28800 book pdf free download link book now. All books are in clear copy here, and all files are secure so don't worry about it. This site is like a library, you could find million book here by using search box in the header.
create table test_partitioning engine = MergeTree ORDER BY number PARTITION BY cityHash64(number) % 100 as select * from numbers(10000); set send_logs_level = 'debug'; select count () from test_partitioning where cityHash64(number) % 100 = 1; -- Selected 1/100 parts by partition key, 1 parts by primary key, 1/1 marks by primary key, 1 marks to read from 1 ranges -- (•‿•) select count ...
| Read : Partitioning pruning with explicit partition expression #28800 pdf book online Select one of servers for direct link: |
|---|