You can execute the create table statement to create a mapping table for an existing data table or search index.
Note For more information about the create table statement, see Create mapping tables for tables.
Prerequisites
A Tablestore client is initialized. For more information, see Initialization.
Parameters
Parameter | Description |
---|---|
query | The SQL statement. Configure the parameter based on the required feature. |
Examples
Execute the create table test_table (pk varchar(1024), long_value bigint, double_value double,
string_value mediumtext, bool_value bool, primary key(pk))
statement to create a mapping table for the table named test_table.
func createMappingTable(client *tablestore.TableStoreClient) {
// Create a SQL request.
request := &tablestore.SQLQueryRequest{Query: "create table test_table (pk varchar(1024), long_value bigint, double_value double, string_value mediumtext, bool_value bool, primary key(pk))"}
// Obtain the response to the SQL request.
response, err := client.SQLQuery(request)
}