The query cann't be run

The query fail with strange exception.
IllegalStateException: This generator does not support mappings beyond (399.7 KB)

Any updates here? I am still waiting your support


Are you not missing a GROUP BY clause? as you are using

(CASE WHEN MAX(v.viewed_at) OVER(partition by a.job_id) > a.applied_at THEN 'Yes' ELSE 'NO' END) as "Applied Before Last View Activity",


This is a window functions, which runs without any group by


Can you please try couple of options

#1 Run the SQL directly on MySQL. Does it work?
#2 Disable the reflection and see if the query works from Dremio


When I disabled the reflection it worked fine. Otherwise it fails.