You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2020/09/28 19:08:00 UTC

[jira] [Commented] (IMPALA-10175) Extend error message when cast(..format..) fails in parse phase

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

ASF subversion and git services commented on IMPALA-10175:
----------------------------------------------------------

Commit ee9904bc504edb19655bbee045c9b9e6a711eb7b in impala's branch refs/heads/master from Gabor Kaszab
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=ee9904b ]

IMPALA-10175: Extend error msg when CAST(FORMAT) fails for DATE

The previous error message contained only the input string but
including the format string as well would make debugging easier.

Extended error message:
SELECT CAST('0;367' as date format 'YY;DDD');
String to Date parse failed. Input '0;367' doesn't match with
format 'YY;IDD'

Change-Id: I4e379f0f112e83e1511edb170bbe41f903972622
Reviewed-on: http://gerrit.cloudera.org:8080/16473
Tested-by: Impala Public Jenkins <im...@cloudera.com>
Reviewed-by: Zoltan Borok-Nagy <bo...@cloudera.com>


> Extend error message when cast(..format..) fails in parse phase
> ---------------------------------------------------------------
>
>                 Key: IMPALA-10175
>                 URL: https://issues.apache.org/jira/browse/IMPALA-10175
>             Project: IMPALA
>          Issue Type: Improvement
>          Components: Backend
>            Reporter: Gabor Kaszab
>            Assignee: Gabor Kaszab
>            Priority: Major
>              Labels: supportability
>
> {code:java}
> select cast('0;367' as date format 'YY;DDD'); 
> ERROR: UDF ERROR: String to Date parse failed. Invalid string val: "0;367"
> {code}
> Here the output contains the input string but would be more helpful for debugging if it also contained the original format string as well.
> This applies to String to Date conversions only as String to Timestamp failures currently doesn't raise an error.



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

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