public sealed class PartitionQueryRequest : IMessage<PartitionQueryRequest>, IEquatable<PartitionQueryRequest>, IDeepCloneable<PartitionQueryRequest>, IBufferMessage, IMessageReference documentation and code samples for the Google Cloud Spanner v1 API class PartitionQueryRequest.
The request for [PartitionQuery][google.spanner.v1.Spanner.PartitionQuery]
Implements
IMessagePartitionQueryRequest, IEquatablePartitionQueryRequest, IDeepCloneablePartitionQueryRequest, IBufferMessage, IMessageNamespace
Google.Cloud.Spanner.V1Assembly
Google.Cloud.Spanner.V1.dll
Constructors
PartitionQueryRequest()
public PartitionQueryRequest()PartitionQueryRequest(PartitionQueryRequest)
public PartitionQueryRequest(PartitionQueryRequest other)| Parameter | |
|---|---|
| Name | Description |
other |
PartitionQueryRequest |
Properties
ParamTypes
public MapField<string, Type> ParamTypes { get; }It is not 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.
| Property Value | |
|---|---|
| Type | Description |
MapFieldstringType |
|
Params
public Struct Params { get; set; }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.
| Property Value | |
|---|---|
| Type | Description |
Struct |
|
PartitionOptions
public PartitionOptions PartitionOptions { get; set; }Additional options that affect how many partitions are created.
| Property Value | |
|---|---|
| Type | Description |
PartitionOptions |
|
Session
public string Session { get; set; }Required. The session used to create the partitions.
| Property Value | |
|---|---|
| Type | Description |
string |
|
SessionAsSessionName
public SessionName SessionAsSessionName { get; set; }SessionName-typed view over the Session resource name property.
| Property Value | |
|---|---|
| Type | Description |
SessionName |
|
Sql
public string Sql { get; set; }Required. The query request to generate partitions for. The request will fail if the query is not 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.
The query request must not contain DML commands, such as INSERT, UPDATE, or DELETE. Use [ExecuteStreamingSql][google.spanner.v1.Spanner.ExecuteStreamingSql] with a PartitionedDml transaction for large, partition-friendly DML operations.
| Property Value | |
|---|---|
| Type | Description |
string |
|
Transaction
public TransactionSelector Transaction { get; set; }Read only snapshot transactions are supported, read/write and single use transactions are not.
| Property Value | |
|---|---|
| Type | Description |
TransactionSelector |
|