You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2018/10/08 09:39:00 UTC
[jira] [Commented] (DRILL-6768) Improve to_date, to_time and
to_timestamp and corresponding cast functions to handle empty string when
`drill.exec.functions.cast_empty_string_to_null` option is enabled
[ https://issues.apache.org/jira/browse/DRILL-6768?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16641588#comment-16641588 ]
ASF GitHub Bot commented on DRILL-6768:
---------------------------------------
KazydubB opened a new pull request #1494: DRILL-6768: Improve to_date, to_time and to_timestamp and correspondi…
URL: https://github.com/apache/drill/pull/1494
…ng cast functions to handle empty string when `drill.exec.functions.cast_empty_string_to_null` option is enabled.
See [DRILL-6768](https://issues.apache.org/jira/browse/DRILL-6768) for details.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
> Improve to_date, to_time and to_timestamp and corresponding cast functions to handle empty string when `drill.exec.functions.cast_empty_string_to_null` option is enabled
> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DRILL-6768
> URL: https://issues.apache.org/jira/browse/DRILL-6768
> Project: Apache Drill
> Issue Type: Improvement
> Affects Versions: 1.14.0
> Reporter: Bohdan Kazydub
> Assignee: Bohdan Kazydub
> Priority: Major
> Labels: doc-impacting
> Fix For: 1.15.0
>
>
> When `drill.exec.functions.cast_empty_string_to_null` option is enabled
> `to_date`, `to_time` and `to_timestamp` functions while converting string to according type in case if null or empty string values are passed will return NULL (to avoid CASE clauses which are littering a query and will work in accordance with their respective CAST counterparts) for both cases.
>
>
>
> CASTs will be handled in a similar way (uniformly with numeric types):
>
> ||Value to cast||Now||Will be||
> |NULL|NULL|NULL|
> |'' (empty string)|Error in many cases (except numerical types)|NULL|
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)