Tim Sweña (Swast)

e2e and notebook failures are for the same: ``` E google.api_core.exceptions.BadRequest: 400 'FOR SYSTEM_TIME AS OF' expression for table 'bigframes-load-testing.bigframes_testing.penguins_dcdc3525965d3bf2805a055ee80a0ae7' evaluates to a TIMESTAMP value in the future: 2025-04-29 15:16:24.477885...

Notebook failures appear to be flakes, as they are related to remote functions and succeeded in 3.10 but not 3.11. ``` nox > * notebook-3.10: success nox > * notebook-3.11:...

e2e failure might indicate a real issue `FAILED tests/system/large/operations/test_semantics.py::test_sim_join[has_score_column]` ``` > raise exceptions.from_http_response(response) E google.api_core.exceptions.BadRequest: 400 GET [https://bigquery.googleapis.com/bigquery/v2/projects/bigframes-load-testing/queries/e2e2cede-621f-47fc-9fbc-4077c0579eaf?maxResults=0&location=US&prettyPrint=false](https://www.google.com/url?q=https://bigquery.googleapis.com/bigquery/v2/projects/bigframes-load-testing/queries/e2e2cede-621f-47fc-9fbc-4077c0579eaf?maxResults%3D0%26location%3DUS%26prettyPrint%3Dfalse&sa=D): Duplicate column names in the result are not supported when a destination...

Different set of e2e failures this time: ``` FAILED tests/system/large/blob/test_function.py::test_blob_pdf_chunk[True-expected0] FAILED tests/system/large/blob/test_function.py::test_blob_image_normalize_to_series FAILED tests/system/large/blob/test_function.py::test_blob_image_blur_to_series FAILED tests/system/large/blob/test_function.py::test_blob_image_normalize_to_folder FAILED tests/system/large/blob/test_function.py::test_blob_image_blur_to_folder FAILED tests/system/large/blob/test_function.py::test_blob_image_normalize_to_bq FAILED tests/system/large/blob/test_function.py::test_blob_image_blur_to_bq FAILED tests/system/large/blob/test_function.py::test_blob_image_resize_to_series ERROR tests/system/large/blob/test_function.py::test_blob_pdf_extract[True-expected0] ``` Maybe it was...

I'll split to defer part from the pseudocolumn work into https://github.com/googleapis/python-bigquery-dataframes/pull/1689 I think the defer step can be done without out that to make this PR a lot smaller.

e2e failure: `FAILED tests/system/large/blob/test_function.py::test_blob_pdf_extract[True-expected0]` ``` > raise exceptions.from_http_response(response) E google.api_core.exceptions.BadRequest: 400 POST https://test-bigquery.sandbox.google.com/bigquery/v2/projects/bigframes-load-testing/queries?prettyPrint=false: The job encountered an internal error during execution and was unable to complete successfully. ``` Seems like...

> Since you are using setup.py, we should be able to use an env var or something similar to have an opt-in way to remove the version constraints on those...

In bigframes version 1.28.0, we included this PR https://github.com/googleapis/python-bigquery-dataframes/pull/1170 which drops ibis as a dependency by vendoring a fork of it into the bigframes package. I'd be open to a...

Oops. I merged too soon. https://github.com/googleapis/python-bigquery-dataframes/pull/1173 to fix the failing Samples tests. Since it was only remote function and llm that were failures, I (incorrectly) assumed those were flakes.

Getting ``` pytest tests/system/small/test_dataframe.py::test_dataframe_agg_int_single_string ... ../../envs/bigframes/lib/python3.11/site-packages/sqlglot/dialects/bigquery.py:53: in exp.PropertyEQ(this=exp.to_identifier(name), expression=fld) _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _...