[ https://issues.apache.org/jira/browse/SPARK-36428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Wenchen Fan updated SPARK-36428: -------------------------------- Description: 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' > the 'second' 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' -- 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