You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "ABHISHEK KUMAR GUPTA (Jira)" <ji...@apache.org> on 2019/11/12 05:45:00 UTC
[jira] [Updated] (SPARK-29854) lpad and rpad built in function not
throw Exception for invalid len value
[ https://issues.apache.org/jira/browse/SPARK-29854?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ABHISHEK KUMAR GUPTA updated SPARK-29854:
-----------------------------------------
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
was:
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
> 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)
> 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