Tablestore:Data types

Basic data types

The following table describes the supported basic data types.

Geographical location data types

Search indexes support geo query. When a 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 provides the following query types: geo-distance query, geo-bounding box query, and geo-polygon query. Geo query can be used to query information about the locations of IoT devices, locations of food delivery orders, locations of employees when they clock in or out, and locations of express delivery orders. You can use the following methods to perform geo query:

• Use the search indexes of Tablestore. For more information, see Geo-distance query.

• Use Spark SQL.

  • Use geo-distance query by specifying the central point and the radius 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 describes the geographical location data types supported by Spark, Scala, search indexes, and tables.