Dashboard always display truncated data
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-06-2024 01:49 AM
Hello,
we're working with a serverless SQL cluster to query Delta tables and display some analytics in dashboards.
We have some basic group by queries that generate around 36k lines, and they are executed without the "limit" key word. So in the data tab we can see all the results, yet when we switch to the graphics/dashboard tab "truncated data" is written under every graphic.
We didn't find any button to display the full data.
The cluster is a 2xs but it did display everything a couple of weeks ago which is weird, I don't know if there was a DBX update or something I'm missing. How can we force display everything even if the cluster has to crash? we will consider upscaling if that's the issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-06-2024 04:43 AM
Hey @RabahO
This is likely a memory issue.
The current behavior is that Databricks will only attempt to display the first 64000 rows of data. If the first 64000 rows of data are larger than 2187 MB, then it will fail to display anything. In your case, you still get 10k rows, so somehow it is not failing completely. I'd try reducing number of columns temporarily just to check whether it is a memory issue.
You could also try to check the query profile and see if it shows the moment it truncates to 10000 rows if there's an explanation.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-06-2024 05:26 AM
Yes I read the documentation that says it truncates at 64k rows, but as you can see I only have 36k row in total and only 10k are displayed, also, the data is really small, 36k row on 5 columns. I can't see that reaching 2187MB.
I reduced the query to its minimum to be useful but nothing. It's a time series, when aggregated daily it does display everything but when in hourly it only displays 10k...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2024 04:13 AM
Hello,
I am currently facing the same issue.
Has there been an update or a solution since the last post?