You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/07/22 08:39:41 UTC
[GitHub] [doris] shutao917 opened a new issue, #11122: [Bug] Unknown or incorrect time zone: 'GMT'
shutao917 opened a new issue, #11122:
URL: https://github.com/apache/doris/issues/11122
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Version
doris 1.1.0
### What's Wrong?
CREATE TABLE aaaaaaaaaa (
id BIGINT NOT NULL,
`time` DATETIME NOT NULL,
org_id BIGINT,
object_id BIGINT NOT NULL,
employee_id BIGINT)
DUPLICATE KEY(id,`time`,org_id)
PARTITION BY RANGE(`time`)
(PARTITION p20210310 VALUES [('1970-01-01 00:00:00'), ('2021-03-11 00:00:00')))
DISTRIBUTED BY HASH(`org_id`) BUCKETS 4 PROPERTIES( "replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "MONTH",
"dynamic_partition.create_history_partition" = "TRUE",
"dynamic_partition.history_partition_num" = "360",
"dynamic_partition.end" = "140",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "4")
errCode = 2, detailMessage = Unknown or incorrect time zone: 'GMT'
### What You Expected?
报错
### How to Reproduce?
_No response_
### Anything Else?
_No response_
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
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@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] kpfly commented on issue #11122: [Bug] Unknown or incorrect time zone: 'GMT'
Posted by GitBox <gi...@apache.org>.
kpfly commented on issue #11122:
URL: https://github.com/apache/doris/issues/11122#issuecomment-1192460582
@Gabriel39
--
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@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] shutao917 commented on issue #11122: [Bug] Unknown or incorrect time zone: 'GMT'
Posted by GitBox <gi...@apache.org>.
shutao917 commented on issue #11122:
URL: https://github.com/apache/doris/issues/11122#issuecomment-1192482985
> Hi @shutao917 you can just set '+08:00' or 'CST' to change time zone. GMT prefix is not supported now
how to set?
--
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@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] shutao917 closed issue #11122: [Bug] Unknown or incorrect time zone: 'GMT'
Posted by GitBox <gi...@apache.org>.
shutao917 closed issue #11122: [Bug] Unknown or incorrect time zone: 'GMT'
URL: https://github.com/apache/doris/issues/11122
--
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@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] shutao917 commented on issue #11122: [Bug] Unknown or incorrect time zone: 'GMT'
Posted by GitBox <gi...@apache.org>.
shutao917 commented on issue #11122:
URL: https://github.com/apache/doris/issues/11122#issuecomment-1193450020
>
> at first,the time zone variables are like below: system_time_zone GMT time_zone Asia/Chungking so i change the operation system time zone to Asia/Chungking.and restart all doris fe and be
>
> then SHOW VARIABLES LIKE '%time_zone%',every thing looks like ok. system_time_zone Asia/Chungking time_zone Asia/Chungking
>
> but still get the error errCode = 2, detailMessage = Unknown or incorrect time zone: 'GMT'
set time_zone = '+08:00' does't work。see below
--
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@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] shutao917 commented on issue #11122: [Bug] Unknown or incorrect time zone: 'GMT'
Posted by GitBox <gi...@apache.org>.
shutao917 commented on issue #11122:
URL: https://github.com/apache/doris/issues/11122#issuecomment-1192359404
at first,the time zone variables are like below:
system_time_zone GMT
time_zone Asia/Chungking
so i change the operation system time zone to Asia/Chungking.and restart all doris fe and be
then SHOW VARIABLES LIKE '%time_zone%',every thing looks like ok.
system_time_zone Asia/Chungking
time_zone Asia/Chungking
but still get the error
errCode = 2, detailMessage = Unknown or incorrect time zone: 'GMT'
--
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@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] leafgodgood commented on issue #11122: [Bug] Unknown or incorrect time zone: 'GMT'
Posted by GitBox <gi...@apache.org>.
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] Gabriel39 commented on issue #11122: [Bug] Unknown or incorrect time zone: 'GMT'
Posted by GitBox <gi...@apache.org>.
Gabriel39 commented on issue #11122:
URL: https://github.com/apache/doris/issues/11122#issuecomment-1192479462
Hi @shutao917 you can just set '+08:00' or 'CST' to change time zone. GMT prefix is not supported now
--
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@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] Gabriel39 commented on issue #11122: [Bug] Unknown or incorrect time zone: 'GMT'
Posted by GitBox <gi...@apache.org>.
Gabriel39 commented on issue #11122:
URL: https://github.com/apache/doris/issues/11122#issuecomment-1192506293
> > Hi @shutao917 you can just set '+08:00' or 'CST' to change time zone. GMT prefix is not supported now
>
> how to set?
SET global time_zone = '+08:00';
--
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@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org