Stack Overflow
Stack Overflow

Questions tagged [google-cloud-spanner]

Google Cloud Spanner is a relational, highly scalable, managed, database service. Cloud Spanner solves the need for a horizontally-scaling database with consistent global ACID transactions and SQL semantics

Google Cloud Spanner is the first and only relational database service that is both strongly consistent and horizontally scalable. Features include:

  • ACID transactions,
  • Relational schemas (and schema changes without downtime),
  • SQL queries, high performance,
  • Automatic scaling for horizontal scalability to hundreds or thousands of servers
  • Synchronous data replication, and node redundancy
  • Up to 99.999% (five 9s) of availability
  • Based upon the published Spanner research paper

Stack Overflow is Google's official community support channel for development questions.

Please include the appropriate client library language tag (, , , or ) with your question. You can also include the platform tag (, , or ).

647 questions
0
votes
1 answer

Simulate a failed Cloud Spanner node or replica

I have a need to demonstrate what happens when a failed replica or node occurs. I know Spanner is a managed service and we trust its availability, but how can I simulate a failed a failed node or replica? Also, is there a method to return a value…
Robert Margeson
  • 23
  • 4
0
votes
2 answers

Using google spanner in dataflow 2.3.0

I'm trying to write to spanner some messages from google pub/sub. Writing to bigtable works, so nothing is missing at the fundamental level. I've upgraded to google-cloud-dataflow-java-sdk-all v2.3.0, which includes the SpannerIO sink. I've…
Flavius
  • 13,566
  • 13
  • 80
  • 126
0
votes
1 answer

Optimizing hierarchical data sets for reads of whole hierarchies

I am migrating an app from Oracle to Google Spanner. One of the cases we came across are relationships between rows in the same table. These relationships have a tree-like structure, always having one parent and one root of the hierarchy…
wojciechka
  • 21
  • 5
0
votes
2 answers

Spanner - delete one row or all rows from a table

I would like to delete one row or all rows from a spanner table. The primary key of the table is an int64. I do not want to drop the table and recreate it. I am using the google supplied Java tutorial as a guideline (I am not a Java programmer -…
Dave
  • 123
  • 2
  • 13
0
votes
1 answer

spanner ResultSet.next() does pagination internally?how it will return billions of rows?

I'm using java spanner read api. In the read call is the table has billions of data then spanner ResultSet.next() does pagination internally? How it will return billions of rows?
Infa GBQ
  • 1
0
votes
1 answer

Google spanner JDBC driver connection parameters

Using JDBC client (Squirrel SQL), we have tried to connect to Spanner instance. But we ended up in an issue.​ Before experimenting Spanner, we tried to connect AWS aurora mysql DB with Squirrel SQL through mysql JDBC driver. It was successful and…
Sanjiv krish
  • 1
  • 1
0
votes
0 answers

Table creation taking a long time

Similar to GCP table creation taking a long time to create I attempted to read the issuetracker in this comment, but I could not see the link destination. What was the cause of this?
Hideyuki Okada
  • 11
  • 5
0
votes
1 answer

apache beam stream processing failure recovery

Running a streaming beam pipeline where i stream files/records from gcs using avroIO and then create minutely/hourly buckets to aggregate events and add it to BQ. In case the pipeline fails how can i recover correctly and process the unprocessed…
user179156
  • 841
  • 9
  • 31
0
votes
1 answer

This instance has too many database splits to complete the operation

Until now, even if 20 per database were created, no error was issued, but when I made suddenly more than 16 suddenly I got an error. It is totally different from what is described in https://cloud.google.com/spanner/quotas. I do not understand the…
yoheimuta
  • 44
  • 5
0
votes
1 answer

cloud spanner python client delete failed with INT64 type

I'm trying to pass delete requests on a table with INT64 typed keys, and I receive the following error: Invalid value for column key1 in table INT_KEYS: Expected INT64 is there a specific way to type the key ranges when requesting a delete…
Thibault Lefevre
  • 83
  • 4
0
votes
0 answers

How to write nullable columns where conditions are set by parameters - Google Spanner

If I have a table Goods have a nullable column receivedStockId receivedStockId INT64 I cannot write a select-statement like below: select * from Goods where receivedStockId=@receivedStockId My current solution is: select * from Goods where…
Chipintoza
  • 295
  • 4
  • 16
0
votes
1 answer

How to delete all active spanner sessions?

I have a spanner instance which currently has about 20000 active sessions connected to it. I am not sure how I would be able to delete them all in one go? I tried makeing an api request…
Raman
  • 216
  • 3
  • 15
0
votes
1 answer

read() with Keysets, ranges

I've started playing around with the Spanner Python client (on appengine flex), but I'm hitting a few walls when trying to reuse the doc examples. One issue I'm facing is trying to read the database: execute_sql() returns empty sets (even with a…
Thibault Lefevre
  • 83
  • 4
0
votes
1 answer

Invalid permissions for spanner during mvn test in travis

Has anyone come across a way to run google spanner maven tests (creating and deleted databases), I always get invalid permissions. These test are being run as a service account owner that has been confirmed to run locally. When running travis in…
mtpa42
  • 11
  • 1
  • 3
0
votes
1 answer

Locking Behavior In Spanner vs MySQL

I'm exploring moving an application built on top of MySQL into Spanner and am not sure if I can replicate certain functionality from our MySQL db. basically a simplified version of our mysql schema would look like this users…
Tucker Joseph
  • 11
  • 2
1 2 3
…
43 44