When configuring indexes, you can configure a field as the value type and query the key by using a value range.
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.
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.