CODEWITHSUNDEEP
google-bigquerygoogle-cloud-platformgoogle-cloud-spanner
tensor
tensor

Reputation: 3340

Limitation of SQL in BigQuery vs Cloud Spanner

While comparing Cloud Spanner vs BigQuery, Am trying to figure what kind of limitations there are in BigQuery's in SQL, compared to ANSI SQL (select part only) ?

Does BigQuery support all complex joins of ANSI SQL ?

Additionally, is there anything that Cloud Spanner can do and BigQuery cannot?

Upvotes: 1

Views: 4071

Answers (1)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 172993

BigQuery Standard SQL is compliant with the SQL 2011 standard and has extensions that support querying nested and repeated data.
You can see about SELECT and JOINS and other details of the BigQuery Standard SQL in Query Syntax documentation

Additionnally, is there anything than Spanner can do and BigQuery cannot ?

Main difference between BigQuery and Spanner:

BigQuery - Large scale data warehouse service with append-only tables  
Spanner  - A horizontally scalable, globally consistent, relational database service

Foreign Keys, Transaction support, Indexes - are good examples of what is supported in Spanner but not in BigQuery
Note: above not supported features are by design and reflect respective purpose of those two products. What is "a must" feature for one is even conceptually not in another. Comparing BigQuery and Spanner is close to comparing Hadoop and mySQL for example if this will make it easier for you to imagine.

I think it would be great if you read respective documentations and then ask specific questions

cloud.google.com/­bigquery/­docs
cloud.google.com/­spanner/­docs

Upvotes: 5

Related Questions