[jira] [Commented] (SPARK-36428) the 'seconds' parameter of 'make_timestamp' should accept integer type
[ https://issues.apache.org/jira/browse/SPARK-36428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17401598#comment-17401598 ] Apache Spark commented on SPARK-36428: -- User 'beliefer' has created a pull request for this issue: https://github.com/apache/spark/pull/33787 > the 'seconds' parameter of 'make_timestamp' should accept integer type > -- > > Key: SPARK-36428 > URL: https://issues.apache.org/jira/browse/SPARK-36428 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 3.2.0 >Reporter: Wenchen Fan >Assignee: Apache Spark >Priority: Major > Fix For: 3.2.0 > > > With ANSI mode, {{SELECT make_timestamp(1, 1, 1, 1, 1, 1)}} fails, because > the 'seconds' parameter needs to be of type DECIMAL(8,6), and INT can't be > implicitly casted to DECIMAL(8,6) under ANSI mode. > We should update the function {{make_timestamp}} to allow integer type > 'seconds' parameter. -- This message was sent by Atlassian Jira (v8.3.4#803005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-36428) the 'seconds' parameter of 'make_timestamp' should accept integer type
[ https://issues.apache.org/jira/browse/SPARK-36428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17401596#comment-17401596 ] Apache Spark commented on SPARK-36428: -- User 'beliefer' has created a pull request for this issue: https://github.com/apache/spark/pull/33787 > the 'seconds' parameter of 'make_timestamp' should accept integer type > -- > > Key: SPARK-36428 > URL: https://issues.apache.org/jira/browse/SPARK-36428 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 3.2.0 >Reporter: Wenchen Fan >Assignee: Apache Spark >Priority: Major > Fix For: 3.2.0 > > > With ANSI mode, {{SELECT make_timestamp(1, 1, 1, 1, 1, 1)}} fails, because > the 'seconds' parameter needs to be of type DECIMAL(8,6), and INT can't be > implicitly casted to DECIMAL(8,6) under ANSI mode. > We should update the function {{make_timestamp}} to allow integer type > 'seconds' parameter. -- This message was sent by Atlassian Jira (v8.3.4#803005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-36428) the 'seconds' parameter of 'make_timestamp' should accept integer type
[ https://issues.apache.org/jira/browse/SPARK-36428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17400740#comment-17400740 ] Apache Spark commented on SPARK-36428: -- User 'beliefer' has created a pull request for this issue: https://github.com/apache/spark/pull/33775 > the 'seconds' parameter of 'make_timestamp' should accept integer type > -- > > Key: SPARK-36428 > URL: https://issues.apache.org/jira/browse/SPARK-36428 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 3.2.0 >Reporter: Wenchen Fan >Assignee: Apache Spark >Priority: Major > Fix For: 3.2.0 > > > With ANSI mode, {{SELECT make_timestamp(1, 1, 1, 1, 1, 1)}} fails, because > the 'seconds' parameter needs to be of type DECIMAL(8,6), and INT can't be > implicitly casted to DECIMAL(8,6) under ANSI mode. > We should update the function {{make_timestamp}} to allow integer type > 'seconds' parameter. -- This message was sent by Atlassian Jira (v8.3.4#803005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-36428) the 'seconds' parameter of 'make_timestamp' should accept integer type
[ https://issues.apache.org/jira/browse/SPARK-36428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17394603#comment-17394603 ] Apache Spark commented on SPARK-36428: -- User 'beliefer' has created a pull request for this issue: https://github.com/apache/spark/pull/33665 > the 'seconds' parameter of 'make_timestamp' should accept integer type > -- > > Key: SPARK-36428 > URL: https://issues.apache.org/jira/browse/SPARK-36428 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 3.2.0 >Reporter: Wenchen Fan >Priority: Major > > With ANSI mode, {{SELECT make_timestamp(1, 1, 1, 1, 1, 1)}} fails, because > the 'seconds' parameter needs to be of type DECIMAL(8,6), and INT can't be > implicitly casted to DECIMAL(8,6) under ANSI mode. > We should update the function {{make_timestamp}} to allow integer type > 'seconds' parameter. -- This message was sent by Atlassian Jira (v8.3.4#803005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-36428) the 'seconds' parameter of 'make_timestamp' should accept integer type
[ https://issues.apache.org/jira/browse/SPARK-36428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17393818#comment-17393818 ] jiaan.geng commented on SPARK-36428: I will take a look. > the 'seconds' parameter of 'make_timestamp' should accept integer type > -- > > Key: SPARK-36428 > URL: https://issues.apache.org/jira/browse/SPARK-36428 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 3.2.0 >Reporter: Wenchen Fan >Priority: Major > > With ANSI mode, {{SELECT make_timestamp(1, 1, 1, 1, 1, 1)}} fails, because > the 'seconds' parameter needs to be of type DECIMAL(8,6), and INT can't be > implicitly casted to DECIMAL(8,6) under ANSI mode. > We should update the function {{make_timestamp}} to allow integer type > 'seconds' parameter. -- This message was sent by Atlassian Jira (v8.3.4#803005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org