PartitionQueryRequest(mapping=None, *, ignore_unknown_fields=False, **kwargs)The request for
PartitionQuery][google.spanner.v1.Spanner.PartitionQuery]
Attributes |
|
|---|---|
| Name | Description |
session |
str
Required. The session used to create the partitions. |
transaction |
google.cloud.spanner_v1.types.TransactionSelector
Read-only snapshot transactions are supported, read and write and single-use transactions are not. |
sql |
str
Required. The query request to generate partitions for. The request fails if the query isn't root partitionable. For a query to be root partitionable, it needs to satisfy a few conditions. For example, if the query execution plan contains a distributed union operator, then it must be the first operator in the plan. For more information about other conditions, see `Read data in parallel |
params |
google.protobuf.struct_pb2.Struct
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="" +="">
It's an error to execute a SQL statement with unbound
parameters.
|
param_types |
MutableMapping[str, google.cloud.spanner_v1.types.Type]
It isn't always possible for Cloud Spanner to infer the right SQL type from a JSON value. For example, values of type BYTES and values of type STRING both appear in
params][google.spanner.v1.PartitionQueryRequest.params] as
JSON strings.
In these cases, param_types can be used to specify the
exact SQL type for some or all of the SQL query parameters.
See the definition of Type][google.spanner.v1.Type] for
more information about SQL types.
|
partition_options |
google.cloud.spanner_v1.types.PartitionOptions
Additional options that affect how many partitions are created. |
Classes
ParamTypesEntry
ParamTypesEntry(mapping=None, *, ignore_unknown_fields=False, **kwargs)The abstract base class for a message.
| Parameters | |
|---|---|
| Name | Description |
kwargs |
dict
Keys and values corresponding to the fields of the message. |
mapping |
Union[dict,
A dictionary or message to be used to determine the values for this message. |
ignore_unknown_fields |
Optional(bool)
If True, do not raise errors for unknown fields. Only applied if |