openGeminiLess than 1 minuteAbout 140 words

This chapter mainly introduces the following functions:

selector functionsdescriptions
FIRST()Returns the field value with the oldest timestamp
LAST()Returns the field value with the most recent timestamp
MIN()Returns the lowest field value
MAX()Returns the greatest field value
TOP()Returns the greatest N field values
BOTTOM()Returns the smallest N field values
PERCENTILE()Returns the Nth percentile field value
SAMPLE()Returns a random sample of N field values
SPREAD()Returns the difference between the minimum and maximum field values
PERCENTILE_OGSKETCH()Returns the Nth percentile(approximate) field value


The bold part in the list is the unique method of openGemini. Other methods are compatible with the usage of InfluxDB. You can refer to the corresponding function usage of InfluxDBopen in new window.

The community is working hard to complete the relevant documents.