[
https://issues.apache.org/jira/browse/SPARK-29854?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16973007#comment-16973007
]
ABHISHEK KUMAR GUPTA commented on SPARK-29854:
----------------------------------------------
[~hyukjin.kwon]: Hi I checked in Hive PostgreSQL : It gives Excpetion
In my SQL It gives NULL
mysql> SELECT lpad('hihhhhhhhhhhhhhhhhhhhhhhh', 500000000000000000000000,
'????????????');
+-----------------------------------------------------------------------------+
| lpad('hihhhhhhhhhhhhhhhhhhhhhhh', 500000000000000000000000, '????????????') |
+-----------------------------------------------------------------------------+
| NULL |
+-----------------------------------------------------------------------------+
1 row in set, 3 warnings (0.00 sec)
mysql> SELECT rpad('hihhhhhhhhhhhhhhhhhhhhhhh', 500000000000000000000000,
'????????????');
+-----------------------------------------------------------------------------+
| rpad('hihhhhhhhhhhhhhhhhhhhhhhh', 500000000000000000000000, '????????????') |
+-----------------------------------------------------------------------------+
| NULL |
+-----------------------------------------------------------------------------+
1 row in set, 3 warnings (0.00 sec)
> 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
> Priority: Minor
>
> 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
