Data types

Basic data types

The following table lists the supported basic data types.

Geographical location data types

Search index supports geo query. When geo query is pushed down to the compute layer, Spark can query and analyze data based on geographical locations in addition to basic types of data.

Geo query includes the following query types: geo-distance query, geo-bounding box query, and geo-polygon query. Geo query is used in scenarios where you need to query information about the IoT devices, orders of food delivery services, locations of punch the clock, and geographical locations of express delivery orders. To use geo query, use the following methods:

• Use search index of Tablestore. For more information, see GeoDistanceQuery.

• Use Spark SQL.

  // Specify the radius and central point for the query.
  select * from table where  val_geo = '{"centerPoint":"3,0", "distanceInMeter": 100000}' and name like 'ali%'
  // Use geo-bounding box query.
  select * from table where geo = '{"topLeft":"8,0", "bottomRight": "0,10"}' and id in { 123 , 321 }
  // Use geo-polygon query.
  select * from table where geo = '{"points":["5,0", "5,1", "6,1", "6,10"]}'

The following table lists the geographical location data types supported by Spark, Scala, search indexes, and tables.