Feeds

Google makes BigQuery easier to question

SQL commands let devs probe BigQuery AaaS

The Essential Guide to IT Transformation

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
Sysadmin Day 2014: Quick, there's still time to get the beers in
He walked over the broken glass, killed the thugs... and er... reconnected the cables*
VMware builds product executables on 50 Mac Minis
And goes to the Genius Bar for support
Auntie remains MYSTIFIED by that weekend BBC iPlayer and website outage
Still doing 'forensics' on the caching layer – Beeb digi wonk
Multipath TCP speeds up the internet so much that security breaks
Black Hat research says proposed protocol will bork network probes, flummox firewalls
Microsoft says 'weird things' can happen during Windows Server 2003 migrations
Fix coming for bug that makes Kerberos croak when you run two domain controllers
Cisco says network virtualisation won't pay off everywhere
Another sign of strain in the Borg/VMware relationship?
Forrester says Australia, not China, is next boom market for cloud
It's cloudy but fine down under, analyst says
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.
Boost IT visibility and business value
How building a great service catalog relieves pressure points and demonstrates the value of IT service management.
Why and how to choose the right cloud vendor
The benefits of cloud-based storage in your processes. Eliminate onsite, disk-based backup and archiving in favor of cloud-based data protection.
The Essential Guide to IT Transformation
ServiceNow discusses three IT transformations that can help CIO's automate IT services to transform IT and the enterprise.
Maximize storage efficiency across the enterprise
The HP StoreOnce backup solution offers highly flexible, centrally managed, and highly efficient data protection for any enterprise.