Query data with SQL

Prerequisites

• Install the Tablestore SDK for Java and initialize a client.

• Use Tablestore SDK for Java 5.13.0 or later.

• Create a mapping table for the data table or search index that you want to query.

Description

Call the sqlQuery method to execute a SELECT statement and query data from a mapping table. The result contains the field schema and the rows that match the query conditions.

SQLQueryResponse sqlQuery(SQLQueryRequest request)

The following example queries rows whose tenant_id value is 1 from the example_table mapping table and returns up to 10 rows.

String query = "SELECT tenant_id, pk, name, score FROM example_table "
        + "WHERE tenant_id = 1 LIMIT 10";
SQLQueryRequest request = new SQLQueryRequest(query);

SQLQueryResponse response = client.sqlQuery(request);
SQLResultSet resultSet = response.getSQLResultSet();
System.out.println("Schema: " + resultSet.getSQLTableMeta().getSchema());

while (resultSet.hasNext()) {
    SQLRow row = resultSet.next();
    System.out.println(
            row.getLong("tenant_id") + ", "
                    + row.getString("pk") + ", "
                    + row.getString("name") + ", "
                    + row.getLong("score"));
}

Parameters

SQLQueryRequest contains the following parameter.

Response

SQLQueryResponse contains the following fields related to the query result.