_PARTITIONTIME is not returned in version 3.11.4 (is returned in 3.11.3) #1655

Activity

1. product-auto-label

   added

   api: bigqueryIssues related to the googleapis/python-bigquery API.Issues related to the googleapis/python-bigquery API.

   on Sep 8, 2023
2. chalmerlowe

   changed the title [-]_PARTITIONTIME is not returned in 3.11.4 Verion works till 3.11.3[/-] [+]_PARTITIONTIME is not returned in 3.11.4 Version works till 3.11.3[/+] on Sep 19, 2023
3. chalmerlowe

   changed the title [-]_PARTITIONTIME is not returned in 3.11.4 Version works till 3.11.3[/-] [+]_PARTITIONTIME is not returned in version 3.11.4 (is returned in 3.11.3)[/+] on Sep 19, 2023
4. chalmerlowe commented on Sep 21, 2023

   

   chalmerlowe

   on Sep 21, 2023

   Last edited by chalmerlowe

   Collaborator

   More actions

   @SudhirNune

   I have not been able to recreate this error locally. I will likely close this as not reproducible/won't fix.

   I ran analogous code on a partitioned table using both 3.11.3 and 3.11.4 and successfully returned results...

   Below is an example with _PARTITIONTIME results in version 3.11.4 based on the code shown below:

   Started job: d7f9a02d-531c-46ff-9418-6d5d15800032
   3.11.4
   Row((datetime.datetime(2014, 8, 2, 22, 15, tzinfo=datetime.timezone.utc), 15.25, None, datetime.datetime(2023, 9, 20, 14, 0, tzinfo=datetime.timezone.utc)), {'timestamp': 0, 'fare': 1, 'company': 2, '_PARTITIONTIME': 3})
   Row((datetime.datetime(2014, 7, 1, 23, 45, tzinfo=datetime.timezone.utc), 7.05, None, datetime.datetime(2023, 9, 20, 14, 0, tzinfo=datetime.timezone.utc)), {'timestamp': 0, 'fare': 1, 'company': 2, '_PARTITIONTIME': 3})
   Row((datetime.datetime(2014, 7, 21, 15, 0, tzinfo=datetime.timezone.utc), 8.05, None, datetime.datetime(2023, 9, 20, 14, 0, tzinfo=datetime.timezone.utc)), {'timestamp': 0, 'fare': 1, 'company': 2, '_PARTITIONTIME': 3})
   

   Code sample:

   query = """
   SELECT timestamp, fare, company, _PARTITIONTIME,
   FROM `<your_project_name_here>.taxidata.time_fare_company_part3`
   WHERE (_PARTITIONTIME > '2023-01-04 00:00:00')
   LIMIT 3
   """
   
   from google.cloud import bigquery
   from google.cloud.bigquery import version
   
   # Construct a BigQuery client object.
   project = '<your_project_name_here>'
   
   client = bigquery.Client()
   
   query_job = client.query(
       query=query,
       location="US",
       project=project,
   )
   
   print("Started job: {}".format(query_job.job_id))
   print(version.__version__) # show python version being used.
   for result in query_job.result():
       print(result)
   
5. chalmerlowe

   added

   priority: p3Desirable enhancement or fix. May not be included in next release.Desirable enhancement or fix. May not be included in next release.

   status: awaiting information

   on Sep 21, 2023
6. chalmerlowe commented on Sep 21, 2023

   

   chalmerlowe

   on Sep 21, 2023

   Collaborator

   More actions

   NOTE: this linked issue also discusses dropping _PARTITIONTIME, but does not appear to have any relationship to package version, the way this issue does.
7. chalmerlowe

   added

   status: will not fixInvalid (untrue/unsound/erroneous), inconsistent with product, not on roadmap.Invalid (untrue/unsound/erroneous), inconsistent with product, not on roadmap.

   on Sep 28, 2023
8. chalmerlowe commented on Sep 28, 2023

   

   chalmerlowe

   on Sep 28, 2023

   Collaborator

   More actions

   Closing as not reproducible.
9. chalmerlowe

   closed this as completedon Sep 28, 2023