Google BigQuery Updated
Written by Kay Ewbank   
Wednesday, 20 March 2013

Google BigQuery has been updated with a greater range of query and data types, more flexibility with table structure, and better tools for collaborative analysis.

Google BigQuery is Google’s tool that lets you run SQL-like queries against very large datasets. It is designed to work most effectively when used for interactive analysis of very large datasets, typically using a small number of very large, append-only tables.

The new improvements start with the addition of Big Join and Big Group Aggregations. The Big Join feature lets you merge data from two large tables with a common key to produce a data set. The Big Join operator cuts out the intermediate data transformation step.

The Big Group Aggregations increases the number of distinct values that can be grouped in a result set so you can set up queries on larger subsets of data. As Michael Manoochehri, Developer Programs Engineer, Cloud Platform, points out in the Google Developers Blog:

“Popular web applications produce user activity logs that can grow by billions of rows each week. Dividing users into smaller groups is a key step for analysis. However, each group of users can number in the millions. To handle this for such large volumes, we've enabled Big Group Aggregations.”

Both Big Join and Big Group are used by adding the ‘Each’ modifier to the clause. For example:




Another change that’s minor in scope but will save developers a great deal of work is the addition of native support for the TIMESTAMP data type. This means you’ll be able to import date and time values from databases such as MySQL without losing the timezone offset information. There are new functions to convert TIMESTAMP fields into other formats, calculate time intervals, and to extract components such as the hour, day of week, and quarter.

The third area of improvement is the ability to add columns to existing BigQuery tables. Finally, the BiqQuery Web UI has been improved. You can now see direct links to individual datasets in the BigQuery Web UI. This has been added to make it easier to bookmark and share a dataset, and to quickly access a dataset. In addition, if you share a dataset with another user using the sharing control panel, BigQuery will send a notification email to the person you’ve shared it with containing a direct link to the dataset.

Once you have signed up to BigQuery, you can test the new features using BigQuery’s set of public datasets free of charge. 




More Information

BigQuery gets big new features to make data analysis even easier

Google BigQuery

Related Articles

BigQuery Now Open to All

Google BigQuery Service

Google BigQuery gets scripting and spreadsheets

Codd and his Rules


blog comments powered by Disqus


To be informed about new articles on I Programmer, subscribe to the RSS feed, follow us on Google+, Twitter, Linkedin or Facebook or sign up for our weekly newsletter.


Visual Studio Online For Free

If your team is using Visual Studio Online, which is free for up to five users, any ‘occasional’ contributors will be able to access the online project development environment without paying.

White House - Programmers Don't Have To Wear Suits

The recently formed US Digital Service is aimed at making digital interaction with the government less like going to the dentist. Part of the change that the new head brings is the relaxed attitude to [ ... ]

More News


Last Updated ( Wednesday, 20 March 2013 )

RSS feed of news items only
I Programmer News
Copyright © 2014 All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.