google-cloud-spanner's questions - Polish 1answer

0 google-cloud-spanner questions.

I want to write multibyte string (e.g. japanese) to Spanner from Dataflow Pipeline. But it does now working. Below is the code I tried. // The object type is because I want to convert BigQuery ...

I want to extract a huge table from spanner and instead of the regular execute_sql function, I wish to stream data. But I don't see a lot of documentation around it. I am using google cloud python ...

I have turned on both the DATA_READ, DATA_WRITE logtypes but I am not able to see any SQL queries. I have reviewed both the activity page and log views from within the GCP console. Below are the ...

Is cloud spanner the only solution for horizontal scaling of mysql instances on the google cloud? Is there a way to scale in cloud sql?

Using Spring Boot with Spanner in the Google Cloud Env. we are now struggling with performance issues. To demonstrate that I set up a small demo case baselining our different approaches how to ...

I'm executing a query: "SELECT e.name,d.name FROM emp as e, department as d WHERE e.dept = d.dept;" in Spanner which works totally fine on the Spanner console. But when I try to fire the same query ...

External Backups/Snapshots for Google Cloud Spanner recommends to use queries with timestamp bounds to create snapshots for export. On the bottom of the Timestamp Bounds documentation it states: ...

I'm trying to write to spanner some messages from google pub/sub. Writing to bigtable works, so nothing is missing at the fundamental level. I've upgraded to google-cloud-dataflow-java-sdk-all v2.3.0,...

Can I use the Google Cloud Spanner Console to perform a read operation with SQL using a timestamp bound? This seems to be possible using the SDKs, but I have not found a way to do this using SQL ...

Is there any way to do local development with cloud spanner? I've taken a look through the docs and the CLI tool and there doesn't seem to be anything there. Alternatively, can someone suggest a SQL ...

Is there a way to setup a Development env for Google Cloud Spanner? Is this this "How to run Cloud Spanner in a Container" for dev? Or is the only solution to run a cloud spanner for dev a single ...

My organisation is working on the app that is being deployed to GCP and as the system of record was chosen to use Google Spanner. Is there a way to test my DAOs without actually connecting to the GCP ...

Is it possible to launch in memory db like h2 or embedded cassandraunit. I want to setup embedded spanner db without the needs of google credentials json which connects to a remote spanner db. Is it ...

From the spanner paper, it says that "To support replication, each spanserver implements a single Paxos state machine on top of each tablet. (An early Spanner incarnation supported multiple Paxos ...

