• Home
  • Raw
  • Download

Lines Matching +full:read +full:- +full:only

8   font-weight: inherit;
9 font-style: inherit;
10 font-size: 100%;
11 font-family: inherit;
12 vertical-align: baseline;
16 font-size: 13px;
21 font-size: 26px;
22 margin-bottom: 1em;
26 font-size: 24px;
27 margin-bottom: 1em;
31 font-size: 20px;
32 margin-bottom: 1em;
33 margin-top: 1em;
37 line-height: 1.5;
38 font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Lucida Console', monospace;
42 margin-top: 0.5em;
46 font-family: Arial, sans serif;
50 border-bottom: solid #CCC 1px;
54 margin-top: 0.5em;
58 margin-left: 2 em;
62 margin-top: 1em;
69 font-weight: bold;
70 font-size: 14px;
82 …ansaction. This step can often be skipped: Read, ExecuteSql and Commit can begin a new transaction…
88-attempt the transaction from the beginning, re-using the same session. On very rare occasions, `C…
91read and/or modify data in a Cloud Spanner database. Sessions are meant to be reused for many cons…
100 …at, the query fails with a `FAILED_PRECONDITION` error. Operations inside read-write transactions …
115 …teStreamingSql to specify a subset of the query result to read. The same session and read-only tra…
118read operation in parallel. Each of the returned partition tokens can be used by StreamingRead to …
120 <code><a href="#read">read(session, body=None, x__xgafv=None)</a></code></p>
121 …rger than 10 MiB; if the read matches more data than that, the read fails with a `FAILED_PRECONDIT…
124 …is a good idea to call this for any transaction that includes one or more Read or ExecuteSql reque…
127 <p class="firstline">Like Read, except returns the result set as a stream. Unlike Read, there is no…
141 …&quot;approximateLastUseTime&quot;: &quot;A String&quot;, # Output only. The approximate timestamp…
142 …&quot;createTime&quot;: &quot;A String&quot;, # Output only. The timestamp when the session is cre…
143 …a-z]([-a-z0-9]*[a-z0-9])?`. * Label values must be between 0 and 63 characters long and must confo…
146 …&quot;name&quot;: &quot;A String&quot;, # Output only. The name of the session. This is always sys…
152 1 - v1 error format
153 2 - v2 error format
161 …&quot;approximateLastUseTime&quot;: &quot;A String&quot;, # Output only. The approximate timestamp…
162 …&quot;createTime&quot;: &quot;A String&quot;, # Output only. The timestamp when the session is cre…
163 …a-z]([-a-z0-9]*[a-z0-9])?`. * Label values must be between 0 and 63 characters long and must confo…
166 …&quot;name&quot;: &quot;A String&quot;, # Output only. The name of the session. This is always sys…
174 …ansaction. This step can often be skipped: Read, ExecuteSql and Commit can begin a new transaction…
182-used for the next transaction. It is not necessary to create a new session for each transaction. …
185 …: { # Message type to initiate a read-only transaction. # Transaction will not write. Authorizatio…
186 …amp that is `exact_staleness` old. The timestamp is chosen soon after the read is started. Guarant…
187Read data at a timestamp &gt;= `NOW - max_staleness` seconds. Guarantees that all writes that have…
188read, or data that is fresh enough to observe the effects of some previously committed transaction…
189read at the same timestamp always returns the same data. If the timestamp is in the future, the re…
190 …&quot;returnReadTimestamp&quot;: True or False, # If true, the Cloud Spanner-selected read timesta…
191 …&quot;strong&quot;: True or False, # Read at a timestamp where all previously committed transactio…
193 …o initiate a read-write transaction. Currently this transaction type has no options. # Transaction…
198-request tag which can be applied to queries or reads, used for statistics collection. Both reques…
199read or query that belongs to a transaction. The value of transaction_tag should be the same for a…
205 1 - v1 error format
206 2 - v2 error format
212 …action in subsequent Read, ExecuteSql, Commit, or Rollback calls. Single-use read-only transaction…
213read-only transactions, the read timestamp chosen for the transaction. Not returned by default: se…
224-attempt the transaction from the beginning, re-using the same session. On very rare occasions, `C…
235 …, or a key and a range overlap), Cloud Spanner behaves as if the key were only specified once. # R…
236 …ys in the table or index. Note that any keys specified in `keys` or `ranges` are only yielded once.
243-09-23&quot; Since the `UserEvents` table&#x27;s `PRIMARY KEY` clause names two columns, each `Use…
309-request tag which can be applied to queries or reads, used for statistics collection. Both reques…
310read or query that belongs to a transaction. The value of transaction_tag should be the same for a…
313-used for the next transaction. It is not necessary to create a new session for each transaction. …
316 …: { # Message type to initiate a read-only transaction. # Transaction will not write. Authorizatio…
317 …amp that is `exact_staleness` old. The timestamp is chosen soon after the read is started. Guarant…
318Read data at a timestamp &gt;= `NOW - max_staleness` seconds. Guarantees that all writes that have…
319read, or data that is fresh enough to observe the effects of some previously committed transaction…
320read at the same timestamp always returns the same data. If the timestamp is in the future, the re…
321 …&quot;returnReadTimestamp&quot;: True or False, # If true, the Cloud Spanner-selected read timesta…
322 …&quot;strong&quot;: True or False, # Read at a timestamp where all previously committed transactio…
324 …o initiate a read-write transaction. Currently this transaction type has no options. # Transaction…
327 &quot;transactionId&quot;: &quot;A String&quot;, # Commit a previously-started transaction.
332 1 - v1 error format
333 2 - v2 error format
348read and/or modify data in a Cloud Spanner database. Sessions are meant to be reused for many cons…
357 …&quot;approximateLastUseTime&quot;: &quot;A String&quot;, # Output only. The approximate timestamp…
358 …&quot;createTime&quot;: &quot;A String&quot;, # Output only. The timestamp when the session is cre…
359 …a-z]([-a-z0-9]*[a-z0-9])?`. * Label values must be between 0 and 63 characters long and must confo…
362 …&quot;name&quot;: &quot;A String&quot;, # Output only. The name of the session. This is always sys…
368 1 - v1 error format
369 2 - v2 error format
375 …&quot;approximateLastUseTime&quot;: &quot;A String&quot;, # Output only. The approximate timestamp…
376 …&quot;createTime&quot;: &quot;A String&quot;, # Output only. The timestamp when the session is cre…
377 …a-z]([-a-z0-9]*[a-z0-9])?`. * Label values must be between 0 and 63 characters long and must confo…
380 …&quot;name&quot;: &quot;A String&quot;, # Output only. The name of the session. This is always sys…
392 1 - v1 error format
393 2 - v2 error format
398 …{ # A generic empty message that you can re-use to avoid defining duplicated empty messages in you…
414-request tag which can be applied to queries or reads, used for statistics collection. Both reques…
415read or query that belongs to a transaction. The value of transaction_tag should be the same for a…
417-transaction sequence number used to identify this request. This field makes each request idempote…
425 …tructType. In turn, the order of fields matches the order of columns in a read request, or the ord…
440Read or ExecuteSql call runs. See TransactionOptions for more information about transactions. # Re…
441-used for the next transaction. It is not necessary to create a new session for each transaction. …
444 …: { # Message type to initiate a read-only transaction. # Transaction will not write. Authorizatio…
445 …amp that is `exact_staleness` old. The timestamp is chosen soon after the read is started. Guarant…
446Read data at a timestamp &gt;= `NOW - max_staleness` seconds. Guarantees that all writes that have…
447read, or data that is fresh enough to observe the effects of some previously committed transaction…
448read at the same timestamp always returns the same data. If the timestamp is in the future, the re…
449 …&quot;returnReadTimestamp&quot;: True or False, # If true, the Cloud Spanner-selected read timesta…
450 …&quot;strong&quot;: True or False, # Read at a timestamp where all previously committed transactio…
452 …o initiate a read-write transaction. Currently this transaction type has no options. # Transaction…
455 …&quot;id&quot;: &quot;A String&quot;, # Execute the read or SQL query in a previously-started tran…
456-used for the next transaction. It is not necessary to create a new session for each transaction. …
459 …: { # Message type to initiate a read-only transaction. # Transaction will not write. Authorizatio…
460 …amp that is `exact_staleness` old. The timestamp is chosen soon after the read is started. Guarant…
461Read data at a timestamp &gt;= `NOW - max_staleness` seconds. Guarantees that all writes that have…
462read, or data that is fresh enough to observe the effects of some previously committed transaction…
463read at the same timestamp always returns the same data. If the timestamp is in the future, the re…
464 …&quot;returnReadTimestamp&quot;: True or False, # If true, the Cloud Spanner-selected read timesta…
465 …&quot;strong&quot;: True or False, # Read at a timestamp where all previously committed transactio…
467 …o initiate a read-write transaction. Currently this transaction type has no options. # Transaction…
475 1 - v1 error format
476 2 - v2 error format
482 …s in each ResultSet contain the number of rows modified by the statement. Only the first ResultSet…
483 { # Results from Read or ExecuteSql.
486 …tructType. In turn, the order of fields matches the order of columns in a read request, or the ord…
493 …quot;transaction&quot;: { # A transaction. # If the read or SQL query began a transaction as a sid…
494 …action in subsequent Read, ExecuteSql, Commit, or Rollback calls. Single-use read-only transaction…
495read-only transactions, the read timestamp chosen for the transaction. Not returned by default: se…
505 …&quot;planNodes&quot;: [ # The nodes in the query plan. Plan nodes are returned in pre-order start…
508 { # Metadata associated with a parent-child relationship appearing in a PlanNode.
511Only present if the child node is SCALAR and corresponds to an output variable of the parent node.…
515 …on statistics associated with the node, contained in a group of key-value pairs. Only present if t…
520 …adata&quot;: { # Attributes relevant to the node contained in a group of key-value pairs. For exam…
523 …esentation&quot;: { # Condensed representation of a node and its subtree. Only present for `SCALAR…
525 …&quot;subqueries&quot;: { # A mapping of (subquery variable name) -&gt; (subquery node id) for cas…
532 …&quot;queryStats&quot;: { # Aggregated statistics from the execution of the query. Only present wh…
536 …rBound&quot;: &quot;A String&quot;, # Partitioned DML does not offer exactly-once semantics, so it…
547 …age&quot;: &quot;A String&quot;, # A developer-facing error message, which should be in English. A…
554 …at, the query fails with a `FAILED_PRECONDITION` error. Operations inside read-write transactions …
567 …tructType. In turn, the order of fields matches the order of columns in a read request, or the ord…
580 …ion returned in ResultSetStats. If partition_token is set, query_mode can only be set to QueryMode…
583 …ARGUMENT` error. See https://cloud.google.com/spanner/docs/query-optimizer/manage-query-optimizer …
587-request tag which can be applied to queries or reads, used for statistics collection. Both reques…
588read or query that belongs to a transaction. The value of transaction_tag should be the same for a…
591-transaction sequence number used to identify this request. This field makes each request idempote…
593Read or ExecuteSql call runs. See TransactionOptions for more information about transactions. # Th…
594-used for the next transaction. It is not necessary to create a new session for each transaction. …
597 …: { # Message type to initiate a read-only transaction. # Transaction will not write. Authorizatio…
598 …amp that is `exact_staleness` old. The timestamp is chosen soon after the read is started. Guarant…
599Read data at a timestamp &gt;= `NOW - max_staleness` seconds. Guarantees that all writes that have…
600read, or data that is fresh enough to observe the effects of some previously committed transaction…
601read at the same timestamp always returns the same data. If the timestamp is in the future, the re…
602 …&quot;returnReadTimestamp&quot;: True or False, # If true, the Cloud Spanner-selected read timesta…
603 …&quot;strong&quot;: True or False, # Read at a timestamp where all previously committed transactio…
605 …o initiate a read-write transaction. Currently this transaction type has no options. # Transaction…
608 …&quot;id&quot;: &quot;A String&quot;, # Execute the read or SQL query in a previously-started tran…
609-used for the next transaction. It is not necessary to create a new session for each transaction. …
612 …: { # Message type to initiate a read-only transaction. # Transaction will not write. Authorizatio…
613 …amp that is `exact_staleness` old. The timestamp is chosen soon after the read is started. Guarant…
614Read data at a timestamp &gt;= `NOW - max_staleness` seconds. Guarantees that all writes that have…
615read, or data that is fresh enough to observe the effects of some previously committed transaction…
616read at the same timestamp always returns the same data. If the timestamp is in the future, the re…
617 …&quot;returnReadTimestamp&quot;: True or False, # If true, the Cloud Spanner-selected read timesta…
618 …&quot;strong&quot;: True or False, # Read at a timestamp where all previously committed transactio…
620 …o initiate a read-write transaction. Currently this transaction type has no options. # Transaction…
628 1 - v1 error format
629 2 - v2 error format
634 { # Results from Read or ExecuteSql.
637 …tructType. In turn, the order of fields matches the order of columns in a read request, or the ord…
644 …quot;transaction&quot;: { # A transaction. # If the read or SQL query began a transaction as a sid…
645 …action in subsequent Read, ExecuteSql, Commit, or Rollback calls. Single-use read-only transaction…
646read-only transactions, the read timestamp chosen for the transaction. Not returned by default: se…
656 …&quot;planNodes&quot;: [ # The nodes in the query plan. Plan nodes are returned in pre-order start…
659 { # Metadata associated with a parent-child relationship appearing in a PlanNode.
662Only present if the child node is SCALAR and corresponds to an output variable of the parent node.…
666 …on statistics associated with the node, contained in a group of key-value pairs. Only present if t…
671 …&quot;metadata&quot;: { # Attributes relevant to the node contained in a group of key-value pairs.…
674 …esentation&quot;: { # Condensed representation of a node and its subtree. Only present for `SCALAR…
676 …&quot;subqueries&quot;: { # A mapping of (subquery variable name) -&gt; (subquery node id) for cas…
683 …&quot;queryStats&quot;: { # Aggregated statistics from the execution of the query. Only present wh…
687 …&quot;rowCountLowerBound&quot;: &quot;A String&quot;, # Partitioned DML does not offer exactly-onc…
707 …tructType. In turn, the order of fields matches the order of columns in a read request, or the ord…
720 …ion returned in ResultSetStats. If partition_token is set, query_mode can only be set to QueryMode…
723 …ARGUMENT` error. See https://cloud.google.com/spanner/docs/query-optimizer/manage-query-optimizer …
727-request tag which can be applied to queries or reads, used for statistics collection. Both reques…
728read or query that belongs to a transaction. The value of transaction_tag should be the same for a…
731-transaction sequence number used to identify this request. This field makes each request idempote…
733Read or ExecuteSql call runs. See TransactionOptions for more information about transactions. # Th…
734-used for the next transaction. It is not necessary to create a new session for each transaction. …
737 …: { # Message type to initiate a read-only transaction. # Transaction will not write. Authorizatio…
738 …amp that is `exact_staleness` old. The timestamp is chosen soon after the read is started. Guarant…
739Read data at a timestamp &gt;= `NOW - max_staleness` seconds. Guarantees that all writes that have…
740read, or data that is fresh enough to observe the effects of some previously committed transaction…
741read at the same timestamp always returns the same data. If the timestamp is in the future, the re…
742 …&quot;returnReadTimestamp&quot;: True or False, # If true, the Cloud Spanner-selected read timesta…
743 …&quot;strong&quot;: True or False, # Read at a timestamp where all previously committed transactio…
745 …o initiate a read-write transaction. Currently this transaction type has no options. # Transaction…
748 …&quot;id&quot;: &quot;A String&quot;, # Execute the read or SQL query in a previously-started tran…
749-used for the next transaction. It is not necessary to create a new session for each transaction. …
752 …: { # Message type to initiate a read-only transaction. # Transaction will not write. Authorizatio…
753 …amp that is `exact_staleness` old. The timestamp is chosen soon after the read is started. Guarant…
754Read data at a timestamp &gt;= `NOW - max_staleness` seconds. Guarantees that all writes that have…
755read, or data that is fresh enough to observe the effects of some previously committed transaction…
756read at the same timestamp always returns the same data. If the timestamp is in the future, the re…
757 …&quot;returnReadTimestamp&quot;: True or False, # If true, the Cloud Spanner-selected read timesta…
758 …&quot;strong&quot;: True or False, # Read at a timestamp where all previously committed transactio…
760 …o initiate a read-write transaction. Currently this transaction type has no options. # Transaction…
768 1 - v1 error format
769 2 - v2 error format
774 …{ # Partial results from a streaming read or SQL query. Streaming reads and SQL queries better tol…
776 …ResultSet. # Metadata about the result set, such as row type information. Only present in the firs…
778 …tructType. In turn, the order of fields matches the order of columns in a read request, or the ord…
785 …quot;transaction&quot;: { # A transaction. # If the read or SQL query began a transaction as a sid…
786 …action in subsequent Read, ExecuteSql, Commit, or Rollback calls. Single-use read-only transaction…
787read-only transactions, the read timestamp chosen for the transaction. Not returned by default: se…
790 … connection loss. If this occurs, the stream of results can be resumed by re-sending the original …
791 …ese can be requested by setting ExecuteSqlRequest.query_mode and are sent only once with the last …
793 …&quot;planNodes&quot;: [ # The nodes in the query plan. Plan nodes are returned in pre-order start…
796 { # Metadata associated with a parent-child relationship appearing in a PlanNode.
799Only present if the child node is SCALAR and corresponds to an output variable of the parent node.…
803 …on statistics associated with the node, contained in a group of key-value pairs. Only present if t…
808 …&quot;metadata&quot;: { # Attributes relevant to the node contained in a group of key-value pairs.…
811 …esentation&quot;: { # Condensed representation of a node and its subtree. Only present for `SCALAR…
813 …&quot;subqueries&quot;: { # A mapping of (subquery variable name) -&gt; (subquery node id) for cas…
820 …&quot;queryStats&quot;: { # Aggregated statistics from the execution of the query. Only present wh…
824 …&quot;rowCountLowerBound&quot;: &quot;A String&quot;, # Partitioned DML does not offer exactly-onc…
826-strings are concatenated. [2, 3], [4] =&gt; [2, 3, 4] # Lists are concatenated, but the last and …
840 1 - v1 error format
841 2 - v2 error format
847 …&quot;approximateLastUseTime&quot;: &quot;A String&quot;, # Output only. The approximate timestamp…
848 …&quot;createTime&quot;: &quot;A String&quot;, # Output only. The timestamp when the session is cre…
849 …a-z]([-a-z0-9]*[a-z0-9])?`. * Label values must be between 0 and 63 characters long and must confo…
852 …&quot;name&quot;: &quot;A String&quot;, # Output only. The name of the session. This is always sys…
862 …s of using filters are: * `labels.env:*` --&gt; The session has the label &quot;env&quot;. * `labe…
864 …pageToken: string, If non-empty, `page_token` should contain a next_page_token from a previous Lis…
867 1 - v1 error format
868 2 - v2 error format
877 …&quot;approximateLastUseTime&quot;: &quot;A String&quot;, # Output only. The approximate timestamp…
878 …&quot;createTime&quot;: &quot;A String&quot;, # Output only. The timestamp when the session is cre…
879 …a-z]([-a-z0-9]*[a-z0-9])?`. * Label values must be between 0 and 63 characters long and must confo…
882 …&quot;name&quot;: &quot;A String&quot;, # Output only. The name of the session. This is always sys…
904 …teStreamingSql to specify a subset of the query result to read. The same session and read-only tra…
917 …tructType. In turn, the order of fields matches the order of columns in a read request, or the ord…
930 …tion is currently 10,000. The maximum value is currently 200,000. This is only a hint. The actual …
931 …tition generated. The default for this option is currently 1 GiB. This is only a hint. The actual …
933 …e ExecuteStreamingSql with a PartitionedDml transaction for large, partition-friendly DML operatio…
934 … a Read or ExecuteSql call runs. See TransactionOptions for more information about transactions. #…
935-used for the next transaction. It is not necessary to create a new session for each transaction. …
938 …: { # Message type to initiate a read-only transaction. # Transaction will not write. Authorizatio…
939 …amp that is `exact_staleness` old. The timestamp is chosen soon after the read is started. Guarant…
940Read data at a timestamp &gt;= `NOW - max_staleness` seconds. Guarantees that all writes that have…
941read, or data that is fresh enough to observe the effects of some previously committed transaction…
942read at the same timestamp always returns the same data. If the timestamp is in the future, the re…
943 …&quot;returnReadTimestamp&quot;: True or False, # If true, the Cloud Spanner-selected read timesta…
944 …&quot;strong&quot;: True or False, # Read at a timestamp where all previously committed transactio…
946 …o initiate a read-write transaction. Currently this transaction type has no options. # Transaction…
949 …&quot;id&quot;: &quot;A String&quot;, # Execute the read or SQL query in a previously-started tran…
950-used for the next transaction. It is not necessary to create a new session for each transaction. …
953 …: { # Message type to initiate a read-only transaction. # Transaction will not write. Authorizatio…
954 …amp that is `exact_staleness` old. The timestamp is chosen soon after the read is started. Guarant…
955Read data at a timestamp &gt;= `NOW - max_staleness` seconds. Guarantees that all writes that have…
956read, or data that is fresh enough to observe the effects of some previously committed transaction…
957read at the same timestamp always returns the same data. If the timestamp is in the future, the re…
958 …&quot;returnReadTimestamp&quot;: True or False, # If true, the Cloud Spanner-selected read timesta…
959 …&quot;strong&quot;: True or False, # Read at a timestamp where all previously committed transactio…
961 …o initiate a read-write transaction. Currently this transaction type has no options. # Transaction…
969 1 - v1 error format
970 2 - v2 error format
978 …&quot;partitionToken&quot;: &quot;A String&quot;, # This token can be passed to Read, StreamingRea…
982 …action in subsequent Read, ExecuteSql, Commit, or Rollback calls. Single-use read-only transaction…
983read-only transactions, the read timestamp chosen for the transaction. Not returned by default: se…
990read operation in parallel. Each of the returned partition tokens can be used by StreamingRead to …
1001 …&quot;index&quot;: &quot;A String&quot;, # If non-empty, the name of an index on table. This index…
1002only specified once. # Required. `key_set` identifies the rows to be yielded. `key_set` names the …
1003 …ys in the table or index. Note that any keys specified in `keys` or `ranges` are only yielded once.
1010-09-23&quot; Since the `UserEvents` table&#x27;s `PRIMARY KEY` clause names two columns, each `Use…
1027 …tion is currently 10,000. The maximum value is currently 200,000. This is only a hint. The actual …
1028 …tition generated. The default for this option is currently 1 GiB. This is only a hint. The actual …
1030 …ot;table&quot;: &quot;A String&quot;, # Required. The name of the table in the database to be read.
1031 … a Read or ExecuteSql call runs. See TransactionOptions for more information about transactions. #…
1032-used for the next transaction. It is not necessary to create a new session for each transaction. …
1035 …: { # Message type to initiate a read-only transaction. # Transaction will not write. Authorizatio…
1036 …amp that is `exact_staleness` old. The timestamp is chosen soon after the read is started. Guarant…
1037Read data at a timestamp &gt;= `NOW - max_staleness` seconds. Guarantees that all writes that have…
1038read, or data that is fresh enough to observe the effects of some previously committed transaction…
1039read at the same timestamp always returns the same data. If the timestamp is in the future, the re…
1040 …&quot;returnReadTimestamp&quot;: True or False, # If true, the Cloud Spanner-selected read timesta…
1041 …&quot;strong&quot;: True or False, # Read at a timestamp where all previously committed transactio…
1043 …o initiate a read-write transaction. Currently this transaction type has no options. # Transaction…
1046 …&quot;id&quot;: &quot;A String&quot;, # Execute the read or SQL query in a previously-started tran…
1047-used for the next transaction. It is not necessary to create a new session for each transaction. …
1050 …: { # Message type to initiate a read-only transaction. # Transaction will not write. Authorizatio…
1051 …amp that is `exact_staleness` old. The timestamp is chosen soon after the read is started. Guarant…
1052Read data at a timestamp &gt;= `NOW - max_staleness` seconds. Guarantees that all writes that have…
1053read, or data that is fresh enough to observe the effects of some previously committed transaction…
1054read at the same timestamp always returns the same data. If the timestamp is in the future, the re…
1055 …&quot;returnReadTimestamp&quot;: True or False, # If true, the Cloud Spanner-selected read timesta…
1056 …&quot;strong&quot;: True or False, # Read at a timestamp where all previously committed transactio…
1058 …o initiate a read-write transaction. Currently this transaction type has no options. # Transaction…
1066 1 - v1 error format
1067 2 - v2 error format
1075 …&quot;partitionToken&quot;: &quot;A String&quot;, # This token can be passed to Read, StreamingRea…
1079 …action in subsequent Read, ExecuteSql, Commit, or Rollback calls. Single-use read-only transaction…
1080read-only transactions, the read timestamp chosen for the transaction. Not returned by default: se…
1086 <code class="details" id="read">read(session, body=None, x__xgafv=None)</code>
1087 …rger than 10 MiB; if the read matches more data than that, the read fails with a `FAILED_PRECONDIT…
1090 session: string, Required. The session in which the read should be performed. (required)
1094 { # The request for Read and StreamingRead.
1098 …&quot;index&quot;: &quot;A String&quot;, # If non-empty, the name of an index on table. This index…
1099only specified once. # Required. `key_set` identifies the rows to be yielded. `key_set` names the …
1100 …ys in the table or index. Note that any keys specified in `keys` or `ranges` are only yielded once.
1107-09-23&quot; Since the `UserEvents` table&#x27;s `PRIMARY KEY` clause names two columns, each `Use…
1123 …&quot;limit&quot;: &quot;A String&quot;, # If greater than zero, only the first `limit` rows are y…
1127-request tag which can be applied to queries or reads, used for statistics collection. Both reques…
1128read or query that belongs to a transaction. The value of transaction_tag should be the same for a…
1130read, `resume_token` should be copied from the last PartialResultSet yielded before the interrupti…
1131 …ot;table&quot;: &quot;A String&quot;, # Required. The name of the table in the database to be read.
1132Read or ExecuteSql call runs. See TransactionOptions for more information about transactions. # Th…
1133-used for the next transaction. It is not necessary to create a new session for each transaction. …
1136 …: { # Message type to initiate a read-only transaction. # Transaction will not write. Authorizatio…
1137 …amp that is `exact_staleness` old. The timestamp is chosen soon after the read is started. Guarant…
1138Read data at a timestamp &gt;= `NOW - max_staleness` seconds. Guarantees that all writes that have…
1139read, or data that is fresh enough to observe the effects of some previously committed transaction…
1140read at the same timestamp always returns the same data. If the timestamp is in the future, the re…
1141 …&quot;returnReadTimestamp&quot;: True or False, # If true, the Cloud Spanner-selected read timesta…
1142 …&quot;strong&quot;: True or False, # Read at a timestamp where all previously committed transactio…
1144 …o initiate a read-write transaction. Currently this transaction type has no options. # Transaction…
1147 …&quot;id&quot;: &quot;A String&quot;, # Execute the read or SQL query in a previously-started tran…
1148-used for the next transaction. It is not necessary to create a new session for each transaction. …
1151 …: { # Message type to initiate a read-only transaction. # Transaction will not write. Authorizatio…
1152 …amp that is `exact_staleness` old. The timestamp is chosen soon after the read is started. Guarant…
1153Read data at a timestamp &gt;= `NOW - max_staleness` seconds. Guarantees that all writes that have…
1154read, or data that is fresh enough to observe the effects of some previously committed transaction…
1155read at the same timestamp always returns the same data. If the timestamp is in the future, the re…
1156 …&quot;returnReadTimestamp&quot;: True or False, # If true, the Cloud Spanner-selected read timesta…
1157 …&quot;strong&quot;: True or False, # Read at a timestamp where all previously committed transactio…
1159 …o initiate a read-write transaction. Currently this transaction type has no options. # Transaction…
1167 1 - v1 error format
1168 2 - v2 error format
1173 { # Results from Read or ExecuteSql.
1176 …tructType. In turn, the order of fields matches the order of columns in a read request, or the ord…
1183 …quot;transaction&quot;: { # A transaction. # If the read or SQL query began a transaction as a sid…
1184 …action in subsequent Read, ExecuteSql, Commit, or Rollback calls. Single-use read-only transaction…
1185read-only transactions, the read timestamp chosen for the transaction. Not returned by default: se…
1195 …&quot;planNodes&quot;: [ # The nodes in the query plan. Plan nodes are returned in pre-order start…
1198 { # Metadata associated with a parent-child relationship appearing in a PlanNode.
1201Only present if the child node is SCALAR and corresponds to an output variable of the parent node.…
1205 …on statistics associated with the node, contained in a group of key-value pairs. Only present if t…
1210 …&quot;metadata&quot;: { # Attributes relevant to the node contained in a group of key-value pairs.…
1213 …esentation&quot;: { # Condensed representation of a node and its subtree. Only present for `SCALAR…
1215 …&quot;subqueries&quot;: { # A mapping of (subquery variable name) -&gt; (subquery node id) for cas…
1222 …&quot;queryStats&quot;: { # Aggregated statistics from the execution of the query. Only present wh…
1226 …&quot;rowCountLowerBound&quot;: &quot;A String&quot;, # Partitioned DML does not offer exactly-onc…
1233 …is a good idea to call this for any transaction that includes one or more Read or ExecuteSql reque…
1246 1 - v1 error format
1247 2 - v2 error format
1252 …{ # A generic empty message that you can re-use to avoid defining duplicated empty messages in you…
1258 …<pre>Like Read, except returns the result set as a stream. Unlike Read, there is no limit on the s…
1261 session: string, Required. The session in which the read should be performed. (required)
1265 { # The request for Read and StreamingRead.
1269 …&quot;index&quot;: &quot;A String&quot;, # If non-empty, the name of an index on table. This index…
1270only specified once. # Required. `key_set` identifies the rows to be yielded. `key_set` names the …
1271 …ys in the table or index. Note that any keys specified in `keys` or `ranges` are only yielded once.
1278-09-23&quot; Since the `UserEvents` table&#x27;s `PRIMARY KEY` clause names two columns, each `Use…
1294 …&quot;limit&quot;: &quot;A String&quot;, # If greater than zero, only the first `limit` rows are y…
1298-request tag which can be applied to queries or reads, used for statistics collection. Both reques…
1299read or query that belongs to a transaction. The value of transaction_tag should be the same for a…
1301read, `resume_token` should be copied from the last PartialResultSet yielded before the interrupti…
1302 …ot;table&quot;: &quot;A String&quot;, # Required. The name of the table in the database to be read.
1303Read or ExecuteSql call runs. See TransactionOptions for more information about transactions. # Th…
1304-used for the next transaction. It is not necessary to create a new session for each transaction. …
1307 …: { # Message type to initiate a read-only transaction. # Transaction will not write. Authorizatio…
1308 …amp that is `exact_staleness` old. The timestamp is chosen soon after the read is started. Guarant…
1309Read data at a timestamp &gt;= `NOW - max_staleness` seconds. Guarantees that all writes that have…
1310read, or data that is fresh enough to observe the effects of some previously committed transaction…
1311read at the same timestamp always returns the same data. If the timestamp is in the future, the re…
1312 …&quot;returnReadTimestamp&quot;: True or False, # If true, the Cloud Spanner-selected read timesta…
1313 …&quot;strong&quot;: True or False, # Read at a timestamp where all previously committed transactio…
1315 …o initiate a read-write transaction. Currently this transaction type has no options. # Transaction…
1318 …&quot;id&quot;: &quot;A String&quot;, # Execute the read or SQL query in a previously-started tran…
1319-used for the next transaction. It is not necessary to create a new session for each transaction. …
1322 …: { # Message type to initiate a read-only transaction. # Transaction will not write. Authorizatio…
1323 …amp that is `exact_staleness` old. The timestamp is chosen soon after the read is started. Guarant…
1324Read data at a timestamp &gt;= `NOW - max_staleness` seconds. Guarantees that all writes that have…
1325read, or data that is fresh enough to observe the effects of some previously committed transaction…
1326read at the same timestamp always returns the same data. If the timestamp is in the future, the re…
1327 …&quot;returnReadTimestamp&quot;: True or False, # If true, the Cloud Spanner-selected read timesta…
1328 …&quot;strong&quot;: True or False, # Read at a timestamp where all previously committed transactio…
1330 …o initiate a read-write transaction. Currently this transaction type has no options. # Transaction…
1338 1 - v1 error format
1339 2 - v2 error format
1344 …{ # Partial results from a streaming read or SQL query. Streaming reads and SQL queries better tol…
1346 …ResultSet. # Metadata about the result set, such as row type information. Only present in the firs…
1348 …tructType. In turn, the order of fields matches the order of columns in a read request, or the ord…
1355 …quot;transaction&quot;: { # A transaction. # If the read or SQL query began a transaction as a sid…
1356 …action in subsequent Read, ExecuteSql, Commit, or Rollback calls. Single-use read-only transaction…
1357read-only transactions, the read timestamp chosen for the transaction. Not returned by default: se…
1360 … connection loss. If this occurs, the stream of results can be resumed by re-sending the original …
1361 …ese can be requested by setting ExecuteSqlRequest.query_mode and are sent only once with the last …
1363 …&quot;planNodes&quot;: [ # The nodes in the query plan. Plan nodes are returned in pre-order start…
1366 { # Metadata associated with a parent-child relationship appearing in a PlanNode.
1369Only present if the child node is SCALAR and corresponds to an output variable of the parent node.…
1373 …on statistics associated with the node, contained in a group of key-value pairs. Only present if t…
1378 …&quot;metadata&quot;: { # Attributes relevant to the node contained in a group of key-value pairs.…
1381 …esentation&quot;: { # Condensed representation of a node and its subtree. Only present for `SCALAR…
1383 …&quot;subqueries&quot;: { # A mapping of (subquery variable name) -&gt; (subquery node id) for cas…
1390 …&quot;queryStats&quot;: { # Aggregated statistics from the execution of the query. Only present wh…
1394 …&quot;rowCountLowerBound&quot;: &quot;A String&quot;, # Partitioned DML does not offer exactly-onc…
1396-strings are concatenated. [2, 3], [4] =&gt; [2, 3, 4] # Lists are concatenated, but the last and …