
                    For dbms, we pick up the best solutions provided by github life savers.
                    If google brings you here, you are so lucky! These life savers are angels, they have well solved your problems.
                    So do not waste time scrolling the original issue threads just to dig out solutions... 
                    Here you are, you are welcome. Then, go back to work!
                    

Each insert create a folder in  /var/lib/clickhouse/.../table_name/ Inside that folder there are 2 files per each column - one with data (compressed) 

ClickHouse DB::Exception: Too many parts (600). Merges are processing significantly slower than inserts

@Renampme
you can run the command below


then find the file ~/ClickHouse/CMakeLists.txt


then you can follow the command and you can build successfully. 

ClickHouse Mac 10.15.4: Cannot find objcopy

+1 for Avro support Reopen #1342 for triage. 

ClickHouse Avro Support

@liuqian1989 it's kind of obvious possible feature but in practice ClickHouse works fast enough even on 100% HDD given there's enough memory for page cache 

ClickHouse Any plans to support separation hot/cold data at the level of partitions?

It's fixed in #13497  And toDate(timestamp_ms / 1000)  will also work because of  #14513 . 