Google has recently announced on
the company blog updates to its BigQuery service that uses SQL to analyze big data in the cloud. Among the new capabilities are:
- Big JOIN: use SQL-like queries to join very large datasets at interactive speeds
- Big Group Aggregations: perform groupings on large numbers of distinct values
- Timestamp: native support for importing and querying Timestamp data
According to
Google's blog, BigQuery is used within the company itself to reconcile app billing and usage information: Big JOIN allowed them to merge 2TB of usage data with 10GB of configuration data in 60 seconds. Furthermore, Google states that "Joining terabyte-sized tables has traditionally been a challenging task
for data analysts, requiring sophisticated MapReduce development skills,
powerful hardware, or a lot of time--often all three." With these new updates, BigQuery enables companies to integrate queries
and other third party applications to large data sets easier and faster than ever before. BigQuery's developer white papers can be found
here.
No comments:
Post a Comment