Dremio is throwing an error on my query when I enable reflections on the data. I can run the query without reflections without any problems.
The error is “Cannot convert RexNode to equivalent Dremio expression. RexNode Class: org.apache.calcite.rex.RexOver, RexNode Digest: COUNT($3) OVER (PARTITION BY $0 ORDER BY $1 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)”
The query profiles for the successful and failing queries are attached. Does anyone have any idea what could be happening?