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

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

Thanks [~nandakumar131]
I think NULL is the better choice, that way we don't return unpadded data.
NULL makes sense with invalid input.


> 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)

Reply via email to