[SPARK-29854] lpad and rpad built in function not throw Exception for invalid len value

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Takeshi Yamamuro
• Reporter: ABHISHEK KUMAR GUPTA
• Created: 12/Nov/19 05:41
• Updated: 12/Dec/22 18:11
• Resolved: 22/May/20 23:50

Description

Spark Returns Empty String)

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

 

Issue Links

• links to: [Github] Pull Request #28604 (maropu)
• links to: GitHub Pull Request #27024