Viraj Jasani created PHOENIX-7551:
-------------------------------------
Summary: BSON_DATA_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
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'))
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
