[ https://issues.apache.org/jira/browse/SPARK-23906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16614307#comment-16614307 ]
Yuming Wang commented on SPARK-23906: ------------------------------------- cc [~dongjoon] It's difficult to reuse {{trunc}} for truncating numbers. How about introduce a new name: {{truncate}}? {code:sql} mysql> SELECT TRUNCATE(1.223,1); -> 1.2 mysql> SELECT TRUNCATE(1.999,1); -> 1.9 mysql> SELECT TRUNCATE(1.999,0); -> 1 mysql> SELECT TRUNCATE(-1.999,1); -> -1.9 mysql> SELECT TRUNCATE(122,-2); -> 100 mysql> SELECT TRUNCATE(10.28*100,0); -> 1028 {code} [https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html#function_truncate] > Add UDF trunc(numeric) > ---------------------- > > Key: SPARK-23906 > URL: https://issues.apache.org/jira/browse/SPARK-23906 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 2.3.0 > Reporter: Xiao Li > Assignee: Yuming Wang > Priority: Major > > https://issues.apache.org/jira/browse/HIVE-14582 > We already have {{date_trunc}} and {{trunc}}. Need to discuss whether we > should introduce a new name or reuse {{trunc}} for truncating numbers. -- 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