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

How can I make UNION ALL faster?

I have a Cloud Spanner query that is the UNION ALL of potentially many subqueries, which are all identical except for a few parameters that vary with each subquery: (SELECT t.FirstName, t.BirthDate FROM Singers AS t WHERE SingerId=2 AND…
Mike Curtiss
  • 1,838
  • 2
  • 17
  • 33
0
votes
1 answer

Programmatically building SQL query

I’d like to automatically build up a SQL query based on some strings passed in by my users. Are there any helper methods for doing that in the Cloud Spanner APIs?
Mairbek Khadikov
  • 7,939
  • 3
  • 35
  • 51
0
votes
1 answer

Does Google's Spanner DB implement a concept of Epochal Time?

I'm reading the paper for Google's Spanner DB. This appears to address some similar problems to Rich Hickey's Datomic. Does Google's Spanner DB implement a concept of Epochal Time?
hawkeye
  • 34,745
  • 30
  • 150
  • 304
-1
votes
1 answer

Google Cloud Spanner - One to one relationship clarification

In the google spring cloud documentation, it is mentioned that While one-to-one and many-to-many relationships can be implemented in Cloud Spanner and Spring Data Cloud Spanner using constructs of interleaved parent-child tables, only the…
Rocky
  • 391
  • 7
  • 20
-1
votes
1 answer

How to access a view in spanner?

I see you can create views in spanner (awesome!). My use case is for our analytics, we often have to do joins constantly and having a view seems to make it accessible by our app. But in the documentation, I see we cannot access them via the read…
Lostsoul
  • 25,013
  • 48
  • 144
  • 239
-1
votes
1 answer

How to find Google Spanner table creation date and time?

I am trying to the table creation date and time in Google Spanner but I dont see any option exist. Even there is no information available in the information.schema
Peter Sahayaraj Martin
  • 1
-1
votes
2 answers

Cloud Spanner - Read rows, but no returned columns?

Is there a possibility to return column names with the data that is returned? For example https://cloud.google.com/spanner/docs/reads#single_read_methods: def query_data(instance_id, database_id): """Queries sample data from the database using…
user1157751
  • 2,427
  • 6
  • 42
  • 73
-1
votes
1 answer

Primary Key and Index

Table Schema Columns: A, B, C, D, E I have a primary key in the table which combines (A, B) and I have a query -> Select all from the table whose A = 123. So the above query will scan the whole table or not? If it will scan the table then the only…
Ankur Verma
  • 75
  • 1
  • 12
-1
votes
2 answers

GCP SPANNER: What options can be set on a column in table other than allow_commit_timestamp=true for timestamp datatype

I want to understand what properties can be set on a Column in Spanner table. I only see length, not null, allow_commit_timestamp=true (for timestamp). Do we have any options like: - Unique property - so that record insert gives an error if another…
Ayush
  • 121
  • 1
  • 13
-1
votes
3 answers

Is Google Cloud Spanner table have any TTL(Time to Live) setup for required data or table

Dear Cloud Spanner Support Is there any option for TTL(Time to Live) on Google Cloud Spanner table . If yes Please provide any additional information Thank you Sreeni
Sreeni630
  • 21
  • 2
-1
votes
1 answer

Cloud Spanner administration UI, API also stopped working

It stopped working my account at the present moment. Since there is no fault status, write it here. Do you replicate with other accounts? Because different ones of different regions also occur simultaneously, I suspects the trouble.
yoheimuta
  • 44
  • 5
-1
votes
3 answers

Can I automatically populate `created_at` timestamp to transaction timestamp with Google Spanner?

I am looking through the documentation for Google Cloud Spanner, and it looks like write operations return a timestamp when the row was actually written. But when reading rows, it doesn't seem possible to re-capture that timestamp (either as a…
dolan
  • 1,716
  • 11
  • 22
-1
votes
1 answer

Protobuf as a data type and conversion to struct

Could we use a protobuf to store a complex value in a column in cloud spanner and convert it (hopefully automatically :-) ) to a struct when retrieving it? We know we can have struct as a datatype but this might be a feasible workaround.
Bart Van den Bosch
  • 31
  • 1
  • 3
-1
votes
2 answers

Is there a list of reserved words for Cloud Spanner?

Is there a documented list of keywords for Cloud Spanner? For example, is CONTAINS a reserved word?
Walter Poupore
  • 47
  • 5
-2
votes
2 answers

GCP Spanner Template ReadWrite Transaction Not Working

I want to perform units of work in a single transaction using Google spanner template, spannerTemplate.performReadWriteTransaction(trasac -> { // Write in table 1 // Write in table 2 }); Am getting exception as 'Nested transactions are not…
wild
  • 169
  • 1
  • 3
  • 19
1 2 3
…
43
44