Field types
Field type | Description | Support for multiple values | Used for forward indexes | Used for summary indexes | Used for inverted indexes |
TEXT | Stores text data. | Not supported | Not supported | Supported | Supported |
STRING | Stores strings. | Supported | Supported | Supported | Supported |
INT8 | Stores 8-bit signed integers. | Supported | Supported | Supported | Supported |
UINT8 | Stores 8-bit unsigned integers. | Supported | Supported | Supported | Supported |
INT16 | Stores 16-bit signed integers. | Supported | Supported | Supported | Supported |
UINT16 | Stores 16-bit unsigned integers. | Supported | Supported | Supported | Supported |
INTEGER | Stores 32-bit signed integers. | Supported | Supported | Supported | Supported |
UINT32 | Stores 32-bit unsigned integers. | Supported | Supported | Supported | Supported |
INT64 | Stores 64-bit signed integers. | Supported | Supported | Supported | Supported |
UINT64 | Stores 64-bit unsigned integers. | Supported | Supported | Supported | Supported |
FLOAT | Stores single-precision 32-bit floating points. | Supported | Supported | Supported | Not supported |
DOUBLE | Stores double-precision 64-bit floating points. | Supported | Supported | Supported | Not supported |
LOCATION | Stores the longitude and latitude of a point. | Supported | Supported | Supported | Supported |
LINE | Stores the latitudes and longitudes of the points that form a polyline. The first value represents the number of points on the polyline. | Supported | Supported | Supported | Supported |
POLYGON | Stores the longitudes and latitudes of the points that form a polygon. The value is a combination of multiple polylines. For each polyline, the first value represents the number of points on the polyline. | Supported | Supported | Supported | Supported |
DATE | Stores date values. | Not supported | Not supported | Supported | Supported |
TIME | Stores time values. | Not supported | Not supported | Supported | Supported |
TIMESTAMP | Stores timestamps in the {DATE} {TIME} [TIMEZONE (optional)] format. | Not supported | Not supported | Supported | Supported |
You must specify an analyzer for fields of the TEXT type when you configure a schema.
You can specify values for fields of the LOCATION data type in the location={Longitude} {Latitude} format, such as location=116 40.
You can specify values for fields of the LINE data type in the line=location,location,location...^] format, such as line=116 40,117 41,118 42 ^].
You can specify values for fields of the POLYGON data type in the polygon=location1,location2,...location1^] format.
You can specify values for fields of the DATE data type in the year-month-day format, such as 2020-08-19.
You can specify values for fields of the TIME data type in the hour:minute:second[.milliSeconds] format. The milliSeconds parameter is optional. For example, a time value can be 11:40:00.234 or 12:00:00.
You can specify values for fields of the TIMESTAMP data type in the {DATE} {TIME} [TIMEZONE] format. The TIMEZONE parameter specifies a time zone and is optional. For example, a timestamp value can be 2020-08-19 11:40:00.234 or 2020-08-19 11:40.00.234+0800. By default, the time zone is specified by using the offset from Coordinated Universal Time (UTC). You can specify the default time zone.