[GitHub] [incubator-doris] ltylty opened a new issue #1452: 如何比较方便地按天分区建表

[GitBox]

ltylty opened a new issue #1452: 如何比较方便地按天分区建表
URL: https://github.com/apache/incubator-doris/issues/1452
 
 
   在文档中看到如下建表语句
    CREATE TABLE example_db.table_range
       (
       k1 DATE,
       k2 INT,
       k3 SMALLINT,
       v1 VARCHAR(2048),
       v2 DATETIME DEFAULT "2014-02-04 15:36:00"
       )
       ENGINE=olap
       DUPLICATE KEY(k1, k2, k3)
       PARTITION BY RANGE (k1)
       (
       PARTITION p1 VALUES LESS THAN ("2014-01-01"),
       PARTITION p2 VALUES LESS THAN ("2014-06-01"),
       PARTITION p3 VALUES LESS THAN ("2014-12-01")
       )
       DISTRIBUTED BY HASH(k2) BUCKETS 32
       PROPERTIES(
       "storage_medium" = "SSD", "storage_cooldown_time" = "2015-06-04 00:00:00"
       );
   
   这个语句会将数据划分成如下3个分区：
       ( {    MIN     },   {"2014-01-01"} )
       [ {"2014-01-01"},   {"2014-06-01"} )
       [ {"2014-06-01"},   {"2014-12-01"} )
   
   如果我想按天或者按月分区，不是要写很多 PARTITION p3 VALUES LESS THAN ("2014-12-01") 
这样地语句？有没有比较方便地做法？

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@doris.apache.org
For additional commands, e-mail: dev-h...@doris.apache.org