Feeds

Google makes BigQuery easier to question

SQL commands let devs probe BigQuery AaaS

Next gen security for virtualised datacentres

Google has updated its BigQuery cloud analytic service to make it attractive to people familiar with SQL.

The new features for the analytics-as-a-service (AaaS) – Big JOIN, Big Group Aggregations, and support for the TIMESTAMP data type – were released by Google on Thursday.

They are designed to cut the steps developers need to take in analysing large amounts of data, and make the technology easier to deal with.

"In response to developer feedback, we're launching new features that enable analysts and developers to run fast SQL-like join and aggregate queries on datasets without the need for batch-based processing," Michael Manoochehri a developer programs engineer for the Google cloud platform, wrote.

Google, like many other tech pioneers, has spent the past half-decade bingeing on NoSQL systems, but like any reformed glutton has realized that this may not have been wise.

The BigQuery update can be considered another way the Chocolate Factory is paying penance for its binge, alongside its move back to SQL-like systems on its internal platform with the introduction of Spanner and F1.

Previously, BigQuery made developers run analytics atop a single (very large) table. But as many people keep their data in all sorts of different tables this made porting stuff into BigQuery painful.

Google has now done away with this, and the analytics service lets developers use standard JOIN functions to link multiple tables of data together.

"Big JOIN simplifies data analysis that would otherwise require a data transformation step, by allowing users to specify JOIN operations using SQL," Manoochehri wrote.

Google has also launched Big Group Aggregations, which lets you put a larger number of distinct values into a result set. In a further bout of SQL-slathering, timestamp data can now be imported as well, he wrote.

Google launched BigQuery in a beta in 2011, and the AaaS became available for general prodding in May 2012. It can support queries across hundreds of terabytes, but so far Google has not provided developers with a feasible way to actually get that much data into its cloud.

The updates all go to make BigQuery more attractive to developers – a key consideration for Google as it tries to generate enthusiasm for its cloud platform while fighting rivals Amazon and Microsoft on price on multiple fronts. ®

The essential guide to IT transformation

More from The Register

next story
The Return of BSOD: Does ANYONE trust Microsoft patches?
Sysadmins, you're either fighting fires or seen as incompetents now
Microsoft: Azure isn't ready for biz-critical apps … yet
Microsoft will move its own IT to the cloud to avoid $200m server bill
Oracle reveals 32-core, 10 BEEELLION-transistor SPARC M7
New chip scales to 1024 cores, 8192 threads 64 TB RAM, at speeds over 3.6GHz
US regulators OK sale of IBM's x86 server biz to Lenovo
Now all that remains is for gov't offices to ban the boxes
Object storage bods Exablox: RAID is dead, baby. RAID is dead
Bring your own disks to its object appliances
Nimble's latest mutants GORGE themselves on unlucky forerunners
Crossing Sandy Bridges without stopping for breath
prev story

Whitepapers

Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
7 Elements of Radically Simple OS Migration
Avoid the typical headaches of OS migration during your next project by learning about 7 elements of radically simple OS migration.
BYOD's dark side: Data protection
An endpoint data protection solution that adds value to the user and the organization so it can protect itself from data loss as well as leverage corporate data.
Consolidation: The Foundation for IT Business Transformation
In this whitepaper learn how effective consolidation of IT and business resources can enable multiple, meaningful business benefits.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?