HangyuanLiu opened a new issue #2036: Fix partition create table fail
URL: https://github.com/apache/incubator-doris/issues/2036
 
 
   **Describe the bug**
   Fix partition create table fail!
   
   **To Reproduce**
   CREATE TABLE `test1` (
     `datetime` datetime NOT NULL ,
     `stmt_id` bigint(20) NOT NULL ,
     `cost_time` int(11) NOT NULL
   ) ENGINE=OLAP
   DUPLICATE KEY(`datetime`,`stmt_id`,`cost_time`)
   PARTITION BY RANGE(`datetime`)
   (PARTITION p201906 VALUES LESS THAN ('2019-07-01 00:00:00'),
   PARTITION p201910 VALUES LESS THAN ('2019-11-01 00:00:00'))
   DISTRIBUTED BY HASH(`stmt_id`) BUCKETS 16
   PROPERTIES (
   "storage_type" = "COLUMN",
   "replication_num"="1"
   );
   
   CREATE TABLE `test2` (
     `datetime` datetime NOT NULL ,
     `stmt_id` bigint(20) NOT NULL ,
     `cost_time` int(11) NOT NULL
   ) ENGINE=OLAP
   DUPLICATE KEY(`datetime`,`stmt_id`,`cost_time`)
   PARTITION BY RANGE(`datetime`)
   (PARTITION p201906 VALUES [('2019-06-01 00:00:00'), ('2019-07-01 00:00:00')),
   PARTITION p201910 VALUES [('2019-10-01 00:00:00'), ('2019-11-01 00:00:00')))
   DISTRIBUTED BY HASH(`stmt_id`) BUCKETS 16
   PROPERTIES (
   "storage_type" = "COLUMN",
   "replication_num"="1"
   );
   
   **Expected behavior**
    test1 create table statement is right , but test2 is syntax error

----------------------------------------------------------------
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:
[email protected]


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to