Default dataset feature does not work with google-cloud-bigquery 1.22.0 #43

Activity

1. tswast

   added

   priority: p2Moderately-important priority. Fix may not be included in next release.Moderately-important priority. Fix may not be included in next release.

   type: bugError or flaw in code with unintended results or allowing sub-optimal usage patterns.Error or flaw in code with unintended results or allowing sub-optimal usage patterns.

   on Nov 26, 2019
2. tswast commented on Nov 26, 2019

   

   tswast

   on Nov 26, 2019

   Contributor

   More actions

   I thought this might be a regression in google-cloud-bigquery, but I'm unable to reproduce with either the query() method or the DB-API.

   from google.cloud import bigquery
   
   
   print(bigquery.__version__)
   
   default_config = bigquery.QueryJobConfig(
       default_dataset="bigquery-public-data.usa_names"
   )
   
   client = bigquery.Client(default_query_job_config=default_config)
   
   
   sql = """
   SELECT name, SUM(number) as total_people
   FROM usa_1910_2013
   WHERE state = 'TX'
   GROUP BY name, state
   ORDER BY total_people DESC
   LIMIT 5
   """
   
   rows = client.query(sql, job_config=bigquery.QueryJobConfig(use_legacy_sql=False))
   
   print("with query():")
   for row in rows:
       print(row["name"])
   
   
   from google.cloud.bigquery import dbapi
   
   connection = dbapi.connect(client=client)
   cursor = connection.cursor()
   
   print("with dbapi:")
   cursor.execute(sql)
   rows = cursor.fetchall()
   
   for row in rows:
       print(row[0])

   Output:

   1.22.0
   with query():
   James
   John
   Michael
   Robert
   David
   with dbapi:
   James
   John
   Michael
   Robert
   David
   
3. alonme commented on Nov 26, 2019

   

   alonme

   on Nov 26, 2019

   ContributorAuthor

   More actions

   Please assign to me, started working on resolving the issue.
4. tswast

   assigned

   alonme

   on Nov 26, 2019
5. winstonll commented on Nov 30, 2019

   

   winstonll

   on Nov 30, 2019

   More actions

   Please assign to me, started working on resolving the issue.

   Thanks, I am having similar issues too. Look forward to your solution.
6. alonme commented on Dec 3, 2019

   

   alonme

   on Dec 3, 2019

   Last edited by alonme

   ContributorAuthor

   More actions

   Opened a PR
   #44
7. mxmzdlv

   closed this as completedon Dec 11, 2019