SQL query

Overview

The SQL query feature is compatible with MySQL query syntax. It also provides basic SQL Data Definition Language (DDL) capabilities to create tables. For existing data tables, you can run the CREATE TABLE statement to automatically create a mapping. You can then use SQL to access the data in the table.

The SQL query feature supports search indexes to quickly query data that meets specified conditions. When you use the SQL query feature, the system automatically selects an appropriate method to accelerate SQL access.

The SQL query feature is suitable for online data access scenarios that involve massive datasets. The latency of SQL access ranges from milliseconds to minutes. This includes point queries based on the primary keys of data tables (GetRow operations), term queries based on search indexes (TermQuery), and queries that use the statistical aggregation capabilities of search indexes, such as counting the number of rows that meet a condition or calculating the sum of a column.

SQL examples

• You can query the locations of vehicles with a current speed greater than 80.0 km/h and an emission value greater than 2.0 mg.

  select vin_id,gps from `vehicles_metadata` where speed > 80.0 and bms_soc > 2.0 limit 10;

• Find information about vehicles in Hangzhou, Zhejiang Province.

  select vin_id from `vehicles_metadata` where TEXT_MATCH(license_plate_number, "ZheA");

• Count the total number of vehicles in Hangzhou, Zhejiang Province.

  select count(*) from `vehicles_metadata` where TEXT_MATCH(license_plate_number, "ZheA");

Use SQL query

You can use the SQL query feature in the following ways:

• Console

• SDK

• Using JDBC

  • Use SQL query through a direct JDBC connection

  • Use SQL query through Hibernate

  • Use SQL query through MyBatis

• Go driver

FAQ

• How do I select a query method when I use SQL to query data?

• How do I troubleshoot common errors of SQL queries?

• What do I do if the "The sql scanned rows of main table exceeds the quota, main table rows quota is 100000" error message appears when I use SQL to query data?