FrankChen021 edited a comment on issue #11929: URL: https://github.com/apache/druid/issues/11929#issuecomment-971336455
As for the partition, I think an independent `PARTITION BY` is more flexible. ClickHouse also provides optional `PARTITION BY` keyword. If it's not specified, data would not be partitioned. https://clickhouse.com/docs/en/engines/table-engines/mergetree-family/mergetree/ > PARTITION BY — The partitioning key. Optional. In most cases you don't need partition key, and in most other cases you don't need partition key more granular than by months. Partitioning does not speed up queries (in contrast to the ORDER BY expression). You should never use too granular partitioning. Don't partition your data by client identifiers or names (instead make client identifier or name the first column in the ORDER BY expression). > For partitioning by month, use the toYYYYMM(date_column) expression, where date_column is a column with a date of the type Date. The partition names here have the "YYYYMM" format. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
