[jira] [Commented] (SPARK-29853) lpad returning empty instead of NULL for empty pad value
[ https://issues.apache.org/jira/browse/SPARK-29853?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16972079#comment-16972079 ] Ankit Raj Boudh commented on SPARK-29853: - @[~hyukjin.kwon] , please review the PR. > lpad returning empty instead of NULL for empty pad value > > > Key: SPARK-29853 > URL: https://issues.apache.org/jira/browse/SPARK-29853 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 3.0.0 >Reporter: ABHISHEK KUMAR GUPTA >Priority: Minor > > Spark > 0: jdbc:hive2://10.18.18.214:23040/default> SELECT lpad('hi', 5, ''); > ++--+ > | lpad(hi, 5, ) | > ++--+ > | hi | > ++--+ > 1 row selected (0.186 seconds) > Hive: > INFO : Concurrency mode is disabled, not creating a lock manager > +---+ > | _c0 | > +---+ > | NULL | > +---+ -- 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-29853) lpad returning empty instead of NULL for empty pad value
[ https://issues.apache.org/jira/browse/SPARK-29853?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16972073#comment-16972073 ] Ankit Raj Boudh commented on SPARK-29853: - i will PR for this > lpad returning empty instead of NULL for empty pad value > > > Key: SPARK-29853 > URL: https://issues.apache.org/jira/browse/SPARK-29853 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 3.0.0 >Reporter: ABHISHEK KUMAR GUPTA >Priority: Minor > > Spark > 0: jdbc:hive2://10.18.18.214:23040/default> SELECT lpad('hi', 5, ''); > ++--+ > | lpad(hi, 5, ) | > ++--+ > | hi | > ++--+ > 1 row selected (0.186 seconds) > Hive: > INFO : Concurrency mode is disabled, not creating a lock manager > +---+ > | _c0 | > +---+ > | NULL | > +---+ -- 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