Using Community edition, version 4.2.1 Dremio is reporting the following error:
This query cannot be planned—possibly due to use of an unsupported feature.
Query is fairly straightforward, attempting to combine LEAD with OVER window function.
The attribute being led is the result of a VDS which is flattening a jSON file, the field in the partitioning clause of the OVER is also the result of a flattened JSON file.
From what I can see, Dremio supports the LEAD function when combined with OVER window function.
Any thoughts on this one?