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
721
questions
0
votes
1
answer
36
views
HikariCP keep alive query leaking Google Spanner Sessions
I have a spring boot application using HikariCP. The app connects to a google spanner db. I am seeing the following session leak exception caused by HikariCP keep alive queries
at com.google.cloud....
0
votes
1
answer
34
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
0
answers
39
views
How to configure GCP Spanner ChangeStream read duration in java
We are using GCP spanner changestream in our apache beam java dataflow job. And using SpannerIO connector we are configured it. Code is below,
static class Read extends PTransform<PBegin, ...
0
votes
1
answer
45
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'...
0
votes
0
answers
36
views
What is the performant way to store and query graph like data?
Entity Relationship Diagram
I have relationship tables representing above graph with just ids in them
CREATE TABLE USER_ORG (
USER_ID STRING(100) NOT NULL,
ORG_ID STRING(100) NOT NULL,
...
1
vote
0
answers
47
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 ...
0
votes
1
answer
183
views
Connect java-spanner OpenTelemetry spans to micrometer/brave parent
I have a spring-boot application and java spanner client. Spring boot is using micrometer and brave as a tracing instrumentation, while java spanner client is using OpenTelemetry.
By
following the ...
1
vote
0
answers
286
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....
0
votes
1
answer
27
views
GCP Spanner can't set DatabaseDialect while creating a database
I have Python method to create a database in GCP's Spanner which in I want to set the database dialect to PostgreSql:
from google.cloud import spanner
from google.cloud.spanner_admin_database_v1.types ...
0
votes
0
answers
62
views
Bad performances seems due to spanner thread pool
I've a simple crud service, on a kubernetes cluster talking with Spanner.
The service serves gRPC requests using grpc-api:1.61.1 ServerBuilder object.
I built it using a newFixedThreadPool.
There is ...
-1
votes
1
answer
44
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 ...
5
votes
3
answers
535
views
SELECT AS STRUCT/VALUES
I am wondering what the possible use cases are for the SELECT AS STRUCT|VALUES modifier for GoogleSQL beyond the sort of textbook examples in the documentation.
The AS STRUCT reduces a non-scalar row ...
0
votes
0
answers
35
views
How are many to many relationships in Cloud Spanner used using Spring Boot without Hibernate
The Cloud Spanner Library for Java Spring Boot states the following:
While one-to-one and many-to-many relationships can be implemented in Cloud Spanner and Spring Data Cloud Spanner using constructs ...
1
vote
1
answer
69
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 ...
0
votes
0
answers
19
views
Spanner ParseDDL doesn't like when I use SELECT STRUCT in the Subquery
I'm trying to create a Spanner View using spanner go client.
when I use spanner/spansql.ParseDDL.
SELECT
ARRAY_AGG(STRUCT(firstName, lastName, phone_number)
) AS user_info
Error: got "(&...