[ 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)