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

["ABHISHEK KUMAR GUPTA (Jira)" <ji...@apache.org>]

ABHISHEK KUMAR GUPTA created SPARK-29854:
--------------------------------------------

             Summary: 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


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

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org