search

runt18 / google-bigquery

Automatically exported from code.google.com/p/google-bigquery
0 stars 0 forks source link

Support boolean operations in queries #393

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
BigQuery supports table unions but no UNION, INTERSECT and EXCEPT keywords like 
in SQL. This would practical however. I have several use cases for such 
keywords and currently need to apply work arounds using expensive join each 
operations.

Example use case: analyse in our views event logging whether a user visiting 
one sale also visited another or was unique to either one of the sales.

Original issue reported on code.google.com by wouter.c...@vente-exclusive.com on 15 Dec 2015 at 5:04

GoogleCodeExporter commented 8 years ago 
We have some SQL improvements coming soon, but INTERSECT and EXCEPT may still 
be a little ways out.

However, note that supporting these SQL keywords will improve the syntax but 
probably not the performance of the query. They'd probably end up being 
implemented by something like JOIN EACH under the hood.

Original comment by jcon...@google.com on 15 Dec 2015 at 6:08