Re:Introducing Cloud Spanner, a Global Database Service
by deesix on Tuesday February 14, 2017 @12:47PM
(#13645437)
Just to be clear, the JOINS were removed for the vertical sharding prior to looking at Cloud Spanner. Cloud Spanner fully supports complex JOINS of many times (e.g. INNER, OUTER)
Details - https://cloud.google.com/spanner/docs/query-syntax#join-type...
Disclaimer: I work on Cloud Spanner
Re:Introducing Cloud Spanner, a Global Database Service
by toadthewet on Wednesday February 15, 2017 @12:59AM
(#13650064)
How did you go from 10s of ms for an update for 2012 Spanner, to sub-ms update (best case) for Cloud Spanner according to Quizlet? Did TrueTime get an order of magnitude better? Or is Quizlet measuring the wrong thing?
Re:Introducing Cloud Spanner, a Global Database Service
by koolba on Tuesday February 14, 2017 @12:49PM
(#13645457)
Sorry for the confusion but I meant the DML portion.
Re:Introducing Cloud Spanner, a Global Database Service
by MichaelGG on Tuesday February 14, 2017 @01:30PM
(#13645839)
It sounded like you can only modify by primary key? Can you make a transaction that contains a query and a bunch of updates by PK ?
And yeah it makes it sound like writing an OEM adapter will be much more difficult.
Re:Introducing Cloud Spanner, a Global Database Service
by obstinate on Tuesday February 14, 2017 @02:21PM
(#13646297)
From reading the docs, the answer seems to clearly be yes, but I'm open to being corrected.
Re:Introducing Cloud Spanner, a Global Database Service
by havermeyer on Tuesday February 14, 2017 @12:33PM
(#13645306)
It has the same basis as standard SQL in BigQuery: https://cloud.google.com/bigquery/docs/reference/standard-sq...
EDIT: Found quite a bit of my answers in your linked article:
> Cloud Spanner uses a SQL dialect which matches the ANSI SQL:2011 standard with some extensions for Spanner-specific features. This is a SQL standard simpler than that used in non-distributed databases such as vanilla MySQL, but still supports the relational model (e.g. JOINs). It includes data-definition language statements like CREATE TABLE. Spanner supports 7 data types: bool, int64, float64, string, bytes, date, timestamp[20].
> Cloud Spanner doesn't, however, support data manipulation language (DML) statements. DML includes SQL queries like INSERT and UPDATE. Instead, Spanner's interface definition includes RPCs for mutating rows given their primary key[21]. This is a bit annoying. You would expect a fully-featured SQL database to include DML statements. Even if you don't use DML in your application you'll almost certainly want them for one-off queries you run in a query console.
> Though Cloud Spanner supports a smaller set of SQL than many other relational databases, its dialect is well-documented and fits our use case well. Our requirements for a MySQL replacement are that it supports secondary indices and common SQL aggregations, such as the GROUP BY clause. We've eliminated most of the joins we do, so we haven't tested Cloud Spanner's join performance.
This seems like it'd prevent any kind of easy switch over to Spanner.