google-cloud-spanner Questions
3
Solved
Does the spanner supports renaming of columns and tables? That would be helpful while managing schema changes along with creating a new table from an existing one in a single statement.
Frankpledge asked 2/6, 2017 at 0:17
5
I follow this great blog. In this blog, the author has drawn a complete picture of all types of isolation and consistency and the relationship between them.
But based on the Google's blog, there ...
Gunner asked 23/2, 2020 at 17:51
3
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 ...
Verniavernice asked 8/9, 2017 at 14:13
2
Solved
Having the capability to compute a UTC timestamp as the default value for a column is a handy feature of most popular database solutions. Does Google Cloud Spanner support this? If not, is this a p...
Tandem asked 7/3, 2017 at 19:20
4
Solved
I am novice in GCP stack so I am so confused about several listed technologies for storing data:
https://cloud.google.com/products/databases
Specifically, I'm interested in the differences between ...
Arlie asked 26/2, 2020 at 11:16
2
Solved
I've a table of 860M rows in Google Cloud Spanner and I'm trying to understand how explanation works.
The table has a string column geoid and there is an index at this column.
When I run the foll...
Lienlienhard asked 21/10, 2019 at 22:36
4
Solved
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 SQ...
Begrudge asked 17/2, 2017 at 5:14
4
Solved
Is it possible to snapshot a Google Cloud Spanner Database/table(s)? For compliance reasons we have to have daily snapshots of the current database that can be rolled back to in the event of a disa...
Winterize asked 28/2, 2017 at 21:42
2
Solved
There seems to be an increasing overlapping and proliferation of cloud database technologies.
In order to make sense of it a comparative approach might help.
What are the exact differences betwee...
Exclamation asked 13/2, 2019 at 10:1
2
Solved
I want to use JPA for micronaut. For that I am using io.micronaut.data:micronaut-data-hibernate-jpa:1.0.0.M1 library. Whenever I run my application and hit the endpoint to get the data, I get the f...
Buchmanism asked 9/9, 2019 at 6:32
3
Solved
Is there any reason why someone would use Bigtable instead of BigQuery? Both seem to support Read and Write operations with the latter offering also advanced 'Query' operations.
I need to dev...
Furlani asked 7/10, 2016 at 14:35
2
Solved
I am trying to read a table from a Google spanner database, and write it to a text file to do a backup, using google dataflow with the python sdk.
I have written the following script:
from __fut...
Composer asked 4/10, 2017 at 12:19
2
The Cloud Spanner docs say that Spanner can export/import Avro format. Can this path also be used for batch ingestion of Avro data generated from another source? The docs seem to suggest it can onl...
Grimsley asked 14/8, 2018 at 14:45
2
Solved
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?
Runty asked 19/7, 2017 at 22:58
2
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...
Swedenborgianism asked 11/10, 2017 at 9:1
1
Solved
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...
Squat asked 10/2, 2018 at 1:13
1
Solved
Is there a performance penalty (or improvement) for using STRING(MAX) instead of some fixed limit like STRING(256)?
Iridectomy asked 30/8, 2017 at 15:56
1
Solved
I have the following query optimization problem in Spanner, and hoping there's a trick I'm missing that will help me bend the query planner to my will.
Here's the simplified schema:
create table ...
Sole asked 8/6, 2017 at 19:22
2
After reading the pricing of the new google relational database Spanner, it states that the cost is based on storage and use. They charge $0.9 by hour per node.
The question is: if I create the dat...
Mince asked 16/3, 2017 at 18:35
1
Solved
Is it possible to issue something like
RENAME COLUMN col1 col2
in Google Cloud Spanner? It looks from the DDL that this isn't possible; if not, is this a design choice or a limitation whilst in ...
Womanlike asked 28/2, 2017 at 10:54
1
Solved
It's not clear how to run a query (or conduct an API call) to list all tables. Is this possible with Spanner?
Latrell asked 21/2, 2017 at 5:30
1
Solved
There are two different APIs provided by Cloud Spanner. What’s the difference between Cloud Spanner read vs Cloud Spanner SQL API?
Comptroller asked 17/2, 2017 at 16:45
1
Solved
Does Google Cloud Spanner support stored procedures?
I've had a quick search through the docs at https://cloud.google.com/spanner/docs/overview but couldn't find any reference to stored procs / u...
Mazman asked 16/2, 2017 at 15:30
1
Solved
I tried to read the document multiple times but failed to understand it. Can someone explain it in layman's terms?
Neoteny asked 27/10, 2016 at 0:3
1
Solved
I'm not sure why the press in general says that Google's TrueTime API is hard to replicate (Wired, Slashdot, etc).
I can understand how it would be a tough thing to get the low error intervals tha...
Guillermoguilloche asked 22/8, 2013 at 15:32
1 Next >
© 2022 - 2024 — McMap. All rights reserved.