[
https://issues.apache.org/jira/browse/DRILL-5476?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arina Ielchiieva updated DRILL-5476:
------------------------------------
Description:
Currently when applying substring / substr / left / right / trim functions
Drill doesn't calculate return length. Since we know calculation rules for
these functions, we can predict return length.
For example:
substring(cast(col as varchar(10), 1, 5) -> varchar(5)
substring(cast(col as varchar(10), 5) -> varchar(5)
Similar changes has been done in DRILL-5419 for other string functions.
was:
Currently when applying substring / substr / left / right functions Drill
doesn't calculate return length. Since we know calculation rules for these
functions, we can predict return length.
For example:
substring(cast(col as varchar(10), 1, 5) -> varchar(5)
substring(cast(col as varchar(10), 5) -> varchar(5)
Similar changes has been done in DRILL-5419 for other string functions.
> Calculate return type precision value for substring functions (substring,
> substr, left, right)
> -----------------------------------------------------------------------------------------------
>
> Key: DRILL-5476
> URL: https://issues.apache.org/jira/browse/DRILL-5476
> Project: Apache Drill
> Issue Type: Improvement
> Affects Versions: 1.10.0
> Reporter: Arina Ielchiieva
> Priority: Minor
>
> Currently when applying substring / substr / left / right / trim functions
> Drill doesn't calculate return length. Since we know calculation rules for
> these functions, we can predict return length.
> For example:
> substring(cast(col as varchar(10), 1, 5) -> varchar(5)
> substring(cast(col as varchar(10), 5) -> varchar(5)
> Similar changes has been done in DRILL-5419 for other string functions.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
