GoogleApi.Spanner.V1.Model.PartitionQueryRequest (google_api_spanner v0.23.0) View Source
The request for PartitionQuery
Attributes
-
paramTypes(type:%{optional(String.t) => GoogleApi.Spanner.V1.Model.Type.t}, default:nil) - It is not always possible for Cloud Spanner to infer the right SQL type from a JSON value. For example, values of typeBYTESand values of typeSTRINGboth appear in params as JSON strings. In these cases,param_typescan be used to specify the exact SQL type for some or all of the SQL query parameters. See the definition of Type for more information about SQL types. -
params(type:map(), default:nil) - Parameter names and values that bind to placeholders in the SQL string. A parameter placeholder consists of the@character followed by the parameter name (for example,@firstName). Parameter names can contain letters, numbers, and underscores. Parameters can appear anywhere that a literal value is expected. The same parameter name can be used more than once, for example:"WHERE id > @msg_id AND id < @msg_id + 100"It is an error to execute a SQL statement with unbound parameters. -
partitionOptions(type:GoogleApi.Spanner.V1.Model.PartitionOptions.t, default:nil) - Additional options that affect how many partitions are created. -
sql(type:String.t, default:nil) - Required. The query request to generate partitions for. The request will fail if the query is not root partitionable. The query plan of a root partitionable query has a single distributed union operator. A distributed union operator conceptually divides one or more tables into multiple splits, remotely evaluates a subquery independently on each split, and then unions all results. This must not contain DML commands, such as INSERT, UPDATE, or DELETE. Use ExecuteStreamingSql with a PartitionedDml transaction for large, partition-friendly DML operations. -
transaction(type:GoogleApi.Spanner.V1.Model.TransactionSelector.t, default:nil) - Read only snapshot transactions are supported, read/write and single use transactions are not.
Link to this section Summary
Functions
Unwrap a decoded JSON object into its complex fields.
Link to this section Types
Specs
t() :: %GoogleApi.Spanner.V1.Model.PartitionQueryRequest{
paramTypes: %{optional(String.t()) => GoogleApi.Spanner.V1.Model.Type.t()},
params: map(),
partitionOptions: GoogleApi.Spanner.V1.Model.PartitionOptions.t(),
sql: String.t(),
transaction: GoogleApi.Spanner.V1.Model.TransactionSelector.t()
}
Link to this section Functions
Specs
Unwrap a decoded JSON object into its complex fields.