Mapping functions are a set of specialized functions provided in the OceanBase AI Database system for processing mapped data. These functions enable users to perform complex mapping queries and analyses.
The following table describes some of the mapping functions provided by OceanBase AI Database and their uses:
Types of mapping functions
Mapping Function Type |
Description |
|---|---|
| Constructor of Map | A function for creating a new mapped data type. |
| Mapping judgment function | A function that performs logical judgment on the input mapped data and returns a boolean value. |
| Mapping functions | It is used to perform basic operations on the input map data, such as extracting keys and values, and returns the mapped data after the operation. |
Overview of Mapping Functions
The following table describes all the mapping functions supported by OceanBase AI Database:
Function type |
Function name |
Description |
|---|---|---|
| Constructor of Map | map | Used to construct a mapped data. |
| Constructor of Map | {} | Used to construct a mapped data. |
| Mapping judgment function | =/!= | Determines whether two mapped data are equal. |
| Mapping functions | map_keys | Gets the list of keys in the mapped data. |
| Mapping functions | map_values | Gets the list of values from the mapped data. |