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

Difficult to work with large tables #12

Open
alexey-milovidov opened this issue Sep 26, 2023 · 1 comment
Open

Difficult to work with large tables #12

alexey-milovidov opened this issue Sep 26, 2023 · 1 comment
Labels
enhancement New feature or request

Comments

@alexey-milovidov
Copy link

I defined a dataset on a table with 21 billion records.
When I tried to create my first chart, it did this:

![Screenshot_20230926_190229](https://github.com/datalens-tech/datalens/assets/18581488/d81e4044-9b75-4eff-8107-98b6f15dd4ce)

Running this query on ClickHouse:

SELECT `t1`.`created_at` AS `res_0` FROM `default`.`twitter` AS `t1` GROUP BY `res_0` LIMIT 1000001

The query will process nicely, but the aggregation is performed by every unique time point, and it requires 94.5 seconds to finish on a service in ClickHouse Cloud.

@resure resure added the enhancement New feature or request label Sep 29, 2023
@resure
Copy link
Contributor

resure commented Sep 29, 2023

Grouping can be changed in the field settings (click on the icon inside the field -> Grouping

Screenshot 2023-09-29 at 16 26 57

But current default grouping is certainly not useful, especially when no filters are specified, we'll probably switch it to day or week.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants