The query cann't be run

1

The query fail with strange exception.
IllegalStateException: This generator does not support mappings beyond
66590229-0818-43eb-b413-208f77552080.zip (399.7 KB)

2

Any updates here? I am still waiting your support

3

@elshafey

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",

Thanks
@balaji.ramaswamy

4

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

5

@elshafey

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

Thanks

6

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