[
https://issues.apache.org/jira/browse/PHOENIX-7551?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rahul Kumar updated PHOENIX-7551:
---------------------------------
Description:
The purpose of this Jira is to introduce new function for BSON data type to
retrieve the Phoenix data type (PDataType) of the given Bson Document field
value for the given field key.
h2. *Function Grammar:*
*Name:* BSON_VALUE_TYPE
*Arguments:*
| |*Expression*|*DataType*|
|1|Column Value|BSON|
|2|Bson Field Key|The field key can represent any top level or nested fields
within the document. The caller should use "." notation for accessing nested
document elements and "[n]" notation for accessing nested array elements.
Unlike nested fields, top level document fields do not require any additional
character.|
*Definition:* The function returns the Phoenix SQL Data type value of the given
field key/value from the BSON Document.
*Return Type:* VARCHAR
*Examples:*
* BSON_VALUE_TYPE(COL, 'topfield.nestedfield1')
* BSON_VALUE(COL, 'topfield.nestedfield1', BSON_VALUE_TYPE(COL,
'topfield.nestedfield1'))
was:
The purpose of this Jira is to introduce new function for BSON data type to
retrieve the Phoenix data type (PDataType) of the given Bson Document field
value for the given field key.
h2. *Function Grammar:*
*Name:* BSON_DATA_TYPE
*Arguments:*
| |*Expression*|*DataType*|
|1|Column Value|BSON|
|2|Bson Field Key|The field key can represent any top level or nested fields
within the document. The caller should use "." notation for accessing nested
document elements and "[n]" notation for accessing nested array elements.
Unlike nested fields, top level document fields do not require any additional
character.|
*Definition:* The function returns the Phoenix SQL Data type value of the given
field key/value from the BSON Document.
*Return Type:* VARCHAR
*Examples:*
* BSON_DATA_TYPE(COL, 'topfield.nestedfield1')
* BSON_VALUE(COL, 'topfield.nestedfield1', BSON_DATA_TYPE(COL,
'topfield.nestedfield1'))
> BSON_VALUE_TYPE function to return the data type of BSON field value
> --------------------------------------------------------------------
>
> Key: PHOENIX-7551
> URL: https://issues.apache.org/jira/browse/PHOENIX-7551
> Project: Phoenix
> Issue Type: Improvement
> Reporter: Viraj Jasani
> Assignee: Rahul Kumar
> Priority: Major
> Fix For: 5.3.0
>
>
> The purpose of this Jira is to introduce new function for BSON data type to
> retrieve the Phoenix data type (PDataType) of the given Bson Document field
> value for the given field key.
> h2. *Function Grammar:*
> *Name:* BSON_VALUE_TYPE
> *Arguments:*
> | |*Expression*|*DataType*|
> |1|Column Value|BSON|
> |2|Bson Field Key|The field key can represent any top level or nested fields
> within the document. The caller should use "." notation for accessing nested
> document elements and "[n]" notation for accessing nested array elements.
> Unlike nested fields, top level document fields do not require any additional
> character.|
>
> *Definition:* The function returns the Phoenix SQL Data type value of the
> given field key/value from the BSON Document.
> *Return Type:* VARCHAR
> *Examples:*
> * BSON_VALUE_TYPE(COL, 'topfield.nestedfield1')
> * BSON_VALUE(COL, 'topfield.nestedfield1', BSON_VALUE_TYPE(COL,
> 'topfield.nestedfield1'))
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
