December 2017
Beginner to intermediate
264 pages
5h 38m
English
Content preview from Learning Google BigQuery
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Types of queries
Google offers two different types of queries. Interactive queries are BigQuery's most costly queries and will run as soon as possible when initiated. Users using Google's on-demand pricing will be subject to Google's concurrent query limits. These users can run 50 concurrent interactive queries and users can run 6 concurrent queries containing user-defined functions. Batch queries are less costly and do not count against concurrent query limits. These queries are run when resources are available; therefore, these queries might not run as soon as possible when initiated. If a query does not run within 24 hours, its priority is set to interactive.
User-defined functions can be developed in both JavaScript and SQL. They are ...