leafgodgood commented on issue #11122: URL: https://github.com/apache/doris/issues/11122#issuecomment-1256442798
``` MySQL [(none)]> show variables like '%time_zone%'; +------------------+-----------+ | Variable_name | Value | +------------------+-----------+ | system_time_zone | GMT+08:00 | | time_zone | +08:00 | +------------------+-----------+ 2 rows in set (0.001 sec) MySQL [(none)]> CREATE TABLE example_db.dynamic_partition ( k1 DATE, k2 INT, k3 SMALLINT, v1 VARCHAR(2048), v2 DATETIME DEFAULT "2014-02-04 15:36:00" ) DUPLICATE KEY(k1, k2, k3) PARTITION BY RANGE (k1) () DISTRIBUTED BY HASH(k2) BUCKETS 32 PROPERTIES( "dynamic_partition.time_unit" = "DAY", "dynamic_partition.start" = "-3", "dynamic_partition.end" = "3", "dynamic_partition.prefix" = "p", "dynamic_partition.buckets" = "32" ); ERROR 1105 (HY000): errCode = 2, detailMessage = Unknown or incorrect time zone: 'GMT+08:00' ``` why? -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