Are there any performance considerations or best practices to bear in mind on free text search in Google Spanner? Could I create an INTERLEAVE Inverted Index? (I think not; but maybe I missed the doc?...

I created a cluster and ran benchmarks on it (simple key-value get and set). The median latency numbers were consistently < 100ms. I don't believe I've changed anything, but now all simple gets ...

We are prototyping setting up separate databases for each developer on the same instance of a GCP Spanner 1 node instance and have noticed that tables take ~20 seconds to create and indexes take 60 to ...

Dear Cloud Spanner Support Is there any option for TTL(Time to Live) on Google Cloud Spanner table . If yes Please provide any additional information Thank you Sreeni

The documentation states that one split should not be bigger then 'a few GB'. Is there a hard limit on that where Cloud Spanner will stop storing more data in one split ? Nothing can be found in the ...

I am trying to write a 79G file into a single table in Google spanner. The table has 1 string key column, and 13 string columns and 4 string array columns. I am using this example from Google cloud ...

I'm new to golang and spanner, I want to save a snapshot of our spanner DB to Google cloud storage in every 5 mins. The format that I want to use is Parquet or JSON. stmt = spanner.NewStatement("...

We are currently using NodeJs with Knex for connecting with MySQL. We have plans to migrate our database to Cloud Spanner. So wanted to know, if knexjs has support for cloud spanner. I did not see any ...

I am looking through the documentation for Google Cloud Spanner, and it looks like write operations return a timestamp when the row was actually written. But when reading rows, it doesn't seem ...

my goal is to delete recrods in batch where I have a conditional query: while(select * from <table_name> where <condition_1> limit 1;) exists, delete from <table_name> where <...

I am unable to create indexes on Cloud Spanner tables, receiving the error, "Spanner operation failed". Even after increasing the cluster size to from 6 to 16 nodes, I am unable to create two indexes ...

I would like to delete one row or all rows from a spanner table. The primary key of the table is an int64. I do not want to drop the table and recreate it. I am using the google supplied Java ...

I have a dataflow job that writes to Spanner. One of my columns is of type ARRAY which is also nullable. When I try to write a null value for this column from my Dataflow job, I get the following ...

I'd like to run a daily job that does some aggregations based on a BigQuery setup. The output is a single table that I write back to BigQuery that is ~80GB over ~900M rows. I'd like to make this ...

How to join left next row in Cloud Spanner. I want to calculate how many kilometers driven each driver. My table looks like: vehicle_id | driver_id | odometer 1 | 1 | 10 ...

In Spanner: Google’s Globally-Distributed Database, section 2.1, we read: To support replication, each spanserver implements a single Paxos state machine on top of each tablet. (An early Spanner ...

Need your help! I am trying to perform DML operation using a driver class(com.simba.cloudspanner.core.jdbc42.CloudSpanner42Driver), but I am getting exception like "Caused by: shaded.com.google....

In the pipeline, I'm reading from Pub/Sub and I'm attempting to write to spanner. Writing to BigTable works, but spanner is a better option for my needs. In the image below I've expanded the relevant ...

I tried to import a mysqldump generated .sql file but Google spanner didn't accept the syntax, which makes sense. With that, we're trying to migrate our data, which is in a MySQL data, into Google ...

I have a need to demonstrate what happens when a failed replica or node occurs. I know Spanner is a managed service and we trust its availability, but how can I simulate a failed a failed node or ...

I am trying to build a cursor based pagination API on top of a spanner dataset. To do this I'm am using the read timestamp from the initial request to retrieve data and then encoding this into a ...

We are running a small part of our production data in Google Cloud Spanner since 8months for testing and learning things about Cloud Spanner. Rough characteristics: 1 table, 4 billion rows, around ...

I am migrating an app from Oracle to Google Spanner. One of the cases we came across are relationships between rows in the same table. These relationships have a tree-like structure, always having ...

I'm trying to define, using the interleaving approach of Google Spanner, a mechanism to have rows from several tables in the same split. According to the documentation (https://cloud.google.com/...

I have looked up for this issue but could not find any sufficient information about it. Google Cloud Spanner client libraries handles sessions automatically and its limit is 10.000 sessions for each ...

This question is a follow-up to this one. I am trying to use apache beam to read data from a google spanner table (and then do some data processing). I wrote the following minimum example using the ...

I am trying to use Apache Beam to create a Dataflow pipeline and I am not able to follow the documentation and cannot find any examples. The pipeline is simple. Create a pipeline Read from a pub/sub ...

Our main goal is read performance as we typically do 80-90% reads to writes and I am trying to select the best primary key to achieve this goal. The majority of our queries are based on customers e.g....

Since spanner does not have ddl feature like insert into dest as (select * from source_table) How do we select subset of a table and copy that rows into another table ? I am trying to write data ...

Does the Spanner API support DML statements? For example, is the following supported: UPDATE SET foo="bar" WHERE foo="baz"

I'm using java spanner read api. In the read call is the table has billions of data then spanner ResultSet.next() does pagination internally? How it will return billions of rows?

I am trying to get metrics using Stackdriver API, using a service account. The account has "Owner" rights on the project. I am getting the below error for all the Stackdriver API calls. Other APIs ...

is there any consideration using spanner with sequelize? sequelize currently works with mariadb(mysql), postgresql, and a couple others. and we just learned that sequelize now works with ...

I started looking at Google's Cloud Spanner and it certainly looks interesting. Since ruby has rails, MongoDB has Meteor, and RethinkDB has Horizon, is there any talk about Cloud Spanner having some ...

I'm writing a driver for EF Core for Spanner - In basic level it works and I can write Read and Write Queries that get's translated to Spanner SQL , executed and return results etc.. Now I'm trying ...

It stopped working my account at the present moment. Since there is no fault status, write it here. Do you replicate with other accounts? Because different ones of different regions also occur ...

Related tags

Hot questions

Language

Popular Tags