Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

#34887 [TRINO] Enable SQL based row limits for trino #34888

Merged
merged 2 commits into from
Sep 16, 2024

Conversation

schaffino
Copy link
Contributor

@schaffino schaffino commented Jul 18, 2024

When trino is configured with fault tolerant execution, queries are run to completion before results are returned. This means previewing a table in dbeaver ends up scanning the whole table and taking a lot of time, and potentially a huge amount of resources if its a very large table. Trino supports SQL limit statement, so enable SQL based row limiting in the plugin and make it the default for connections.

Fixes #34887

@schaffino schaffino marked this pull request as ready for review July 18, 2024 10:00
@E1izabeth
Copy link
Member

Thank you for contribution

* When trino is configured with fault tolerant execution, queries
  are run to completion before results are returned
* This means previewing a table in dbeaver ends up scanning the whole
  table and taking up potentially a huge amount of resources
* Trino supports SQL limit statement, so enable SQL based row limiting
  in the plugin and make it the default
@schaffino schaffino force-pushed the trino/enable-sql-base-row-limit branch from 395e1c6 to f4082b1 Compare July 26, 2024 15:20
@E1izabeth E1izabeth removed the request for review from serjiokov July 29, 2024 10:16
@E1izabeth
Copy link
Member

We passed your PR to our QA team for testing

@schaffino
Copy link
Contributor Author

@E1izabeth Any update on this PR?

@E1izabeth
Copy link
Member

This PR is awaiting in a queue for testing.

@uslss
Copy link
Member

uslss commented Sep 16, 2024

verified

@serge-rider serge-rider merged commit d8f5f97 into dbeaver:devel Sep 16, 2024
2 checks passed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

Successfully merging this pull request may close these issues.

Data preview forces full table Scan in Trino
5 participants