Class PartialResultSet.Builder (6.54.0)

public static final class PartialResultSet.Builder extends GeneratedMessageV3.Builder<PartialResultSet.Builder> implements PartialResultSetOrBuilder

Partial results from a streaming read or SQL query. Streaming reads and SQL queries better tolerate large result sets, large rows, and large values, but are a little trickier to consume.

Protobuf type google.spanner.v1.PartialResultSet

Static Methods

getDescriptor()

public static final Descriptors.Descriptor getDescriptor()
Returns
TypeDescription
Descriptor

Methods

addAllValues(Iterable<? extends Value> values)

public PartialResultSet.Builder addAllValues(Iterable<? extends Value> values)

A streamed result set consists of a stream of values, which might be split into many PartialResultSet messages to accommodate large rows and/or large values. Every N complete values defines a row, where N is equal to the number of entries in metadata.row_type.fields.

Most values are encoded based on type as described here.

It is possible that the last value in values is "chunked", meaning that the rest of the value is sent in subsequent PartialResultSet(s). This is denoted by the chunked_value field. Two or more chunked values can be merged to form a complete value as follows:

  • bool/number/null: cannot be chunked
  • string: concatenate the strings
  • list: concatenate the lists. If the last element in a list is a string, list, or object, merge it with the first element in the next list by applying these rules recursively.
  • object: concatenate the (field name, field value) pairs. If a field name is duplicated, then apply these rules recursively to merge the field values.

    Some examples of merging:

    Strings are concatenated.

    "foo", "bar" => "foobar"

    Lists of non-strings are concatenated.

    [2, 3], [4] => [2, 3, 4]

    Lists are concatenated, but the last and first elements are merged

    because they are strings.

    ["a", "b"], ["c", "d"] => ["a", "bc", "d"]

    Lists are concatenated, but the last and first elements are merged

    because they are lists. Recursively, the last and first elements

    of the inner lists are merged because they are strings.

    ["a", ["b", "c"]], [["d"], "e"] => ["a", ["b", "cd"], "e"]

    Non-overlapping object fields are combined.

    {"a": "1"}, {"b": "2"} => {"a": "1", "b": 2"}

    Overlapping object fields are merged.

    {"a": "1"}, {"a": "2"} => {"a": "12"}

    Examples of merging objects containing lists of strings.

    {"a": ["1"]}, {"a": ["2"]} => {"a": ["12"]}

    For a more complete example, suppose a streaming SQL query is yielding a result set whose rows contain a single string field. The following PartialResultSets might be yielded:

    { "metadata": { ... } "values": ["Hello", "W"] "chunked_value": true "resume_token": "Af65..." } { "values": ["orl"] "chunked_value": true "resume_token": "Bqp2..." } { "values": ["d"] "resume_token": "Zx1B..." }

    This sequence of PartialResultSets encodes two rows, one containing the field value "Hello", and a second containing the field value "World" = "W" + "orl" + "d".

repeated .google.protobuf.Value values = 2;

Parameter
NameDescription
valuesIterable<? extends com.google.protobuf.Value>
Returns
TypeDescription
PartialResultSet.Builder

addRepeatedField(Descriptors.FieldDescriptor field, Object value)

public PartialResultSet.Builder addRepeatedField(Descriptors.FieldDescriptor field, Object value)
Parameters
NameDescription
fieldFieldDescriptor
valueObject
Returns
TypeDescription
PartialResultSet.Builder
Overrides

addValues(Value value)

public PartialResultSet.Builder addValues(Value value)

A streamed result set consists of a stream of values, which might be split into many PartialResultSet messages to accommodate large rows and/or large values. Every N complete values defines a row, where N is equal to the number of entries in metadata.row_type.fields.

Most values are encoded based on type as described here.

It is possible that the last value in values is "chunked", meaning that the rest of the value is sent in subsequent PartialResultSet(s). This is denoted by the chunked_value field. Two or more chunked values can be merged to form a complete value as follows:

  • bool/number/null: cannot be chunked
  • string: concatenate the strings
  • list: concatenate the lists. If the last element in a list is a string, list, or object, merge it with the first element in the next list by applying these rules recursively.
  • object: concatenate the (field name, field value) pairs. If a field name is duplicated, then apply these rules recursively to merge the field values.

    Some examples of merging:

    Strings are concatenated.

    "foo", "bar" => "foobar"

    Lists of non-strings are concatenated.

    [2, 3], [4] => [2, 3, 4]

    Lists are concatenated, but the last and first elements are merged

    because they are strings.

    ["a", "b"], ["c", "d"] => ["a", "bc", "d"]

    Lists are concatenated, but the last and first elements are merged

    because they are lists. Recursively, the last and first elements

    of the inner lists are merged because they are strings.

    ["a", ["b", "c"]], [["d"], "e"] => ["a", ["b", "cd"], "e"]

    Non-overlapping object fields are combined.

    {"a": "1"}, {"b": "2"} => {"a": "1", "b": 2"}

    Overlapping object fields are merged.

    {"a": "1"}, {"a": "2"} => {"a": "12"}

    Examples of merging objects containing lists of strings.

    {"a": ["1"]}, {"a": ["2"]} => {"a": ["12"]}

    For a more complete example, suppose a streaming SQL query is yielding a result set whose rows contain a single string field. The following PartialResultSets might be yielded:

    { "metadata": { ... } "values": ["Hello", "W"] "chunked_value": true "resume_token": "Af65..." } { "values": ["orl"] "chunked_value": true "resume_token": "Bqp2..." } { "values": ["d"] "resume_token": "Zx1B..." }

    This sequence of PartialResultSets encodes two rows, one containing the field value "Hello", and a second containing the field value "World" = "W" + "orl" + "d".

repeated .google.protobuf.Value values = 2;

Parameter
NameDescription
valueValue
Returns
TypeDescription
PartialResultSet.Builder

addValues(Value.Builder builderForValue)

public PartialResultSet.Builder addValues(Value.Builder builderForValue)

A streamed result set consists of a stream of values, which might be split into many PartialResultSet messages to accommodate large rows and/or large values. Every N complete values defines a row, where N is equal to the number of entries in metadata.row_type.fields.

Most values are encoded based on type as described here.

It is possible that the last value in values is "chunked", meaning that the rest of the value is sent in subsequent PartialResultSet(s). This is denoted by the chunked_value field. Two or more chunked values can be merged to form a complete value as follows:

  • bool/number/null: cannot be chunked
  • string: concatenate the strings
  • list: concatenate the lists. If the last element in a list is a string, list, or object, merge it with the first element in the next list by applying these rules recursively.
  • object: concatenate the (field name, field value) pairs. If a field name is duplicated, then apply these rules recursively to merge the field values.

    Some examples of merging:

    Strings are concatenated.

    "foo", "bar" => "foobar"

    Lists of non-strings are concatenated.

    [2, 3], [4] => [2, 3, 4]

    Lists are concatenated, but the last and first elements are merged

    because they are strings.

    ["a", "b"], ["c", "d"] => ["a", "bc", "d"]

    Lists are concatenated, but the last and first elements are merged

    because they are lists. Recursively, the last and first elements

    of the inner lists are merged because they are strings.

    ["a", ["b", "c"]], [["d"], "e"] => ["a", ["b", "cd"], "e"]

    Non-overlapping object fields are combined.

    {"a": "1"}, {"b": "2"} => {"a": "1", "b": 2"}

    Overlapping object fields are merged.

    {"a": "1"}, {"a": "2"} => {"a": "12"}

    Examples of merging objects containing lists of strings.

    {"a": ["1"]}, {"a": ["2"]} => {"a": ["12"]}

    For a more complete example, suppose a streaming SQL query is yielding a result set whose rows contain a single string field. The following PartialResultSets might be yielded:

    { "metadata": { ... } "values": ["Hello", "W"] "chunked_value": true "resume_token": "Af65..." } { "values": ["orl"] "chunked_value": true "resume_token": "Bqp2..." } { "values": ["d"] "resume_token": "Zx1B..." }

    This sequence of PartialResultSets encodes two rows, one containing the field value "Hello", and a second containing the field value "World" = "W" + "orl" + "d".

repeated .google.protobuf.Value values = 2;

Parameter
NameDescription
builderForValueBuilder
Returns
TypeDescription
PartialResultSet.Builder

addValues(int index, Value value)

public PartialResultSet.Builder addValues(int index, Value value)

A streamed result set consists of a stream of values, which might be split into many PartialResultSet messages to accommodate large rows and/or large values. Every N complete values defines a row, where N is equal to the number of entries in metadata.row_type.fields.

Most values are encoded based on type as described here.

It is possible that the last value in values is "chunked", meaning that the rest of the value is sent in subsequent PartialResultSet(s). This is denoted by the chunked_value field. Two or more chunked values can be merged to form a complete value as follows:

  • bool/number/null: cannot be chunked
  • string: concatenate the strings
  • list: concatenate the lists. If the last element in a list is a string, list, or object, merge it with the first element in the next list by applying these rules recursively.
  • object: concatenate the (field name, field value) pairs. If a field name is duplicated, then apply these rules recursively to merge the field values.

    Some examples of merging:

    Strings are concatenated.

    "foo", "bar" => "foobar"

    Lists of non-strings are concatenated.

    [2, 3], [4] => [2, 3, 4]

    Lists are concatenated, but the last and first elements are merged

    because they are strings.

    ["a", "b"], ["c", "d"] => ["a", "bc", "d"]

    Lists are concatenated, but the last and first elements are merged

    because they are lists. Recursively, the last and first elements

    of the inner lists are merged because they are strings.

    ["a", ["b", "c"]], [["d"], "e"] => ["a", ["b", "cd"], "e"]

    Non-overlapping object fields are combined.

    {"a": "1"}, {"b": "2"} => {"a": "1", "b": 2"}

    Overlapping object fields are merged.

    {"a": "1"}, {"a": "2"} => {"a": "12"}

    Examples of merging objects containing lists of strings.

    {"a": ["1"]}, {"a": ["2"]} => {"a": ["12"]}

    For a more complete example, suppose a streaming SQL query is yielding a result set whose rows contain a single string field. The following PartialResultSets might be yielded:

    { "metadata": { ... } "values": ["Hello", "W"] "chunked_value": true "resume_token": "Af65..." } { "values": ["orl"] "chunked_value": true "resume_token": "Bqp2..." } { "values": ["d"] "resume_token": "Zx1B..." }

    This sequence of PartialResultSets encodes two rows, one containing the field value "Hello", and a second containing the field value "World" = "W" + "orl" + "d".

repeated .google.protobuf.Value values = 2;

Parameters
NameDescription
indexint
valueValue
Returns
TypeDescription
PartialResultSet.Builder

addValues(int index, Value.Builder builderForValue)

public PartialResultSet.Builder addValues(int index, Value.Builder builderForValue)

A streamed result set consists of a stream of values, which might be split into many PartialResultSet messages to accommodate large rows and/or large values. Every N complete values defines a row, where N is equal to the number of entries in metadata.row_type.fields.

Most values are encoded based on type as described here.

It is possible that the last value in values is "chunked", meaning that the rest of the value is sent in subsequent PartialResultSet(s). This is denoted by the chunked_value field. Two or more chunked values can be merged to form a complete value as follows:

  • bool/number/null: cannot be chunked
  • string: concatenate the strings
  • list: concatenate the lists. If the last element in a list is a string, list, or object, merge it with the first element in the next list by applying these rules recursively.
  • object: concatenate the (field name, field value) pairs. If a field name is duplicated, then apply these rules recursively to merge the field values.

    Some examples of merging:

    Strings are concatenated.

    "foo", "bar" => "foobar"

    Lists of non-strings are concatenated.

    [2, 3], [4] => [2, 3, 4]

    Lists are concatenated, but the last and first elements are merged

    because they are strings.

    ["a", "b"], ["c", "d"] => ["a", "bc", "d"]

    Lists are concatenated, but the last and first elements are merged

    because they are lists. Recursively, the last and first elements

    of the inner lists are merged because they are strings.

    ["a", ["b", "c"]], [["d"], "e"] => ["a", ["b", "cd"], "e"]

    Non-overlapping object fields are combined.

    {"a": "1"}, {"b": "2"} => {"a": "1", "b": 2"}

    Overlapping object fields are merged.

    {"a": "1"}, {"a": "2"} => {"a": "12"}

    Examples of merging objects containing lists of strings.

    {"a": ["1"]}, {"a": ["2"]} => {"a": ["12"]}

    For a more complete example, suppose a streaming SQL query is yielding a result set whose rows contain a single string field. The following PartialResultSets might be yielded:

    { "metadata": { ... } "values": ["Hello", "W"] "chunked_value": true "resume_token": "Af65..." } { "values": ["orl"] "chunked_value": true "resume_token": "Bqp2..." } { "values": ["d"] "resume_token": "Zx1B..." }

    This sequence of PartialResultSets encodes two rows, one containing the field value "Hello", and a second containing the field value "World" = "W" + "orl" + "d".

repeated .google.protobuf.Value values = 2;

Parameters
NameDescription
indexint
builderForValueBuilder
Returns
TypeDescription
PartialResultSet.Builder

addValuesBuilder()

public Value.Builder addValuesBuilder()

A streamed result set consists of a stream of values, which might be split into many PartialResultSet messages to accommodate large rows and/or large values. Every N complete values defines a row, where N is equal to the number of entries in metadata.row_type.fields.

Most values are encoded based on type as described here.

It is possible that the last value in values is "chunked", meaning that the rest of the value is sent in subsequent PartialResultSet(s). This is denoted by the chunked_value field. Two or more chunked values can be merged to form a complete value as follows:

  • bool/number/null: cannot be chunked
  • string: concatenate the strings
  • list: concatenate the lists. If the last element in a list is a string, list, or object, merge it with the first element in the next list by applying these rules recursively.
  • object: concatenate the (field name, field value) pairs. If a field name is duplicated, then apply these rules recursively to merge the field values.

    Some examples of merging:

    Strings are concatenated.

    "foo", "bar" => "foobar"

    Lists of non-strings are concatenated.

    [2, 3], [4] => [2, 3, 4]

    Lists are concatenated, but the last and first elements are merged

    because they are strings.

    ["a", "b"], ["c", "d"] => ["a", "bc", "d"]

    Lists are concatenated, but the last and first elements are merged

    because they are lists. Recursively, the last and first elements

    of the inner lists are merged because they are strings.

    ["a", ["b", "c"]], [["d"], "e"] => ["a", ["b", "cd"], "e"]

    Non-overlapping object fields are combined.

    {"a": "1"}, {"b": "2"} => {"a": "1", "b": 2"}

    Overlapping object fields are merged.

    {"a": "1"}, {"a": "2"} => {"a": "12"}

    Examples of merging objects containing lists of strings.

    {"a": ["1"]}, {"a": ["2"]} => {"a": ["12"]}

    For a more complete example, suppose a streaming SQL query is yielding a result set whose rows contain a single string field. The following PartialResultSets might be yielded:

    { "metadata": { ... } "values": ["Hello", "W"] "chunked_value": true "resume_token": "Af65..." } { "values": ["orl"] "chunked_value": true "resume_token": "Bqp2..." } { "values": ["d"] "resume_token": "Zx1B..." }

    This sequence of PartialResultSets encodes two rows, one containing the field value "Hello", and a second containing the field value "World" = "W" + "orl" + "d".

repeated .google.protobuf.Value values = 2;

Returns
TypeDescription
Builder

addValuesBuilder(int index)

public Value.Builder addValuesBuilder(int index)

A streamed result set consists of a stream of values, which might be split into many PartialResultSet messages to accommodate large rows and/or large values. Every N complete values defines a row, where N is equal to the number of entries in metadata.row_type.fields.

Most values are encoded based on type as described here.

It is possible that the last value in values is "chunked", meaning that the rest of the value is sent in subsequent PartialResultSet(s). This is denoted by the chunked_value field. Two or more chunked values can be merged to form a complete value as follows:

  • bool/number/null: cannot be chunked
  • string: concatenate the strings
  • list: concatenate the lists. If the last element in a list is a string, list, or object, merge it with the first element in the next list by applying these rules recursively.
  • object: concatenate the (field name, field value) pairs. If a field name is duplicated, then apply these rules recursively to merge the field values.

    Some examples of merging:

    Strings are concatenated.

    "foo", "bar" => "foobar"

    Lists of non-strings are concatenated.

    [2, 3], [4] => [2, 3, 4]

    Lists are concatenated, but the last and first elements are merged

    because they are strings.

    ["a", "b"], ["c", "d"] => ["a", "bc", "d"]

    Lists are concatenated, but the last and first elements are merged

    because they are lists. Recursively, the last and first elements

    of the inner lists are merged because they are strings.

    ["a", ["b", "c"]], [["d"], "e"] => ["a", ["b", "cd"], "e"]

    Non-overlapping object fields are combined.

    {"a": "1"}, {"b": "2"} => {"a": "1", "b": 2"}

    Overlapping object fields are merged.

    {"a": "1"}, {"a": "2"} => {"a": "12"}

    Examples of merging objects containing lists of strings.

    {"a": ["1"]}, {"a": ["2"]} => {"a": ["12"]}

    For a more complete example, suppose a streaming SQL query is yielding a result set whose rows contain a single string field. The following PartialResultSets might be yielded:

    { "metadata": { ... } "values": ["Hello", "W"] "chunked_value": true "resume_token": "Af65..." } { "values": ["orl"] "chunked_value": true "resume_token": "Bqp2..." } { "values": ["d"] "resume_token": "Zx1B..." }

    This sequence of PartialResultSets encodes two rows, one containing the field value "Hello", and a second containing the field value "World" = "W" + "orl" + "d".

repeated .google.protobuf.Value values = 2;

Parameter
NameDescription
indexint
Returns
TypeDescription
Builder

build()

public PartialResultSet build()
Returns
TypeDescription
PartialResultSet

buildPartial()

public PartialResultSet buildPartial()
Returns
TypeDescription
PartialResultSet

clear()

public PartialResultSet.Builder clear()
Returns
TypeDescription
PartialResultSet.Builder
Overrides

clearChunkedValue()

public PartialResultSet.Builder clearChunkedValue()

If true, then the final value in values is chunked, and must be combined with more values from subsequent PartialResultSets to obtain a complete field value.

bool chunked_value = 3;

Returns
TypeDescription
PartialResultSet.Builder

This builder for chaining.

clearField(Descriptors.FieldDescriptor field)

public PartialResultSet.Builder clearField(Descriptors.FieldDescriptor field)
Parameter
NameDescription
fieldFieldDescriptor
Returns
TypeDescription
PartialResultSet.Builder
Overrides

clearMetadata()

public PartialResultSet.Builder clearMetadata()

Metadata about the result set, such as row type information. Only present in the first response.

.google.spanner.v1.ResultSetMetadata metadata = 1;

Returns
TypeDescription
PartialResultSet.Builder

clearOneof(Descriptors.OneofDescriptor oneof)

public PartialResultSet.Builder clearOneof(Descriptors.OneofDescriptor oneof)
Parameter
NameDescription
oneofOneofDescriptor
Returns
TypeDescription
PartialResultSet.Builder
Overrides

clearResumeToken()

public PartialResultSet.Builder clearResumeToken()

Streaming calls might be interrupted for a variety of reasons, such as TCP connection loss. If this occurs, the stream of results can be resumed by re-sending the original request and including resume_token. Note that executing any other transaction in the same session invalidates the token.

bytes resume_token = 4;

Returns
TypeDescription
PartialResultSet.Builder

This builder for chaining.

clearStats()

public PartialResultSet.Builder clearStats()

Query plan and execution statistics for the statement that produced this streaming result set. These can be requested by setting ExecuteSqlRequest.query_mode and are sent only once with the last response in the stream. This field will also be present in the last response for DML statements.

.google.spanner.v1.ResultSetStats stats = 5;

Returns
TypeDescription
PartialResultSet.Builder

clearValues()

public PartialResultSet.Builder clearValues()

A streamed result set consists of a stream of values, which might be split into many PartialResultSet messages to accommodate large rows and/or large values. Every N complete values defines a row, where N is equal to the number of entries in metadata.row_type.fields.

Most values are encoded based on type as described here.

It is possible that the last value in values is "chunked", meaning that the rest of the value is sent in subsequent PartialResultSet(s). This is denoted by the chunked_value field. Two or more chunked values can be merged to form a complete value as follows:

  • bool/number/null: cannot be chunked
  • string: concatenate the strings
  • list: concatenate the lists. If the last element in a list is a string, list, or object, merge it with the first element in the next list by applying these rules recursively.
  • object: concatenate the (field name, field value) pairs. If a field name is duplicated, then apply these rules recursively to merge the field values.

    Some examples of merging:

    Strings are concatenated.

    "foo", "bar" => "foobar"

    Lists of non-strings are concatenated.

    [2, 3], [4] => [2, 3, 4]

    Lists are concatenated, but the last and first elements are merged

    because they are strings.

    ["a", "b"], ["c", "d"] => ["a", "bc", "d"]

    Lists are concatenated, but the last and first elements are merged

    because they are lists. Recursively, the last and first elements

    of the inner lists are merged because they are strings.

    ["a", ["b", "c"]], [["d"], "e"] => ["a", ["b", "cd"], "e"]

    Non-overlapping object fields are combined.

    {"a": "1"}, {"b": "2"} => {"a": "1", "b": 2"}

    Overlapping object fields are merged.

    {"a": "1"}, {"a": "2"} => {"a": "12"}

    Examples of merging objects containing lists of strings.

    {"a": ["1"]}, {"a": ["2"]} => {"a": ["12"]}

    For a more complete example, suppose a streaming SQL query is yielding a result set whose rows contain a single string field. The following PartialResultSets might be yielded:

    { "metadata": { ... } "values": ["Hello", "W"] "chunked_value": true "resume_token": "Af65..." } { "values": ["orl"] "chunked_value": true "resume_token": "Bqp2..." } { "values": ["d"] "resume_token": "Zx1B..." }

    This sequence of PartialResultSets encodes two rows, one containing the field value "Hello", and a second containing the field value "World" = "W" + "orl" + "d".

repeated .google.protobuf.Value values = 2;

Returns
TypeDescription
PartialResultSet.Builder

clone()

public PartialResultSet.Builder clone()
Returns
TypeDescription
PartialResultSet.Builder
Overrides

getChunkedValue()

public boolean getChunkedValue()

If true, then the final value in values is chunked, and must be combined with more values from subsequent PartialResultSets to obtain a complete field value.

bool chunked_value = 3;

Returns
TypeDescription
boolean

The chunkedValue.

getDefaultInstanceForType()

public PartialResultSet getDefaultInstanceForType()
Returns
TypeDescription
PartialResultSet

getDescriptorForType()

public Descriptors.Descriptor getDescriptorForType()
Returns
TypeDescription
Descriptor
Overrides

getMetadata()

public ResultSetMetadata getMetadata()

Metadata about the result set, such as row type information. Only present in the first response.

.google.spanner.v1.ResultSetMetadata metadata = 1;

Returns
TypeDescription
ResultSetMetadata

The metadata.

getMetadataBuilder()

public ResultSetMetadata.Builder getMetadataBuilder()

Metadata about the result set, such as row type information. Only present in the first response.

.google.spanner.v1.ResultSetMetadata metadata = 1;

Returns
TypeDescription
ResultSetMetadata.Builder

getMetadataOrBuilder()

public ResultSetMetadataOrBuilder getMetadataOrBuilder()

Metadata about the result set, such as row type information. Only present in the first response.

.google.spanner.v1.ResultSetMetadata metadata = 1;

Returns
TypeDescription
ResultSetMetadataOrBuilder

getResumeToken()

public ByteString getResumeToken()

Streaming calls might be interrupted for a variety of reasons, such as TCP connection loss. If this occurs, the stream of results can be resumed by re-sending the original request and including resume_token. Note that executing any other transaction in the same session invalidates the token.

bytes resume_token = 4;

Returns
TypeDescription
ByteString

The resumeToken.

getStats()

public ResultSetStats getStats()

Query plan and execution statistics for the statement that produced this streaming result set. These can be requested by setting ExecuteSqlRequest.query_mode and are sent only once with the last response in the stream. This field will also be present in the last response for DML statements.

.google.spanner.v1.ResultSetStats stats = 5;

Returns
TypeDescription
ResultSetStats

The stats.

getStatsBuilder()

public ResultSetStats.Builder getStatsBuilder()

Query plan and execution statistics for the statement that produced this streaming result set. These can be requested by setting ExecuteSqlRequest.query_mode and are sent only once with the last response in the stream. This field will also be present in the last response for DML statements.

.google.spanner.v1.ResultSetStats stats = 5;

Returns
TypeDescription
ResultSetStats.Builder

getStatsOrBuilder()

public ResultSetStatsOrBuilder getStatsOrBuilder()

Query plan and execution statistics for the statement that produced this streaming result set. These can be requested by setting ExecuteSqlRequest.query_mode and are sent only once with the last response in the stream. This field will also be present in the last response for DML statements.

.google.spanner.v1.ResultSetStats stats = 5;

Returns
TypeDescription
ResultSetStatsOrBuilder

getValues(int index)

public Value getValues(int index)

A streamed result set consists of a stream of values, which might be split into many PartialResultSet messages to accommodate large rows and/or large values. Every N complete values defines a row, where N is equal to the number of entries in metadata.row_type.fields.

Most values are encoded based on type as described here.

It is possible that the last value in values is "chunked", meaning that the rest of the value is sent in subsequent PartialResultSet(s). This is denoted by the chunked_value field. Two or more chunked values can be merged to form a complete value as follows:

  • bool/number/null: cannot be chunked
  • string: concatenate the strings
  • list: concatenate the lists. If the last element in a list is a string, list, or object, merge it with the first element in the next list by applying these rules recursively.
  • object: concatenate the (field name, field value) pairs. If a field name is duplicated, then apply these rules recursively to merge the field values.

    Some examples of merging:

    Strings are concatenated.

    "foo", "bar" => "foobar"

    Lists of non-strings are concatenated.

    [2, 3], [4] => [2, 3, 4]

    Lists are concatenated, but the last and first elements are merged

    because they are strings.

    ["a", "b"], ["c", "d"] => ["a", "bc", "d"]

    Lists are concatenated, but the last and first elements are merged

    because they are lists. Recursively, the last and first elements

    of the inner lists are merged because they are strings.

    ["a", ["b", "c"]], [["d"], "e"] => ["a", ["b", "cd"], "e"]

    Non-overlapping object fields are combined.

    {"a": "1"}, {"b": "2"} => {"a": "1", "b": 2"}

    Overlapping object fields are merged.

    {"a": "1"}, {"a": "2"} => {"a": "12"}

    Examples of merging objects containing lists of strings.

    {"a": ["1"]}, {"a": ["2"]} => {"a": ["12"]}

    For a more complete example, suppose a streaming SQL query is yielding a result set whose rows contain a single string field. The following PartialResultSets might be yielded:

    { "metadata": { ... } "values": ["Hello", "W"] "chunked_value": true "resume_token": "Af65..." } { "values": ["orl"] "chunked_value": true "resume_token": "Bqp2..." } { "values": ["d"] "resume_token": "Zx1B..." }

    This sequence of PartialResultSets encodes two rows, one containing the field value "Hello", and a second containing the field value "World" = "W" + "orl" + "d".

repeated .google.protobuf.Value values = 2;

Parameter
NameDescription
indexint
Returns
TypeDescription
Value

getValuesBuilder(int index)

public Value.Builder getValuesBuilder(int index)

A streamed result set consists of a stream of values, which might be split into many PartialResultSet messages to accommodate large rows and/or large values. Every N complete values defines a row, where N is equal to the number of entries in metadata.row_type.fields.

Most values are encoded based on type as described here.

It is possible that the last value in values is "chunked", meaning that the rest of the value is sent in subsequent PartialResultSet(s). This is denoted by the chunked_value field. Two or more chunked values can be merged to form a complete value as follows:

  • bool/number/null: cannot be chunked
  • string: concatenate the strings
  • list: concatenate the lists. If the last element in a list is a string, list, or object, merge it with the first element in the next list by applying these rules recursively.
  • object: concatenate the (field name, field value) pairs. If a field name is duplicated, then apply these rules recursively to merge the field values.

    Some examples of merging:

    Strings are concatenated.

    "foo", "bar" => "foobar"

    Lists of non-strings are concatenated.

    [2, 3], [4] => [2, 3, 4]

    Lists are concatenated, but the last and first elements are merged

    because they are strings.

    ["a", "b"], ["c", "d"] => ["a", "bc", "d"]

    Lists are concatenated, but the last and first elements are merged

    because they are lists. Recursively, the last and first elements

    of the inner lists are merged because they are strings.

    ["a", ["b", "c"]], [["d"], "e"] => ["a", ["b", "cd"], "e"]

    Non-overlapping object fields are combined.

    {"a": "1"}, {"b": "2"} => {"a": "1", "b": 2"}

    Overlapping object fields are merged.

    {"a": "1"}, {"a": "2"} => {"a": "12"}

    Examples of merging objects containing lists of strings.

    {"a": ["1"]}, {"a": ["2"]} => {"a": ["12"]}

    For a more complete example, suppose a streaming SQL query is yielding a result set whose rows contain a single string field. The following PartialResultSets might be yielded:

    { "metadata": { ... } "values": ["Hello", "W"] "chunked_value": true "resume_token": "Af65..." } { "values": ["orl"] "chunked_value": true "resume_token": "Bqp2..." } { "values": ["d"] "resume_token": "Zx1B..." }

    This sequence of PartialResultSets encodes two rows, one containing the field value "Hello", and a second containing the field value "World" = "W" + "orl" + "d".

repeated .google.protobuf.Value values = 2;

Parameter
NameDescription
indexint
Returns
TypeDescription
Builder

getValuesBuilderList()

public List<Value.Builder> getValuesBuilderList()

A streamed result set consists of a stream of values, which might be split into many PartialResultSet messages to accommodate large rows and/or large values. Every N complete values defines a row, where N is equal to the number of entries in metadata.row_type.fields.

Most values are encoded based on type as described here.

It is possible that the last value in values is "chunked", meaning that the rest of the value is sent in subsequent PartialResultSet(s). This is denoted by the chunked_value field. Two or more chunked values can be merged to form a complete value as follows:

  • bool/number/null: cannot be chunked
  • string: concatenate the strings
  • list: concatenate the lists. If the last element in a list is a string, list, or object, merge it with the first element in the next list by applying these rules recursively.
  • object: concatenate the (field name, field value) pairs. If a field name is duplicated, then apply these rules recursively to merge the field values.

    Some examples of merging:

    Strings are concatenated.

    "foo", "bar" => "foobar"

    Lists of non-strings are concatenated.

    [2, 3], [4] => [2, 3, 4]

    Lists are concatenated, but the last and first elements are merged

    because they are strings.

    ["a", "b"], ["c", "d"] => ["a", "bc", "d"]

    Lists are concatenated, but the last and first elements are merged

    because they are lists. Recursively, the last and first elements

    of the inner lists are merged because they are strings.

    ["a", ["b", "c"]], [["d"], "e"] => ["a", ["b", "cd"], "e"]

    Non-overlapping object fields are combined.

    {"a": "1"}, {"b": "2"} => {"a": "1", "b": 2"}

    Overlapping object fields are merged.

    {"a": "1"}, {"a": "2"} => {"a": "12"}

    Examples of merging objects containing lists of strings.

    {"a": ["1"]}, {"a": ["2"]} => {"a": ["12"]}

    For a more complete example, suppose a streaming SQL query is yielding a result set whose rows contain a single string field. The following PartialResultSets might be yielded:

    { "metadata": { ... } "values": ["Hello", "W"] "chunked_value": true "resume_token": "Af65..." } { "values": ["orl"] "chunked_value": true "resume_token": "Bqp2..." } { "values": ["d"] "resume_token": "Zx1B..." }

    This sequence of PartialResultSets encodes two rows, one containing the field value "Hello", and a second containing the field value "World" = "W" + "orl" + "d".

repeated .google.protobuf.Value values = 2;

Returns
TypeDescription
List<Builder>

getValuesCount()

public int getValuesCount()

A streamed result set consists of a stream of values, which might be split into many PartialResultSet messages to accommodate large rows and/or large values. Every N complete values defines a row, where N is equal to the number of entries in metadata.row_type.fields.

Most values are encoded based on type as described here.

It is possible that the last value in values is "chunked", meaning that the rest of the value is sent in subsequent PartialResultSet(s). This is denoted by the chunked_value field. Two or more chunked values can be merged to form a complete value as follows:

  • bool/number/null: cannot be chunked
  • string: concatenate the strings
  • list: concatenate the lists. If the last element in a list is a string, list, or object, merge it with the first element in the next list by applying these rules recursively.
  • object: concatenate the (field name, field value) pairs. If a field name is duplicated, then apply these rules recursively to merge the field values.

    Some examples of merging:

    Strings are concatenated.

    "foo", "bar" => "foobar"

    Lists of non-strings are concatenated.

    [2, 3], [4] => [2, 3, 4]

    Lists are concatenated, but the last and first elements are merged

    because they are strings.

    ["a", "b"], ["c", "d"] => ["a", "bc", "d"]

    Lists are concatenated, but the last and first elements are merged

    because they are lists. Recursively, the last and first elements

    of the inner lists are merged because they are strings.

    ["a", ["b", "c"]], [["d"], "e"] => ["a", ["b", "cd"], "e"]

    Non-overlapping object fields are combined.

    {"a": "1"}, {"b": "2"} => {"a": "1", "b": 2"}

    Overlapping object fields are merged.

    {"a": "1"}, {"a": "2"} => {"a": "12"}

    Examples of merging objects containing lists of strings.

    {"a": ["1"]}, {"a": ["2"]} => {"a": ["12"]}

    For a more complete example, suppose a streaming SQL query is yielding a result set whose rows contain a single string field. The following PartialResultSets might be yielded:

    { "metadata": { ... } "values": ["Hello", "W"] "chunked_value": true "resume_token": "Af65..." } { "values": ["orl"] "chunked_value": true "resume_token": "Bqp2..." } { "values": ["d"] "resume_token": "Zx1B..." }

    This sequence of PartialResultSets encodes two rows, one containing the field value "Hello", and a second containing the field value "World" = "W" + "orl" + "d".

repeated .google.protobuf.Value values = 2;

Returns
TypeDescription
int

getValuesList()

public List<Value> getValuesList()

A streamed result set consists of a stream of values, which might be split into many PartialResultSet messages to accommodate large rows and/or large values. Every N complete values defines a row, where N is equal to the number of entries in metadata.row_type.fields.

Most values are encoded based on type as described here.

It is possible that the last value in values is "chunked", meaning that the rest of the value is sent in subsequent PartialResultSet(s). This is denoted by the chunked_value field. Two or more chunked values can be merged to form a complete value as follows:

  • bool/number/null: cannot be chunked
  • string: concatenate the strings
  • list: concatenate the lists. If the last element in a list is a string, list, or object, merge it with the first element in the next list by applying these rules recursively.
  • object: concatenate the (field name, field value) pairs. If a field name is duplicated, then apply these rules recursively to merge the field values.

    Some examples of merging:

    Strings are concatenated.

    "foo", "bar" => "foobar"

    Lists of non-strings are concatenated.

    [2, 3], [4] => [2, 3, 4]

    Lists are concatenated, but the last and first elements are merged

    because they are strings.

    ["a", "b"], ["c", "d"] => ["a", "bc", "d"]

    Lists are concatenated, but the last and first elements are merged

    because they are lists. Recursively, the last and first elements

    of the inner lists are merged because they are strings.

    ["a", ["b", "c"]], [["d"], "e"] => ["a", ["b", "cd"], "e"]

    Non-overlapping object fields are combined.

    {"a": "1"}, {"b": "2"} => {"a": "1", "b": 2"}

    Overlapping object fields are merged.

    {"a": "1"}, {"a": "2"} => {"a": "12"}

    Examples of merging objects containing lists of strings.

    {"a": ["1"]}, {"a": ["2"]} => {"a": ["12"]}

    For a more complete example, suppose a streaming SQL query is yielding a result set whose rows contain a single string field. The following PartialResultSets might be yielded:

    { "metadata": { ... } "values": ["Hello", "W"] "chunked_value": true "resume_token": "Af65..." } { "values": ["orl"] "chunked_value": true "resume_token": "Bqp2..." } { "values": ["d"] "resume_token": "Zx1B..." }

    This sequence of PartialResultSets encodes two rows, one containing the field value "Hello", and a second containing the field value "World" = "W" + "orl" + "d".

repeated .google.protobuf.Value values = 2;

Returns
TypeDescription
List<Value>

getValuesOrBuilder(int index)

public ValueOrBuilder getValuesOrBuilder(int index)

A streamed result set consists of a stream of values, which might be split into many PartialResultSet messages to accommodate large rows and/or large values. Every N complete values defines a row, where N is equal to the number of entries in metadata.row_type.fields.

Most values are encoded based on type as described here.

It is possible that the last value in values is "chunked", meaning that the rest of the value is sent in subsequent PartialResultSet(s). This is denoted by the chunked_value field. Two or more chunked values can be merged to form a complete value as follows:

  • bool/number/null: cannot be chunked
  • string: concatenate the strings
  • list: concatenate the lists. If the last element in a list is a string, list, or object, merge it with the first element in the next list by applying these rules recursively.
  • object: concatenate the (field name, field value) pairs. If a field name is duplicated, then apply these rules recursively to merge the field values.

    Some examples of merging:

    Strings are concatenated.

    "foo", "bar" => "foobar"

    Lists of non-strings are concatenated.

    [2, 3], [4] => [2, 3, 4]

    Lists are concatenated, but the last and first elements are merged

    because they are strings.

    ["a", "b"], ["c", "d"] => ["a", "bc", "d"]

    Lists are concatenated, but the last and first elements are merged

    because they are lists. Recursively, the last and first elements

    of the inner lists are merged because they are strings.

    ["a", ["b", "c"]], [["d"], "e"] => ["a", ["b", "cd"], "e"]

    Non-overlapping object fields are combined.

    {"a": "1"}, {"b": "2"} => {"a": "1", "b": 2"}

    Overlapping object fields are merged.

    {"a": "1"}, {"a": "2"} => {"a": "12"}

    Examples of merging objects containing lists of strings.

    {"a": ["1"]}, {"a": ["2"]} => {"a": ["12"]}

    For a more complete example, suppose a streaming SQL query is yielding a result set whose rows contain a single string field. The following PartialResultSets might be yielded:

    { "metadata": { ... } "values": ["Hello", "W"] "chunked_value": true "resume_token": "Af65..." } { "values": ["orl"] "chunked_value": true "resume_token": "Bqp2..." } { "values": ["d"] "resume_token": "Zx1B..." }

    This sequence of PartialResultSets encodes two rows, one containing the field value "Hello", and a second containing the field value "World" = "W" + "orl" + "d".

repeated .google.protobuf.Value values = 2;

Parameter
NameDescription
indexint
Returns
TypeDescription
ValueOrBuilder

getValuesOrBuilderList()

public List<? extends ValueOrBuilder> getValuesOrBuilderList()

A streamed result set consists of a stream of values, which might be split into many PartialResultSet messages to accommodate large rows and/or large values. Every N complete values defines a row, where N is equal to the number of entries in metadata.row_type.fields.

Most values are encoded based on type as described here.

It is possible that the last value in values is "chunked", meaning that the rest of the value is sent in subsequent PartialResultSet(s). This is denoted by the chunked_value field. Two or more chunked values can be merged to form a complete value as follows:

  • bool/number/null: cannot be chunked
  • string: concatenate the strings
  • list: concatenate the lists. If the last element in a list is a string, list, or object, merge it with the first element in the next list by applying these rules recursively.
  • object: concatenate the (field name, field value) pairs. If a field name is duplicated, then apply these rules recursively to merge the field values.

    Some examples of merging:

    Strings are concatenated.

    "foo", "bar" => "foobar"

    Lists of non-strings are concatenated.

    [2, 3], [4] => [2, 3, 4]

    Lists are concatenated, but the last and first elements are merged

    because they are strings.

    ["a", "b"], ["c", "d"] => ["a", "bc", "d"]

    Lists are concatenated, but the last and first elements are merged

    because they are lists. Recursively, the last and first elements

    of the inner lists are merged because they are strings.

    ["a", ["b", "c"]], [["d"], "e"] => ["a", ["b", "cd"], "e"]

    Non-overlapping object fields are combined.

    {"a": "1"}, {"b": "2"} => {"a": "1", "b": 2"}

    Overlapping object fields are merged.

    {"a": "1"}, {"a": "2"} => {"a": "12"}

    Examples of merging objects containing lists of strings.

    {"a": ["1"]}, {"a": ["2"]} => {"a": ["12"]}

    For a more complete example, suppose a streaming SQL query is yielding a result set whose rows contain a single string field. The following PartialResultSets might be yielded:

    { "metadata": { ... } "values": ["Hello", "W"] "chunked_value": true "resume_token": "Af65..." } { "values": ["orl"] "chunked_value": true "resume_token": "Bqp2..." } { "values": ["d"] "resume_token": "Zx1B..." }

    This sequence of PartialResultSets encodes two rows, one containing the field value "Hello", and a second containing the field value "World" = "W" + "orl" + "d".

repeated .google.protobuf.Value values = 2;

Returns
TypeDescription
List<? extends com.google.protobuf.ValueOrBuilder>

hasMetadata()

public boolean hasMetadata()

Metadata about the result set, such as row type information. Only present in the first response.

.google.spanner.v1.ResultSetMetadata metadata = 1;

Returns
TypeDescription
boolean

Whether the metadata field is set.

hasStats()

public boolean hasStats()

Query plan and execution statistics for the statement that produced this streaming result set. These can be requested by setting ExecuteSqlRequest.query_mode and are sent only once with the last response in the stream. This field will also be present in the last response for DML statements.

.google.spanner.v1.ResultSetStats stats = 5;

Returns
TypeDescription
boolean

Whether the stats field is set.

internalGetFieldAccessorTable()

protected GeneratedMessageV3.FieldAccessorTable internalGetFieldAccessorTable()
Returns
TypeDescription
FieldAccessorTable
Overrides

isInitialized()

public final boolean isInitialized()
Returns
TypeDescription
boolean
Overrides

mergeFrom(CodedInputStream input, ExtensionRegistryLite extensionRegistry)

public PartialResultSet.Builder mergeFrom(CodedInputStream input, ExtensionRegistryLite extensionRegistry)
Parameters
NameDescription
inputCodedInputStream
extensionRegistryExtensionRegistryLite
Returns
TypeDescription
PartialResultSet.Builder
Overrides
Exceptions
TypeDescription
IOException

mergeFrom(Message other)

public PartialResultSet.Builder mergeFrom(Message other)
Parameter
NameDescription
otherMessage
Returns
TypeDescription
PartialResultSet.Builder
Overrides

mergeFrom(PartialResultSet other)

public PartialResultSet.Builder mergeFrom(PartialResultSet other)
Parameter
NameDescription
otherPartialResultSet
Returns
TypeDescription
PartialResultSet.Builder

mergeMetadata(ResultSetMetadata value)

public PartialResultSet.Builder mergeMetadata(ResultSetMetadata value)

Metadata about the result set, such as row type information. Only present in the first response.

.google.spanner.v1.ResultSetMetadata metadata = 1;

Parameter
NameDescription
valueResultSetMetadata
Returns
TypeDescription
PartialResultSet.Builder

mergeStats(ResultSetStats value)

public PartialResultSet.Builder mergeStats(ResultSetStats value)

Query plan and execution statistics for the statement that produced this streaming result set. These can be requested by setting ExecuteSqlRequest.query_mode and are sent only once with the last response in the stream. This field will also be present in the last response for DML statements.

.google.spanner.v1.ResultSetStats stats = 5;

Parameter
NameDescription
valueResultSetStats
Returns
TypeDescription
PartialResultSet.Builder

mergeUnknownFields(UnknownFieldSet unknownFields)

public final PartialResultSet.Builder mergeUnknownFields(UnknownFieldSet unknownFields)
Parameter
NameDescription
unknownFieldsUnknownFieldSet
Returns
TypeDescription
PartialResultSet.Builder
Overrides

removeValues(int index)

public PartialResultSet.Builder removeValues(int index)

A streamed result set consists of a stream of values, which might be split into many PartialResultSet messages to accommodate large rows and/or large values. Every N complete values defines a row, where N is equal to the number of entries in metadata.row_type.fields.

Most values are encoded based on type as described here.

It is possible that the last value in values is "chunked", meaning that the rest of the value is sent in subsequent PartialResultSet(s). This is denoted by the chunked_value field. Two or more chunked values can be merged to form a complete value as follows:

  • bool/number/null: cannot be chunked
  • string: concatenate the strings
  • list: concatenate the lists. If the last element in a list is a string, list, or object, merge it with the first element in the next list by applying these rules recursively.
  • object: concatenate the (field name, field value) pairs. If a field name is duplicated, then apply these rules recursively to merge the field values.

    Some examples of merging:

    Strings are concatenated.

    "foo", "bar" => "foobar"

    Lists of non-strings are concatenated.

    [2, 3], [4] => [2, 3, 4]

    Lists are concatenated, but the last and first elements are merged

    because they are strings.

    ["a", "b"], ["c", "d"] => ["a", "bc", "d"]

    Lists are concatenated, but the last and first elements are merged

    because they are lists. Recursively, the last and first elements

    of the inner lists are merged because they are strings.

    ["a", ["b", "c"]], [["d"], "e"] => ["a", ["b", "cd"], "e"]

    Non-overlapping object fields are combined.

    {"a": "1"}, {"b": "2"} => {"a": "1", "b": 2"}

    Overlapping object fields are merged.

    {"a": "1"}, {"a": "2"} => {"a": "12"}

    Examples of merging objects containing lists of strings.

    {"a": ["1"]}, {"a": ["2"]} => {"a": ["12"]}

    For a more complete example, suppose a streaming SQL query is yielding a result set whose rows contain a single string field. The following PartialResultSets might be yielded:

    { "metadata": { ... } "values": ["Hello", "W"] "chunked_value": true "resume_token": "Af65..." } { "values": ["orl"] "chunked_value": true "resume_token": "Bqp2..." } { "values": ["d"] "resume_token": "Zx1B..." }

    This sequence of PartialResultSets encodes two rows, one containing the field value "Hello", and a second containing the field value "World" = "W" + "orl" + "d".

repeated .google.protobuf.Value values = 2;

Parameter
NameDescription
indexint
Returns
TypeDescription
PartialResultSet.Builder

setChunkedValue(boolean value)

public PartialResultSet.Builder setChunkedValue(boolean value)

If true, then the final value in values is chunked, and must be combined with more values from subsequent PartialResultSets to obtain a complete field value.

bool chunked_value = 3;

Parameter
NameDescription
valueboolean

The chunkedValue to set.

Returns
TypeDescription
PartialResultSet.Builder

This builder for chaining.

setField(Descriptors.FieldDescriptor field, Object value)

public PartialResultSet.Builder setField(Descriptors.FieldDescriptor field, Object value)
Parameters
NameDescription
fieldFieldDescriptor
valueObject
Returns
TypeDescription
PartialResultSet.Builder
Overrides

setMetadata(ResultSetMetadata value)

public PartialResultSet.Builder setMetadata(ResultSetMetadata value)

Metadata about the result set, such as row type information. Only present in the first response.

.google.spanner.v1.ResultSetMetadata metadata = 1;

Parameter
NameDescription
valueResultSetMetadata
Returns
TypeDescription
PartialResultSet.Builder

setMetadata(ResultSetMetadata.Builder builderForValue)

public PartialResultSet.Builder setMetadata(ResultSetMetadata.Builder builderForValue)

Metadata about the result set, such as row type information. Only present in the first response.

.google.spanner.v1.ResultSetMetadata metadata = 1;

Parameter
NameDescription
builderForValueResultSetMetadata.Builder
Returns
TypeDescription
PartialResultSet.Builder

setRepeatedField(Descriptors.FieldDescriptor field, int index, Object value)

public PartialResultSet.Builder setRepeatedField(Descriptors.FieldDescriptor field, int index, Object value)
Parameters
NameDescription
fieldFieldDescriptor
indexint
valueObject
Returns
TypeDescription
PartialResultSet.Builder
Overrides

setResumeToken(ByteString value)

public PartialResultSet.Builder setResumeToken(ByteString value)

Streaming calls might be interrupted for a variety of reasons, such as TCP connection loss. If this occurs, the stream of results can be resumed by re-sending the original request and including resume_token. Note that executing any other transaction in the same session invalidates the token.

bytes resume_token = 4;

Parameter
NameDescription
valueByteString

The resumeToken to set.

Returns
TypeDescription
PartialResultSet.Builder

This builder for chaining.

setStats(ResultSetStats value)

public PartialResultSet.Builder setStats(ResultSetStats value)

Query plan and execution statistics for the statement that produced this streaming result set. These can be requested by setting ExecuteSqlRequest.query_mode and are sent only once with the last response in the stream. This field will also be present in the last response for DML statements.

.google.spanner.v1.ResultSetStats stats = 5;

Parameter
NameDescription
valueResultSetStats
Returns
TypeDescription
PartialResultSet.Builder

setStats(ResultSetStats.Builder builderForValue)

public PartialResultSet.Builder setStats(ResultSetStats.Builder builderForValue)

Query plan and execution statistics for the statement that produced this streaming result set. These can be requested by setting ExecuteSqlRequest.query_mode and are sent only once with the last response in the stream. This field will also be present in the last response for DML statements.

.google.spanner.v1.ResultSetStats stats = 5;

Parameter
NameDescription
builderForValueResultSetStats.Builder
Returns
TypeDescription
PartialResultSet.Builder

setUnknownFields(UnknownFieldSet unknownFields)

public final PartialResultSet.Builder setUnknownFields(UnknownFieldSet unknownFields)
Parameter
NameDescription
unknownFieldsUnknownFieldSet
Returns
TypeDescription
PartialResultSet.Builder
Overrides

setValues(int index, Value value)

public PartialResultSet.Builder setValues(int index, Value value)

A streamed result set consists of a stream of values, which might be split into many PartialResultSet messages to accommodate large rows and/or large values. Every N complete values defines a row, where N is equal to the number of entries in metadata.row_type.fields.

Most values are encoded based on type as described here.

It is possible that the last value in values is "chunked", meaning that the rest of the value is sent in subsequent PartialResultSet(s). This is denoted by the chunked_value field. Two or more chunked values can be merged to form a complete value as follows:

  • bool/number/null: cannot be chunked
  • string: concatenate the strings
  • list: concatenate the lists. If the last element in a list is a string, list, or object, merge it with the first element in the next list by applying these rules recursively.
  • object: concatenate the (field name, field value) pairs. If a field name is duplicated, then apply these rules recursively to merge the field values.

    Some examples of merging:

    Strings are concatenated.

    "foo", "bar" => "foobar"

    Lists of non-strings are concatenated.

    [2, 3], [4] => [2, 3, 4]

    Lists are concatenated, but the last and first elements are merged

    because they are strings.

    ["a", "b"], ["c", "d"] => ["a", "bc", "d"]

    Lists are concatenated, but the last and first elements are merged

    because they are lists. Recursively, the last and first elements

    of the inner lists are merged because they are strings.

    ["a", ["b", "c"]], [["d"], "e"] => ["a", ["b", "cd"], "e"]

    Non-overlapping object fields are combined.

    {"a": "1"}, {"b": "2"} => {"a": "1", "b": 2"}

    Overlapping object fields are merged.

    {"a": "1"}, {"a": "2"} => {"a": "12"}

    Examples of merging objects containing lists of strings.

    {"a": ["1"]}, {"a": ["2"]} => {"a": ["12"]}

    For a more complete example, suppose a streaming SQL query is yielding a result set whose rows contain a single string field. The following PartialResultSets might be yielded:

    { "metadata": { ... } "values": ["Hello", "W"] "chunked_value": true "resume_token": "Af65..." } { "values": ["orl"] "chunked_value": true "resume_token": "Bqp2..." } { "values": ["d"] "resume_token": "Zx1B..." }

    This sequence of PartialResultSets encodes two rows, one containing the field value "Hello", and a second containing the field value "World" = "W" + "orl" + "d".

repeated .google.protobuf.Value values = 2;

Parameters
NameDescription
indexint
valueValue
Returns
TypeDescription
PartialResultSet.Builder

setValues(int index, Value.Builder builderForValue)

public PartialResultSet.Builder setValues(int index, Value.Builder builderForValue)

A streamed result set consists of a stream of values, which might be split into many PartialResultSet messages to accommodate large rows and/or large values. Every N complete values defines a row, where N is equal to the number of entries in metadata.row_type.fields.

Most values are encoded based on type as described here.

It is possible that the last value in values is "chunked", meaning that the rest of the value is sent in subsequent PartialResultSet(s). This is denoted by the chunked_value field. Two or more chunked values can be merged to form a complete value as follows:

  • bool/number/null: cannot be chunked
  • string: concatenate the strings
  • list: concatenate the lists. If the last element in a list is a string, list, or object, merge it with the first element in the next list by applying these rules recursively.
  • object: concatenate the (field name, field value) pairs. If a field name is duplicated, then apply these rules recursively to merge the field values.

    Some examples of merging:

    Strings are concatenated.

    "foo", "bar" => "foobar"

    Lists of non-strings are concatenated.

    [2, 3], [4] => [2, 3, 4]

    Lists are concatenated, but the last and first elements are merged

    because they are strings.

    ["a", "b"], ["c", "d"] => ["a", "bc", "d"]

    Lists are concatenated, but the last and first elements are merged

    because they are lists. Recursively, the last and first elements

    of the inner lists are merged because they are strings.

    ["a", ["b", "c"]], [["d"], "e"] => ["a", ["b", "cd"], "e"]

    Non-overlapping object fields are combined.

    {"a": "1"}, {"b": "2"} => {"a": "1", "b": 2"}

    Overlapping object fields are merged.

    {"a": "1"}, {"a": "2"} => {"a": "12"}

    Examples of merging objects containing lists of strings.

    {"a": ["1"]}, {"a": ["2"]} => {"a": ["12"]}

    For a more complete example, suppose a streaming SQL query is yielding a result set whose rows contain a single string field. The following PartialResultSets might be yielded:

    { "metadata": { ... } "values": ["Hello", "W"] "chunked_value": true "resume_token": "Af65..." } { "values": ["orl"] "chunked_value": true "resume_token": "Bqp2..." } { "values": ["d"] "resume_token": "Zx1B..." }

    This sequence of PartialResultSets encodes two rows, one containing the field value "Hello", and a second containing the field value "World" = "W" + "orl" + "d".

repeated .google.protobuf.Value values = 2;

Parameters
NameDescription
indexint
builderForValueBuilder
Returns
TypeDescription
PartialResultSet.Builder