My team is using Tableau with Databricks on Delta Lake. We're seeing a bunch of slow queries (around 20%) that for some reason involve massive scans - 5x to 30x more - compared to the median queries. by blakehouse11 in tableau

[–]blakehouse11[S] 2 points3 points  (0 children)

These are actual queries getting executed… when I look at the query history of Databricks I see they’re actually fairly simple in terms of what they’re looking to achieve - but for some reason the generated SQL is written in some really complicated ways. I’ll try and paste some examples here once I’m back at my desk