[
https://issues.apache.org/jira/browse/DRILL-6768?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arina Ielchiieva updated DRILL-6768:
------------------------------------
Description:
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|
CAST empty string to null (in case of enabled option) will be supported by
DATE, TIME, TIMESTAMP, INTERVAL YEAR, INTERVAL MONTH and INTERVAL DAY functions
in addition to numeric types.
*For documentations*
TBA
was:
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|
CAST empty string to null (in case of enabled option) will be supported by
DATE, TIME, TIMESTAMP, INTERVAL YEAR, INTERVAL MONTH and INTERVAL DAY functions
in addition to numeric types.
> 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|
> CAST empty string to null (in case of enabled option) will be supported by
> DATE, TIME, TIMESTAMP, INTERVAL YEAR, INTERVAL MONTH and INTERVAL DAY
> functions in addition to numeric types.
>
> *For documentations*
> TBA
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
