BigQuery Updated and Repriced
Written by Kay Ewbank   
Monday, 17 June 2013

Google BigQuery has been updated. The service for analyzing large amounts of data now can handle larger result sets, and has functions for advanced analytics, and caching of large query results. At the same time lower prices have been announced.

 

 

Writing on the Official Google Enterprise Blog, Ju-kay Kwek, BigQuery Product Manager says:

“Today we’re announcing another update to BigQuery packed with new capabilities.

Large results: run queries that return arbitrarily large numbers of rows and save them as a new table for follow-up analysis.

Window functions: take advantage of built-in functions like Rank and Partition to create sophisticated statistical analyses with far simpler SQL than before.

Query caching: now recent queries that are re-run return a cached result when the underlying table is unchanged, providing more cost-effective analysis.”

Until the changes, output from queries was limited to 128MB of compressed data per query. The ability to save the output as tables removes that restriction. The new facility is used simply by enabling a new --allow_large_results flag when issuing a query job, then specifying a destination table.

The new functions extend the existing support for standard functions such as quantiles, variance and standard deviation with analytical functions for ranking, percentiles, and relative row navigation. You can see examples of using the new functions on the Google Developers blog.

Query caching has also been added so that BigQuery now remembers values that you've previously computed, saving you time and the cost of recalculating the query. Query results are kept cached for 24 hours, on a best effort basis, though you can disable query caching. The UI has also been improved with features to show any problems with your query syntax, along with an estimate of how much the query would cost to run. You can also now abandon a running query to start a different one.

New pricing options, coming into effect on July 1st are intended to make BigQuery more affordable. The on-demand rate for interactive queries is being reduced from $0.12/GB/month to $0.08/GB/month and customers with higher-volume usage will in future be able to opt in for tiered query pricing.

 

 

More Information

Google BigQuery gets smarter

Google BigQuery new features

Google BigQuery

Related Articles

Google BigQuery Updated

BigQuery Now Open to All

Google BigQuery Service

 


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

 

blog comments powered by Disqus

 

Banner


Chrome 64-Bit For Windows In Beta
05/08/2014

If you are running Windows 7 or later on a 64-bit machine you might be looking froward to having a 64-bit version of Chrome. It is now in the beta channel and you are invited to try out its features a [ ... ]



Google's Blink Not Implementing W3C Pointer Events
18/08/2014

Since it split away from the WebKit render engine to create Blink, Google has been free to pick and choose what gets implemented. Now we have the news that it has decided to ignore the W3C spec for to [ ... ]


More News

 


Last Updated ( Monday, 17 June 2013 )
 
 

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