[ https://issues.apache.org/jira/browse/SPARK-23902?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xiao Li updated SPARK-23902: ---------------------------- Description: https://issues.apache.org/jira/browse/HIVE-15511 {noformat} Rounding off was added in {{GenericUDFMonthsBetween}} so that it can be compatible with systems like oracle. However, there are places where rounding off is not needed. E.g "CAST(MONTHS_BETWEEN(l_shipdate, l_commitdate) / 12 AS INT)" may not need rounding off via BigDecimal which is compute intensive. {noformat} was: https://issues.apache.org/jira/browse/HIVE-15511 {noforrmat} Rounding off was added in {{GenericUDFMonthsBetween}} so that it can be compatible with systems like oracle. However, there are places where rounding off is not needed. E.g "CAST(MONTHS_BETWEEN(l_shipdate, l_commitdate) / 12 AS INT)" may not need rounding off via BigDecimal which is compute intensive. {noformat} > Provide an option in months_between UDF to disable rounding-off > --------------------------------------------------------------- > > Key: SPARK-23902 > URL: https://issues.apache.org/jira/browse/SPARK-23902 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 2.3.0 > Reporter: Xiao Li > Priority: Major > > https://issues.apache.org/jira/browse/HIVE-15511 > {noformat} > Rounding off was added in {{GenericUDFMonthsBetween}} so that it can be > compatible with systems like oracle. However, there are places where rounding > off is not needed. > E.g "CAST(MONTHS_BETWEEN(l_shipdate, l_commitdate) / 12 AS INT)" may not need > rounding off via BigDecimal which is compute intensive. > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org