cube-js / cube-js/cube

Unwanted 'ORDER BY' Clauses in Cube.js-Trino Queries

Open
#7,813 2 comments 0 reactions 0 assignees View on GitHub
driver:trino question
Dominant language
Rust
Stars
20.8k
Forks
2.1k
Avg merge
1d 2h
Merged PRs (30d)
181

Description

I'm integrating Cube.js with Trino and encountering performance issues due to the way Cube.js handles queries. Specifically, Cube.js appends an "ORDER BY" clause to all queries directed to Trino. This becomes a bottleneck because, even with a LIMIT clause (e.g., LIMIT 10), Trino performs a full dataset scan when an "ORDER BY" is present, leading to significant slowdowns when dealing with large tables. I connect to Cube.js using psql. Is there an approach to either disable the automatic "ORDER BY" addition or to optimize query performance under these conditions?"

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.