737 questions
1
vote
1
answer
39
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
51
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
60
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 (...
- 811
0
votes
1
answer
37
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
131
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
0
answers
35
views
MyBatis With Cloud Spanner -- Is Selecting A Collection of Inner POJOs w/Single Parent Key From Single Table Possible?
Looking at the MyBatis docs for building entities which themselves contain lists of other entities, the following SHOULD work unless I'm misunderstanding (completely possible), but it results in ...
0
votes
2
answers
123
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,772
0
votes
0
answers
38
views
Convert OffsetDateTime to com.google.cloud.Timestamp for GCP Spanner TIMESTAMP
I am using Java 21 Spring Boot 3.4.2 and SpannerTemplate. I need to convert a field OffsetDateTime to the com.google.cloud.Timestamp for the TIMESTAMP column in the database.
I tried implementing ...
- 398
0
votes
1
answer
121
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
0
answers
59
views
Can I do Entity Resolution at scale with Google Spanner using Multiple Embeddings and Vector Indexes to Merge Company Data from Multiple Providers?
I'm working on merging company data from 3 or more different providers. I'm exploring an entity resolution approach using separate embeddings for name, location, and domain, stored in vector indexes. ...
0
votes
1
answer
198
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,772
0
votes
1
answer
70
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
49
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,189
1
vote
1
answer
175
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 ...
- 581
0
votes
1
answer
239
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 ...
- 581