Public API Functins Overview¶
Standard PostgreSQL functions cannot meet all business requirements, so Hologres added some new functions as public API which can be used to simplify development process. Next chapter will describe public API functions in detail. Below table lists all those public API functions:
Function | Description |
---|---|
APPROX_COUNT_DISTINCT | Aggregation function |
GET_JSON_OBJECT | Hive compatible function |
HG_CREATE_TABLE_LIKE | Helper function |
HG_UPDATE_DATABASE_PROPERTY | Helper function |
SET_TABLE_PROPERTY | Helper function |
HG_SHARD_ID_FOR_DISTRIBUTION_KEY | Helper function |