hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thejas M Nair (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-15792) Hive should raise SemanticException when LPAD/RPAD pad character's length is 0
Date Thu, 02 Feb 2017 17:49:51 GMT

    [ https://issues.apache.org/jira/browse/HIVE-15792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15850232#comment-15850232
] 

Thejas M Nair commented on HIVE-15792:
--------------------------------------

There are couple of options here. It would be better to follow the convention followed by
some of the other databases, like  postgres and mysql with this regard. Can you take a look
at what they do ?
Its cleaner to have this check in the UDF itself rather than in semantic analyzer.


> Hive should raise SemanticException when LPAD/RPAD pad character's length is 0
> ------------------------------------------------------------------------------
>
>                 Key: HIVE-15792
>                 URL: https://issues.apache.org/jira/browse/HIVE-15792
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Zoltan Chovan
>            Assignee: Nandakumar
>            Priority: Minor
>
> For example SELECT LPAD('A', 2, ''); will cause an infinite loop and the running query
will hang without any error.
> It would be great if this could be prevented by checking the pad character's length and
if it's 0 then throw a SemanticException.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message