734 questions
Best practices
0
votes
4
replies
62
views
Dynamic field search in Spanner DB
We're building a SaaS platform for which we need to design a data model which could accompany domain specific data. We don't know the structure of domain specific data. So these are the evaluated ...
- 323
-3
votes
1
answer
84
views
Why are there no records read from spanner change stream?
I'm trying to write a Python GCP dataflow that processes records from a Spanner change stream and prints them out. I am running it locally and it appears to work but prints no records when I update a ...
- 525
1
vote
1
answer
68
views
Cloud Spanner doesn't enforce referential integrity between parent and child, What does this mean?
INTERLEAVE IN child tables share the same physical row interleaving characteristics, but Spanner doesn't enforce referential integrity between parent and child.
What is meant by this? Because I'm ...
- 13
0
votes
2
answers
104
views
Cloud build error in liquibase step to enable spanner API
I have setup a GCP project for build activities that support multiple GCP projects deployments, this way I have one place to manage the CI/CD and in this project no other resources APIs like spanner ...
- 85
0
votes
1
answer
88
views
GCP Spanner Insert error- Row [4503837324345344] in Table was already inserted in this transaction
I am trying to insert data into a spanner table using its python client library. The table's DDL is
CREATE TABLE MyTable (
Id INT64,
name STRING(MAX),
curr_timestamp TIMESTAMP NOT NULL OPTIONS (...
- 831
0
votes
1
answer
76
views
Arrow Flight SQL with Google Spanner
I found out there is a possibility to connect Arrow Flight SQL connector to Postgres database, and I know there is a possibility to configure Spanner database to act like a Postgres one, so is it ...
0
votes
0
answers
242
views
Spanner error while updating data into a JSON column
I am working with the GCP Spanner database using the sqlalchemy ORM. This is the table schema where I am trying to insert/update (based on a check) data into a JSON column:
from sqlalchemy import ...
0
votes
2
answers
181
views
Google Cloud Spanner Graph Joins
I have 2 tables (InterestCategory and Interest) and a graph (TestGraph) in my Google Cloud Spanner database
CREATE TABLE InterestCategory
(
interest_category_id STRING(36) NOT NULL,
...
- 1,780
0
votes
1
answer
170
views
Should we retry a query if spanner returns ResourceExhausted error?
Recently I have seen the following error in my logs using the method ReadWriteTransaction from the spanner library:
*status.Error: rpc error: code = ResourceExhausted desc = Failing fast as CPU ...
- 329
0
votes
1
answer
310
views
How to create temporary tables in Spanner
Is there any way to create a temporary table in Google Cloud Spanner through:
SELECT * INTO <temp table> FROM <table name>
where I can then use the temp table with multiple other queries ...
- 1,780
0
votes
1
answer
102
views
Persisting Data in spanner with JPA and Hibernate 6
I am working on integrating spanner with our existing application. I'm facing an error when trying to save/persist data into DemoClass entity in spanner using JPA and hibernate 6. The error I'm facing ...
- 1
1
vote
0
answers
60
views
Best POM for Google Spanner and Dataflow
I've been getting bizarre ClassNotFound errors in this io.grpc library, strange timeout errors, etc. Plus I saw on an old document there's a need to enforce the minimum version. I've tried building a ...
- 1,209
1
vote
1
answer
254
views
Persisting Json Data in Spanner with JPA and Hibernate 6
I am working on analysis of spanner for compatibility for our existing application migration. I am facing an error when trying to insert json data into a column in spanner using JPA and hibernate 6.
I ...
- 591
0
votes
1
answer
340
views
Integrating Google Cloud Spanner with Spring Data JPA
I'm migrating my springboot app from cloud SQL (PostgresSQL) to Cloud Spanner and will be using Google SQL dialect for spanner interaction. During this migration, i am facing the below error.
Caused ...
- 591
0
votes
1
answer
365
views
The method `run_in_transaction` of Spanner client library for Python returned a message "Transaction is not begun."
After I obtain my authenticate key with gcloud CLI, I try to execute the below Python code to create a table in my instance of Spanner.
However, Spanner returned a message "Transaction is not ...
- 15