You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Xiao Li (JIRA)" <ji...@apache.org> on 2016/11/09 05:26:58 UTC
[jira] [Comment Edited] (SPARK-18350) Support session local
timezone
[ https://issues.apache.org/jira/browse/SPARK-18350?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15649858#comment-15649858 ]
Xiao Li edited comment on SPARK-18350 at 11/9/16 5:26 AM:
----------------------------------------------------------
Below might be needed if we want to support session timezone?
- Add a SQL statement and API to set the current session timezone?
Link: https://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm#i1006728
- Add a SQL statement and API to get the current session timezone?
Link: https://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/sqlref/src/tpc/db2z_currenttz.html
- Add time zone specific expressions?
Link: http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/sqlref/src/tpc/db2z_tzspecificexpression.html
More works are needed if we want to add a new data type {{TIMESTAMP WITH TIME ZONE}}
Link: https://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm#i1005946
was (Author: smilegator):
Below might be needed if we want to support session timezone?
- Add a SQL statement and API to set the current session timezone?
Link: https://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm#i1006728
- Add a SQL statement and API to get the current session timezone?
Link: https://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/sqlref/src/tpc/db2z_currenttz.html
- Add time zone specific expressions?
Link: http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/sqlref/src/tpc/db2z_tzspecificexpression.html
More works are needed if we want to add a new data type {TIMESTAMP WITH TIME ZONE}
Link: https://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm#i1005946
> Support session local timezone
> ------------------------------
>
> Key: SPARK-18350
> URL: https://issues.apache.org/jira/browse/SPARK-18350
> Project: Spark
> Issue Type: New Feature
> Components: SQL
> Reporter: Reynold Xin
>
> As of Spark 2.1, Spark SQL assumes the machine timezone for datetime manipulation, which is bad if users are not in the same timezones as the machines, or if different users have different timezones.
> We should introduce a session local timezone setting that is used for execution.
> An explicit non-goal is locale handling.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org