[
https://issues.apache.org/jira/browse/IMPALA-8665?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16867261#comment-16867261
]
Gabor Kaszab commented on IMPALA-8665:
--------------------------------------
Hey [~jiawei.wang],
Sorry for the lack of response. I apparently didn't have enough privileges to
add you as a contributor to the project but I see it was sorted out meanwhile.
> Include extra info in error message when date cast fails
> --------------------------------------------------------
>
> Key: IMPALA-8665
> URL: https://issues.apache.org/jira/browse/IMPALA-8665
> Project: IMPALA
> Issue Type: Improvement
> Components: Backend
> Affects Versions: Impala 3.3.0
> Reporter: Gabor Kaszab
> Assignee: Jiawei Wang
> Priority: Major
> Labels: newbie, supportability
>
> {code:java}
> select cast("2000" as date);
> ERROR: UDF ERROR: String to Date parse failed.
> {code}
> If we assume the user has millions of rows in a table and makes a cast on
> them it's hard to debug which one of the made the cast fail as there is no
> indication in the error message. Let's include at least the input value of
> the cast to the message.
> Here we have everything available to do so:
> https://github.com/apache/impala/blob/94652d74521e95e8606ea2d22aabcaddde6fc471/be/src/exprs/cast-functions-ir.cc#L313
> {code:java}
> DateVal CastFunctions::CastToDateVal(FunctionContext* ctx, const StringVal&
> val) {
> if (val.is_null) return DateVal::null();
> DateValue dv = DateValue::Parse(reinterpret_cast<char*>(val.ptr), val.len,
> true);
> if (UNLIKELY(!dv.IsValid())) {
> ctx->SetError("String to Date parse failed.");
> return DateVal::null();
> }
> return dv.ToDateVal();
> }
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org
