[ https://issues.apache.org/jira/browse/SPARK-29854?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Takeshi Yamamuro resolved SPARK-29854. -------------------------------------- Fix Version/s: 3.0.0 Assignee: Takeshi Yamamuro Resolution: Fixed Resolved by [https://github.com/apache/spark/pull/28604] > lpad and rpad built in function not throw Exception for invalid len value > ------------------------------------------------------------------------- > > Key: SPARK-29854 > URL: https://issues.apache.org/jira/browse/SPARK-29854 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 3.0.0 > Reporter: ABHISHEK KUMAR GUPTA > Assignee: Takeshi Yamamuro > Priority: Minor > Fix For: 3.0.0 > > > Spark Returns Empty String) > {code} > 0: jdbc:hive2://10.18.19.208:23040/default> SELECT > lpad('hihhhhhhhhhhhhhhhhhhhhhhh', 500000000000000000000000, '????????????'); > +----------------------------------------------------+ > |lpad(hihhhhhhhhhhhhhhhhhhhhhhh, CAST(500000000000000000000000 AS INT), > ????????????)| > +----------------------------------------------------+ > +----------------------------------------------------+ > Hive: > SELECT lpad('hihhhhhhhhhhhhhhhhhhhhhhh', 500000000000000000000000, > '????????????'); > Error: Error while compiling statement: FAILED: SemanticException [Error > 10016]: Line 1:67 Argument type mismatch ''????????????'': lpad only takes > INT/SHORT/BYTE types as 2-ths argument, got DECIMAL (state=42000,code=10016) > PostgreSQL > function lpad(unknown, numeric, unknown) does not exist > > Expected output: > In Spark also it should throw Exception like Hive > {code} > -- 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