When configuring indexes, you can configure a field as the value type and query the key by using a value range.

Instructions

Supported types: long (long integer) and double (decimal). After configuring a field as the value type, you can only query the key by using a value range.

Example

To query the longkey whose key range is (1000 2000], use the following methods.

  • Use values to query the longkey:

      longKey > 1000 and longKey <= 2000
  • Use an interval to query the longkey:

      longKey in (1000 2000]

For more syntaxes, see Query syntax.