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

Transient fault exception during bulk insert in Google Cloud Spanner

I am currently testing Google Cloud Spanner as an alternative to MySQL for one project since I expect the amount of rows to grow to hundreds of millions over time. The DB needs to respond very fast and return query results within seconds so I…
Roman Komůrka
  • 11
  • 3
0
votes
0 answers

Cloud Spanner CPU usage increases with table size

A multi-day test run with Spanner has shown an massively increasing CPU usage with growing table size. I'm trying to figure out what could be the reason. Summary of the usage: Small size rows (400 byte per row) Average around 500 reads (with 0…
Chrisport
  • 2,936
  • 3
  • 15
  • 19
0
votes
2 answers

Access google cloud spanner database list using service account

We have created cloud spanner instance and databases on google cloud console. Following code snippet which we are executing. def getDatabaseList(self,): try: parent = "projects/"+self._PROJECT_NAME + "/instances/" + self._INSTANCE_NAME …
Sagar Kanabar
  • 464
  • 4
  • 18
0
votes
1 answer

Ruby: Cloud Spanner insert performance

I came across the google-cloud-spanner gem for Ruby. Using session.commit { |c| c.insert(table, row) } I can insert into Cloud Spanner easily. However, I cannot exceed more than ~200 inserts per Second this way (from a computing instance in the same…
J.Doe
  • 61
  • 3
0
votes
1 answer

See load of separate instances on Google Cloud Spanner

Is there a way to see CPU utilisation per configured instance ? Currently I only see one CPU utilisation no matter if 1 or 3 instances of Google Cloud Spanner are configured. This would be interesting to get a glimpse if our data-structure balances…
Christian Gintenreiter
  • 168
  • 9
0
votes
2 answers

IN UNNEST(@array_parameter) - how specify @array_parameter as array of objects

I am using spanner nodejs client library. I need to request query like: database.run({ sql: `SELECT * FROM Goods@{FORCE_INDEX=GoodsByCodeName} WHERE (code, name) in UNNEST(@codesNames)`, params: {codesNames: codesNames}}, ... How specify type of…
Chipintoza
  • 295
  • 4
  • 16
0
votes
1 answer

Best way to add new columns

What are best practices around adding new columns to tables? How do people usually do this since non-NULL defaults aren't allowed?
Mike Curtiss
  • 1,838
  • 2
  • 17
  • 33
0
votes
1 answer

Google Spanner | java.lang.IllegalArgumentException: Jetty ALPN/NPN has not been properly configured

So i have a problem that i've seen before but all attempts to use other fixes have not worked. I'm havinga problem with the Google Spanner, more specifically at the line: SpannerOptions options = SpannerOptions.newBuilder().build(); Where I receive…
Daniel Hawes
  • 77
  • 1
  • 1
  • 9
0
votes
1 answer

Google Spanner NullPointerException at SpannerOptions

I'm trying to initiate and add to a Google Spanner during runtime. However, when I reach this line: SpannerOptions options = SpannerOptions.newBuilder().build(); I get this stack trace: 2017-08-14…
Daniel Hawes
  • 77
  • 1
  • 1
  • 9
0
votes
1 answer

Safely segregating customer data in Spanner

We're exploring options for reliably segregating customer data in Spanner. The most obvious solution is a customer per database, but the 100 database/instance limitation renders that impractical. Past experience leads me to be very suspicious of any…
Joel Webber
  • 222
  • 1
  • 8
0
votes
1 answer

Read Only Transaction - Performance of time stamp bound reads

I am referring the Read-Only transaction, with option min_read_timestamp. As per the document, that executes all reads at a timestamp >= min_read_timestamp. Assume I have a table with many million rows, but from a specific timestamp, only few rows…
kanagaraj palanisamy
  • 347
  • 4
  • 15
0
votes
1 answer

ODBC support for Spanner

We do have a third party Tax calculation software which natively supports Oracle and SQL Server DB as well as ODBC. Does spanner team has any plan to provide the ODBC driver that can be used with such software?
kanagaraj palanisamy
  • 347
  • 4
  • 15
0
votes
1 answer

Can Spanner maintain indexes to easily count analytics queries of my data?

I'd like to give my partners the results of simple COUNT(*) ... GROUP BY items.color type queries and perhaps joins over items and orders or some such. I'd like query response time to be sub-second (on the order of a second, at worst), and scale to…
Andrey Fedorov
  • 9,148
  • 20
  • 67
  • 99
0
votes
1 answer

Cloud Spanner max number of DatabaseClient

Is there a maximum number of DatabaseClient that can be created for an instance of Google Cloud Spanner? Will the number of DatabaseClient affect to the performance?
Miftah Fathudin
  • 43
  • 8
0
votes
1 answer

Recursive queries in Google Spanner?

I have tried to implement recursive queries using CTE and CONNECT BY statements with no luck. Is it possible to implement recursive queries in Google Spanner?
Bullet-tooth
  • 782
  • 1
  • 10
  • 16
1 2 3
…
43 44