Mon . 19 Apr 2019

BigQuery

bigquery google, bigquery
BigQuery is a RESTful web service that enables interactive analysis of massively large datasets working in conjunction with Google Storage It is an Infrastructure as a Service IaaS that may be used complementarily with MapReduce

Contents

  • 1 History
  • 2 Design
  • 3 Features
  • 4 References
  • 5 External links

History

After a limited testing period in 2010, BigQuery was generally available in November 2011 at the Google Atmosphere conference In 2014, MapR introduced the Apache Drill project, which was meant to solve similar problems In April, 2016, European users of the service suffered a 12-hour outage In May, 2016, support was announced for Google Sheets

Design

BigQuery provides an external access to the Dremel technology, a scalable, interactive ad hoc query system for analysis of read-only nested data To use the data in BigQuery, it first must be uploaded to Google Storage and in a second step imported using the BigQuery HTTP API BigQuery requires all requests to be authenticated, supporting a number of Google-proprietary mechanisms as well as OAuth

Features

  • Managing data - create and delete tables based on a JSON-encoded schema, import data encoded as CSV or JSON from Google Storage
  • Query - the queries are expressed in a SQL dialect and the results are returned in JSON with a maximum reply length of approximately 64 MB There are some limitations to the usual SQL queries For example, BigQuery supports joins, but one of the two JOINed tables must be small enough or use the JOIN EACH keyword instead
  • Integration - BigQuery can be used from Google Apps Script, Google Spreadsheets, or any language that can work with its REST API
  • Access control - is possible to share datasets with arbitrary individuals, groups, or the world

References

  1. ^ Iain Thomson November 14, 2011 "Google opens BigQuery for cloud analytics: Dangles free trial to lure doubters" Retrieved August 26, 2016 
  2. ^ Neil McAllister September 16, 2014 "Is your data boring MapR wants you to bore it back with Apache Drill: New release adds support for Google-y SQL-on-Hadoop tech" Retrieved August 26, 2016 
  3. ^ Simon Sharwood April 7, 2016 "Google Euro-cloud glitch" Retrieved August 26, 2016 
  4. ^ Jordan Novet May 6, 2016 "Google BigQuery now lets you analyze data from Google Sheets" Retrieved August 26, 2016 
  5. ^ Sergey Melnik; Andrey Gubarev; Jing Jing Long; Geoffrey Romer; Shiva Shivakumar; Matt Tolton; Theo Vassilakis 2010 "Dremel: Interactive Analysis of Web-Scale Datasets" Proc of the 36th International Conference on Very Large Data Bases VLDB 
  6. ^ Kazunori Sato 2012 "An Inside Look at Google BigQuery" PDF Google Retrieved August 26, 2016 
  7. ^ "Google BigQuery API Overview V2" Retrieved 1 July 2012 

External links

  • Official website
  • Intro to new Google cloud technologies: Google Storage, Prediction API, BigQuery slideshare presentation by Chris Schalk Developer Advocate at Google
  • BigQuery, meet Google Spreadsheets
  • R client library for communicating with Google BigQuery
  • Reddit's r/bigquery for news and discussion
  • bigqueries for sharing queries and datasets

bigquery, bigquery console, bigquery data studio, bigquery date functions, bigquery documentation, bigquery google, bigquery pricing, bigquery standard sql, bigquery tutorial, bigquery vs redshift


BigQuery Information about

BigQuery


  • user icon

    BigQuery beatiful post thanks!

    29.10.2014


BigQuery
BigQuery
BigQuery viewing the topic.
BigQuery what, BigQuery who, BigQuery explanation

There are excerpts from wikipedia on this article and video

Random Posts

B♭ (musical note)

B♭ (musical note)

B♭ B-flat; also called si bémol is the eleventh step of the Western chromatic scale starting from C ...
Fourth dimension in art

Fourth dimension in art

New possibilities opened up by the concept of four-dimensional space and difficulties involved in tr...
Holt Renfrew

Holt Renfrew

Holt, Renfrew & Co, Limited, commonly known as Holt Renfrew or Holt's,1 is a chain of high-end C...
Later Silla

Later Silla

Later Silla 668–935, Hangul: 후신라; Hanja: 後新羅; RR: Hushila, Korean pronunciation: ...