You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@kyuubi.apache.org by "user-GitHub-user (via GitHub)" <gi...@apache.org> on 2023/08/30 09:38:59 UTC
[GitHub] [kyuubi] user-GitHub-user opened a new issue, #5219: [Bug] kyuubi not support UTC+8 spark.sql.session.timeZone format
user-GitHub-user opened a new issue, #5219:
URL: https://github.com/apache/kyuubi/issues/5219
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
### Search before asking
- [X] I have searched in the [issues](https://github.com/apache/kyuubi/issues?q=is%3Aissue) and found no similar issues.
### Describe the bug
kyuubi version: 1.7.1
spark version: 3.2.1
I configure `spark.sql.session.timeZone=UTC+8` in spark-default.conf under the spark conf directory to specify the time zone
In this case, the data queried by kyuubi is 8 hours less than the data queried by Spark-SQL.
If I change the configuration to `spark.sql.session.timeZone=+08:00` , the data queried on both sides is the same.
I guess kyuubi doesn't support the UTC+8 time zone description format
### Affects Version(s)
1.7.0，1.7.1
### Kyuubi Server Log Output
_No response_
### Kyuubi Engine Log Output
_No response_
### Kyuubi Server Configurations
_No response_
### Kyuubi Engine Configurations
_No response_
### Additional context
_No response_
### Are you willing to submit PR?
- [ ] Yes. I would be willing to submit a PR with guidance from the Kyuubi community to fix.
- [X] No. I cannot submit a PR at this time.
--
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: notifications-unsubscribe@kyuubi.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
[GitHub] [kyuubi] github-actions[bot] commented on issue #5219: [Bug] kyuubi not support UTC+8 spark.sql.session.timeZone format
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #5219:
URL: https://github.com/apache/kyuubi/issues/5219#issuecomment-1698833992
Hello @user-GitHub-user,
Thanks for finding the time to report the issue!
We really appreciate the community's efforts to improve Apache Kyuubi.
--
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: notifications-unsubscribe@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
[GitHub] [kyuubi] pan3793 commented on issue #5219: [Bug] kyuubi not support UTC+8 spark.sql.session.timeZone format
Posted by "pan3793 (via GitHub)" <gi...@apache.org>.
pan3793 commented on issue #5219:
URL: https://github.com/apache/kyuubi/issues/5219#issuecomment-1698838918
https://spark.apache.org/docs/latest/configuration.html
> The ID of session local timezone in the format of either region-based zone IDs or zone offsets. Region IDs must have the form 'area/city', such as 'America/Los_Angeles'. Zone offsets must be in the format '(+|-)HH', '(+|-)HH:mm' or '(+|-)HH:mm:ss', e.g '-08', '+01:00' or '-13:33:33'. Also 'UTC' and 'Z' are supported as aliases of '+00:00'. Other short names are not recommended to use because they can be ambiguous.
Seems by design, does `Aisa/Shanghai` work expected?
--
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: notifications-unsubscribe@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
[GitHub] [kyuubi] user-GitHub-user commented on issue #5219: [Bug] kyuubi not support UTC+8 spark.sql.session.timeZone format
Posted by "user-GitHub-user (via GitHub)" <gi...@apache.org>.
user-GitHub-user commented on issue #5219:
URL: https://github.com/apache/kyuubi/issues/5219#issuecomment-1699045404
You're right, but before I used kyuubi, my configuration was UTC+8, and Spark could correctly recognize it. Anyway, I will close this issue
--
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: notifications-unsubscribe@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
[GitHub] [kyuubi] pan3793 commented on issue #5219: [Bug] kyuubi not support UTC+8 spark.sql.session.timeZone format
Posted by "pan3793 (via GitHub)" <gi...@apache.org>.
pan3793 commented on issue #5219:
URL: https://github.com/apache/kyuubi/issues/5219#issuecomment-1698975161
@user-GitHub-user According to the docs referenced above, I don't think it's a "problem", it's by design.
--
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: notifications-unsubscribe@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
[GitHub] [kyuubi] user-GitHub-user commented on issue #5219: [Bug] kyuubi not support UTC+8 spark.sql.session.timeZone format
Posted by "user-GitHub-user (via GitHub)" <gi...@apache.org>.
user-GitHub-user commented on issue #5219:
URL: https://github.com/apache/kyuubi/issues/5219#issuecomment-1698910065
Aisa/Shanghai is no problem
Using UTC+8 is to avoid Daylight Saving Time: DST issues
It seems that this problem can be solved by changing it to+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: notifications-unsubscribe@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
[GitHub] [kyuubi] pan3793 commented on issue #5219: [Bug] kyuubi not support UTC+8 spark.sql.session.timeZone format
Posted by "pan3793 (via GitHub)" <gi...@apache.org>.
pan3793 commented on issue #5219:
URL: https://github.com/apache/kyuubi/issues/5219#issuecomment-1698835970
cc @cxzl25 @cfmcgrady
--
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: notifications-unsubscribe@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
[GitHub] [kyuubi] user-GitHub-user closed issue #5219: [Bug] kyuubi not support UTC+8 spark.sql.session.timeZone format
Posted by "user-GitHub-user (via GitHub)" <gi...@apache.org>.
user-GitHub-user closed issue #5219: [Bug] kyuubi not support UTC+8 spark.sql.session.timeZone format
URL: https://github.com/apache/kyuubi/issues/5219
--
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: notifications-unsubscribe@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org