[ https://issues.apache.org/jira/browse/PHOENIX-7585?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Viraj Jasani updated PHOENIX-7585: ---------------------------------- Description: PHOENIX-7463 provides us with the ability to generate and evaluate AST (Abstract Syntax Tree) for the BSON condition expression evaluation for it's SQL type expressions. The purpose of this Jira is to provide a new internal function (similar to field_exists(), field_not_exists() etc) within BSON_CONDITION_EXPRESSION() such that it can identify whether the value of the given document field of type BsonString or BsonBinary has prefix value as the constant provided in the second argument. begins_with(fieldKey, substr) => here, fieldKey represents field key's path in the given BSON document. substr represents value which needs to be compared as the prefix value of path field from the document. The function should only support BsonString and BsonBinary types for prefix search. was: PHOENIX-7463 provides us with the ability to generate and evaluate AST (Abstract Syntax Tree) for the BSON condition expression evaluation for it's SQL type expressions. The purpose of this Jira is to provide a new internal function (similar to field_exists(), field_not_exists() etc) within BSON_CONDITION_EXPRESSION() function such that it can identify whether the value of the given document field of type BsonString or BsonBinary has prefix value as the constant provided in the second argument. begins_with(path, substr) => here, path represents path in the given BSON document. substr represents value which needs to be compared as the prefix value of path field from the document. The function should only support BsonString and BsonBinary types for prefix search. > New BSON Condition Function begins_with() > ----------------------------------------- > > Key: PHOENIX-7585 > URL: https://issues.apache.org/jira/browse/PHOENIX-7585 > Project: Phoenix > Issue Type: New Feature > Reporter: Viraj Jasani > Assignee: Viraj Jasani > Priority: Major > Fix For: 5.3.0 > > > PHOENIX-7463 provides us with the ability to generate and evaluate AST > (Abstract Syntax Tree) for the BSON condition expression evaluation for it's > SQL type expressions. > The purpose of this Jira is to provide a new internal function (similar to > field_exists(), field_not_exists() etc) within BSON_CONDITION_EXPRESSION() > such that it can identify whether the value of the given document field of > type BsonString or BsonBinary has prefix value as the constant provided in > the second argument. > begins_with(fieldKey, substr) => here, fieldKey represents field key's path > in the given BSON document. substr represents value which needs to be > compared as the prefix value of path field from the document. The function > should only support BsonString and BsonBinary types for prefix search. -- This message was sent by Atlassian Jira (v8.20.10#820010)