Fix SQL query to return 10 rows & simplify (GoogleCloudPlatform#1041)

PicardParis · Jon Wayne Parrott · commit 29ec3d8815ad · 2017-07-31T14:13:35.000-07:00
- Original query returned a single nested row (instead of 10 rows as apparently expected in section print_results)
- Standard SQL specified directly in query
- Removed parameter max_results to avoid redundancy w/ query
diff --git a/bigquery/cloud-client/simple_app.py b/bigquery/cloud-client/simple_app.py
@@ -24,21 +24,20 @@ def query_shakespeare():
     client = bigquery.Client()
     # [END create_client]
     # [START run_query]
-    query_results = client.run_sync_query("""
-        SELECT
-            APPROX_TOP_COUNT(corpus, 10) as title,
-            COUNT(*) as unique_words
-        FROM `publicdata.samples.shakespeare`;""")
-
-    # Use standard SQL syntax for queries.
     # See: https://cloud.google.com/bigquery/sql-reference/
-    query_results.use_legacy_sql = False
+    query_results = client.run_sync_query("""
+        #standardSQL
+        SELECT corpus AS title, COUNT(*) AS unique_words
+        FROM `publicdata.samples.shakespeare`
+        GROUP BY title
+        ORDER BY unique_words DESC
+        LIMIT 10""")
 
     query_results.run()
     # [END run_query]
 
     # [START print_results]
-    rows = query_results.fetch_data(max_results=10)
+    rows = query_results.fetch_data()
 
     for row in rows:
         print(row)
