[GitHub] [druid] FrankChen021 edited a comment on issue #11929: Batch ingestion using SQL INSERT

[GitBox <gi...@apache.org>]

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: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org