Google BigQuery AnalyticsJohn Wiley & Sons, 2014/06/09 - 528 ページ How to effectively use BigQuery, avoid common mistakes, and execute sophisticated queries against large datasets Google BigQuery Analytics is the perfect guide for business and data analysts who want the latest tips on running complex queries and writing code to communicate with the BigQuery API. The book uses real-world examples to demonstrate current best practices and techniques, and also explains and demonstrates streaming ingestion, transformation via Hadoop in Google Compute engine, AppEngine datastore integration, and using GViz with Tableau to generate charts of query results. In addition to the mechanics of BigQuery, the book also covers the architecture of the underlying Dremel query engine, providing a thorough understanding that leads to better query results.
|
目次
| 1 | |
| 45 | |
Using the CommandLine Client | 57 |
Setting Up Google Cloud Storage | 64 |
Schemas | 75 |
BigQuery Billing and Quotas | 85 |
Summary | 91 |
Basic BigQuery | 93 |
Advanced BigQuery | 273 |
Cloud Processing | 275 |
Problem Statement | 305 |
Why Do You Need New Ways to Process Big Data? | 349 |
BigQuery Applications | 381 |
How Can You Read a Terabyte in a Second? | 383 |
Summary | 433 |
How Can You Ask Questions of Your Big Data and Quickly | 435 |
Big Data Stack 2 0 and Beyond | 95 |
Loading Data | 159 |
Open Source Stack | 195 |
Google Cloud Platform | 237 |
Chapter 2 | 469 |
Querying Google Data Sources | 479 |
Index | 495 |
他の版 - すべて表示
多く使われている語句
access token AppEngine application B-Tree backup Big Data BigQuery API BigQuery queries BigQuery table bigquery-e2e Bigtable bytes cache Chapter clause client columns command compute configuration contains count create dashboard data frame dataset datasetId Datastore default described destination table disk Dremel enables encryption error errorResult example format function Google APIs Google Cloud Storage Google Spreadsheets GROUP Hadoop import installed integer JDBC job ID Jobs.query JOIN JSON limit load job logs MapReduce mixer multiple OAuth2 ODBC operation options partition perform projectId publicdata:samples.shakespeare python auth.py query job query results record relational database repeated fields request rows run a query run queries sample schema SELECT server service account Shakespeare shards Simba specify stored string subquery SUM(IF corpus TableData.list tfidf timestamp update upload values window functions word write ZIP code