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
0 answers

TaskCanceledException running large query against Spanner using .NET Nuget packages

Running a simple query like a select against a small table and I get results back; executing the same code using a more complex query and it errors out with a Task Canceled Exception. var executeSqlRequest =…
dr3x
  • 917
  • 2
  • 14
  • 26
0
votes
1 answer

Can a child have multiple parents in google spanner?

I was trying out the google spanner and couldnt find in any docs about wether a child table can have multiple parent tables. I think there cannot be such a case, just wanted to make sure. Thank you.
Akash Dathan
  • 4,348
  • 2
  • 24
  • 45
0
votes
0 answers

spanner not able to run at all on appengine

Hi maybe it is a stupid question but currently I am testing on using spanner with appengine. However I have problem even running an empty transaction neither local nor remote environment. I have tried both mvm and flex. What I basically did is just…
Xinwei Liu
  • 333
  • 6
  • 15
0
votes
1 answer

Does Google Cloud Spanner support 'struct' type?

Seems that spanner support struct type. https://cloud.google.com/spanner/docs/data-types#struct-type However, DDL didn't mention how to use. https://cloud.google.com/spanner/docs/data-definition-language#data_types It's really confuse me, or I got…
Ben
  • 3
  • 1
0
votes
3 answers

Connecting to Google Cloud Spanner from DBVisualizer

I've created a test cloud spanner instance and database have have been attempting to connect to it through DBVisualizer. I have authenticated using the gcloud auth command, and have the driver set up within DBVisualizer. The connection string I'm…
SkydivingCoder
  • 113
  • 1
  • 8
0
votes
1 answer

Adding edit role for a service account to an individual Cloud Spanner database

How can I add a role for edit permissions to my service account to an individual Cloud Spanner database in my project, without granting it for any others. Is this possible from console.cloud.google.com?
Chipintoza
  • 295
  • 4
  • 16
0
votes
1 answer

How do I integrate Cloud Spanner with a GAE Python app?

I would like to create a hello world Python app which calls a simple Google Cloud Spanner table. I'd like an end-to-end example with population of the DB, querying a couple of tables and possibly inserting an element from App Engine endpoint. [1]…
Riccardo
  • 1,104
  • 13
  • 22
0
votes
0 answers

google spanner close connection

I running my api based on swagger and node. When my api is running for few minutes without a request and then i send an api request to it, I got this error: { Error: {"created":"@1488097564.272436000","description":"Delayed close due to in-progress…
Aron
  • 1,179
  • 15
  • 29
0
votes
1 answer

Query works in the Web Interface correctly but with the node.js client dosn't work

I have the following query: let query = { sql:`SELECT id, name, ARRAY(SELECT AS STRUCT name, id FROM files WHERE files.id in UNNEST(articles.files)) AS files FROM articles WHERE lang = @lang AND id = @id`, params:{ lang:…
Aron
  • 1,179
  • 15
  • 29
0
votes
1 answer

Insert Large data into Cloud Spanner Table

I want to insert large data into Google's Cloud Spanner Table. This is what i'm doing with node.js app, but it stops because the txt file is too large(almost 2GB). 1.load txt file 2.read line by line 3.split the line by "|" 4.build data…
Jieun Park GOLD24PARK
  • 47
  • 2
  • 7
0
votes
1 answer

How to easily get most recent version of data for all keys?

I'm trying to create some tables with the following characteristics: Stores the all versions of data for a particular key Able to easily get the most recent versions of data for all keys My schema is as follows: CREATE TABLE WebSitesStatus( --…
Mike Curtiss
  • 1,838
  • 2
  • 17
  • 33
0
votes
1 answer

Cloud Spanner index selection criteria

How does Cloud Spanner decide which of the available secondary indices to use, or whether to use one at all? Is there documentation on how your query planner works?
willwilson
  • 422
  • 3
  • 8
0
votes
1 answer

Simulate a table with multiple keys

My project has a need for storage such that Data is formed like tuples of . and are both valid primary keys. Users can tell my project and get C, or can tell my project and get B. I'm struggling to make this work…
Mike Curtiss
  • 1,838
  • 2
  • 17
  • 33
0
votes
1 answer

Partial key on secondary index

I have a secondary index on a table: CREATE NULL_FILTERED INDEX RidesByPassenger ON Rides( passenger_id, start_time, ) If I run the following query: SELECT start_time FROM Rides@{FORCE_INDEX=RidesByPassenger} WHERE passenger_id='someid' AND…
Chi
  • 259
  • 3
  • 11
0
votes
1 answer

Array index is out of bounds in Cloud Spanner

I have the following query: SELECT * FROM Concerts WHERE (ARRAY_LENGTH(TicketPrices) > 0 AND TicketPrices[OFFSET(0)] IS NOT NULL); and I got: ERROR: OUT_OF_RANGE: Array index 0 is out of bounds. Why is the 2nd part being evaluated even when the…
Mike Curtiss
  • 1,838
  • 2
  • 17
  • 33
1 2 3
…
43 44