[ https://issues.apache.org/jira/browse/PHOENIX-2476?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kevin Liew updated PHOENIX-2476: -------------------------------- Description: Phoenix uses '||' (Oracle) as the string concatenation operator symbol and does not recognize '+' (SQL Server) or 'concat' (which is used for portability because it is supported by most databases) If we try to use '+' we get an error from the queryserver {noformat}Type mismatch. VARCHAR for (COLUMN1 + KEYCOLUMN){noformat} The '+' operator is not implemented for VARCHAR so it would be an improvement to implement the standard function for that '+' symbol If we try to use 'concat' we get an error: {noformat}org.apache.phoenix.schema.FunctionNotFoundException: ERROR 6001 (42F01): Function undefined. functionName=[CONCAT]{noformat} 'concat' is often used for cross-database compatibility. Most databases provide this function was: Phoenix uses '||' (Oracle) as the string concatenation operator symbol instead of the commonly used '+' (SQL Server) If we try to use '+' we get an error from the queryserver {noformat}Type mismatch. VARCHAR for (COLUMN1 + KEYCOLUMN){noformat} The '+' operator is not implemented for VARCHAR so it would be an improvement to implement the standard function for that '+' symbol > Recognize common string concatenation operator symbols > ------------------------------------------------------ > > Key: PHOENIX-2476 > URL: https://issues.apache.org/jira/browse/PHOENIX-2476 > Project: Phoenix > Issue Type: Improvement > Affects Versions: 4.6.0 > Reporter: Kevin Liew > Priority: Minor > Labels: newbie, phoenix, string > > Phoenix uses '||' (Oracle) as the string concatenation operator symbol and > does not recognize '+' > (SQL Server) or 'concat' (which is used for portability because it is > supported by most databases) > If we try to use '+' we get an error from the queryserver > {noformat}Type mismatch. VARCHAR for (COLUMN1 + KEYCOLUMN){noformat} > The '+' > operator is not implemented for VARCHAR so it would be an improvement to > implement the standard function for that '+' symbol > If we try to use 'concat' we get an error: > {noformat}org.apache.phoenix.schema.FunctionNotFoundException: ERROR 6001 > (42F01): Function undefined. functionName=[CONCAT]{noformat} > 'concat' is often used for cross-database compatibility. Most databases > provide this function -- This message was sent by Atlassian JIRA (v6.3.4#6332)