[
https://issues.apache.org/jira/browse/PHOENIX-7201?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nikita Pande reassigned PHOENIX-7201:
-------------------------------------
Assignee: Nikita Pande
> Support LEFT, RIGHT operators as built in functions
> ---------------------------------------------------
>
> Key: PHOENIX-7201
> URL: https://issues.apache.org/jira/browse/PHOENIX-7201
> Project: Phoenix
> Issue Type: Sub-task
> Environment: strong text
> Reporter: Nikita Pande
> Assignee: Nikita Pande
> Priority: Major
>
> When we are validating phoenix with existing databases in our organisation,
> there are few gaps identified wrt built in functions.
> 1. LEFT: [https://www.ibm.com/docs/en/db2-for-zos/12?topic=functions-left
> |http://example.com/]
> {*}Description{*}: The LEFT function returns a string that consists of the
> specified number of
> leftmost bytes of the specified string units.
> {*}Example{*}: Assume that host variable ALPHA has a value of 'ABCDEF'. The
> following
> statement returns '{*}ABC{*}'
> {code:java}
> SELECT LEFT(:ALPHA,3) FROM SYSIBM.SYSDUMMY1; {code}
> 2. RIGHT:[
> [https://www.ibm.com/docs/en/db2-for-zos/12?topic=functions-right]|http://example.com]
> {*}Description{*}: The RIGHT function returns a string that consists of the
> specified number
> of rightmost bytes or specified string unit from a string.
> {*}Example{*}: Assume that host variable ALPHA has a value of 'ABCDEF'. The
> following
> statement returns the value '{*}DEF{*}', which are the three rightmost
> characters in ALPHA
> {code:java}
> SELECT RIGHT(ALPHA,3) FROM SYSIBM.SYSDUMMY1;{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
