[GitHub] [incubator-doris] HangyuanLiu opened a new issue #1583: Support multiple time zone

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

HangyuanLiu opened a new issue #1583: Support multiple time zone
URL: https://github.com/apache/incubator-doris/issues/1583
 
 
   **Is your feature request related to a problem? Please describe.**
   Support multiple time zone
   
   **Solution:**
   
   1. Setting of time zone related parameters: 
       mainly involves two parameters "system_time_zone" and "time_zone".
       "system_time_zone" is obtained by calling the system interface and cannot be modified. 
       "time_zone" parameter can be modified. To be compatible with historical logic, the default setting is CST.
   Time zone values ​​can be given in several formats, no case sensitive:
   * "SYSTEM", indicating that the server time zone is the same as the system time zone
   * A string representing the UTC offset, such as '+10:00' or '-06:00'
   * Standard time zone format such as "Asia/Shanghai", "America/Los_Angeles"
   * Abbreviated time zone formats such as "MET", "CTT" are not supported. Because the abbreviated time zone is ambiguous in different scenarios, it is not recommended.
   * In order to be compatible with Doris, support CST abbreviated time zone, internally transfer CST to "China/Shanghai" Chinese standard time zone
   
   2. Time zone in BE: Perceive the time zone by Fe, and then pass two parameters to be. One is the UTC timestamp, and the other is the time zone information.
   
   3.  the time recorded in the fe: such as "show backends", "show load". These time fields should be modified according to the time zone. Fe internally stores timestamps. The timestamp can be converted to a date literal by calling the TimeUtils.longToTimeString function. Inside the function, get the time zone configuration through Session variabled
   
   

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

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