Skip to content

perf: Generate SQL with fewer CTEs - #877

Merged
TrevorBergeron merged 8 commits into
mainfrom
defer_reproject
Aug 6, 2024
Merged

perf: Generate SQL with fewer CTEs#877
TrevorBergeron merged 8 commits into
mainfrom
defer_reproject

Conversation

@TrevorBergeron

Copy link
Copy Markdown
Contributor

Thank you for opening a Pull Request! Before submitting your PR, there are a few things you can do to make sure it goes smoothly:

  • Make sure to open an issue as a bug/issue before writing your code! That way we can discuss the change, evaluate designs, and agree on the general idea
  • Ensure the tests and linter pass
  • Code coverage does not decrease (if any source code was changed)
  • Appropriate docs were updated (if necessary)

Fixes #<issue_number_goes_here> 🦕

@product-auto-labelproduct-auto-labelBot added size: m Pull request size is medium. api: bigquery Issues related to the googleapis/python-bigquery-dataframes API. labels Aug 1, 2024
@TrevorBergeron
TrevorBergeron marked this pull request as ready for review August 1, 2024 22:34
@TrevorBergeron
TrevorBergeron requested review from a teamAugust 1, 2024 22:34
Comment threadbigframes/core/compile/compiled.py
Comment threadbigframes/core/compile/compiled.py
Comment threadbigframes/core/compile/compiled.py
Comment threadbigframes/core/compile/compiled.py Outdated

def filter(self, predicate: ex.Expression) -> OrderedIR:
if any(map(is_window, map(self._get_ibis_column, predicate.unbound_variables))):
# ibis doesn't support qualify syntax

Copy link
Copy Markdown
Collaborator

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Might be worth an issue, too. I think there is some support in ibis for having, for example (though it's not really possible with the pandas API) if I remember correctly from my work on F1. https://ibis-project.org/tutorials/ibis-for-sql-users#having-clause

Copy link
Copy Markdown
ContributorAuthor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

created bug and referenced in comment

@TrevorBergeron
TrevorBergeron merged commit eb60804 into mainAug 6, 2024
@TrevorBergeron
TrevorBergeron deleted the defer_reproject branch August 6, 2024 22:02
@release-pleaserelease-pleaseBot mentioned this pull request Aug 6, 2024
Sign up for freeto join this conversation on GitHub. Already have an account? Sign in to comment

Labels

api: bigqueryIssues related to the googleapis/python-bigquery-dataframes API.size: mPull request size is medium.

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants

@TrevorBergeron@tswast@ivansmf