737 questions
-3
votes
1
answer
52
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
0
votes
2
answers
73
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
51
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
37
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
0
answers
60
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 ...
- 428
0
votes
0
answers
66
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
79
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
1
answer
206
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
309
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
0
votes
1
answer
110
views
Created scheduled backups using Spanner's new built-in feature don't trigger the actual backup
I'm testing the new feature in Spanner to have scheduled backups. I've created several, some manually, and some through our Terraform automation.
I have a schedule that should create incremental ...
- 649
0
votes
2
answers
286
views
Connecting to Spanner with DBeaver
I can connect using a key generated from a service account but I don't have the option to connect with IAM using my own google account.
The documentation shows this screenshot:
The problem is my ...
- 13
-1
votes
1
answer
286
views
Possible to do a Graph query in BigQuery?
Cloud Spanner supports GQL, and it's possible to set Spanner as an external dataset for BigQuery, such as indicated here. Given this, is it possible to execute a GQL query in BigQuery, even if written ...
- 112k
1
vote
1
answer
139
views
Restarting the SpannerIO's ChangeStream to GCS (TEXT/JSON) Pipeline Got Error
I have setup this pipeline: https://cloud.google.com/dataflow/docs/guides/templates/provided/cloud-spanner-change-streams-to-cloud-storage, by:
hardcode the startTime to certain time (not using ...
- 3,834
0
votes
1
answer
123
views
Spanner - many smaller transactions vs fewer larger ones?
Context
I tried to seek the answer with search, but all what I found was for general SQL context, not specific from Spanner point of view.
There are like 150-200K of accounts overall.
There are 2 ...
- 365
0
votes
2
answers
163
views
Importing CSV file to Spanner Error (Parse Date)
I started to follow the official documentation of gcp in order to import my csv data to an instance on cloud spanner spanner, but I'm getting thhis error:
*Error java.time.format....
- 753
0
votes
1
answer
193
views
Spanner JDBC Driver option to avoid latency
We are using the google spanner jdbc driver(google-cloud-spanner-jdbc) to enable connectivity from our application to cloud spanner. This was used instead of the google client libraries to reuse the ...
0
votes
1
answer
194
views
Why is this KNN vector query to a Google Spanner database taking over 30 seconds?
I've got a document database with about 6,000 records. I've successfully used vector database backends for RAG queries with these records. I'd like to move to from a vector-specific database to Google'...
- 2,066
1
vote
1
answer
234
views
When Google Cloud Spanner will do a full table scan?
CREATE TABLE Account (
ID STRING(100) NOT NULL,
BSB STRING(20) NOT NULL,
AccNum STRING(100) NOT NULL,
) PRIMARY KEY(ID);
In this Account table, ID is the only primary key. There's no index on ...
- 303
2
votes
0
answers
870
views
@JdbcTypeCode issue with Hibernate 6.x version
I am currently using Hibernate 6.4.4 version, along with spanner-hibernate-dialect 3.3.0 version and google-cloud-spanner-jdbc 2.16.1 version. But still facing the below error as:
org.springframework....
-1
votes
1
answer
75
views
Implicitly creating a struct
In the following query:
select t, 1 from (select 1 as a, 2 as b) t
It produces a column of struct type: {"a": 1, "b": 2} for the column t. Is this the expected behavior, and if so ...
- 112k
1
vote
1
answer
102
views
Why do I see a dip in GCP Spanner 'Total storage' graph?
We have been using Spanner and recently noticed a dip in the 'Total storage' graph in 'System insights' which is not expected and we would like to know what are the possible causes for the storage to ...
- 33
0
votes
1
answer
369
views
Hibernate 6 and Cloud Spanner intergration
Currently I'm trying to migrate the app to spring boot 3 and hibernate 6.
I faced the issue that when I insert the data where the column has to be in json format I get an error
could not execute ...
0
votes
1
answer
69
views
Cloud Spanner: Statement failed: ML functions are not available in granular instances
I am following the similarity search tutorial of Cloud Spanner, by executing the commands as outlined here:
https://codelabs.developers.google.com/codelabs/similary-search-spanner-vertex#2
At step 4 ...
- 7,054
0
votes
1
answer
142
views
In Cloud Spanner, from an API perspective, does partitionDML follows the same behavior of retries / timeouts?
From an API perspective, does partitionDML follows the same behavior of retries / timeouts? are all partitions retried? Or only the failed ones?
how often and what is the maximum interval this would ...
- 57
-1
votes
1
answer
369
views
Does Cloud Spanner support conditional TTL on a row?
We have a use case where we only want to mark only selected rows for deletion based on the value of a non timestamp column (State column) and the time elapsed since the row was created? Is there a way ...
- 57