It looks like subqueries are not being evaluated or partially evaluated when Dremio is in Preview mode… This is pretty misleading when sampled rows are being returned which would not be part of the result set if Preview was changed to Run.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
|
PLAN ERROR: Node [rel#629853:Subset#3.LOGICAL.ANY([]).[]] could not be implemented; planner state
|
5 | 1582 | April 20, 2022 | |
|
The UI preview is very slow compared to the run
|
11 | 1578 | May 5, 2020 | |
| Regarding SAMPLE, SAMPLEID functions | 1 | 817 | February 13, 2023 | |
|
Record limits - Even for simple aggregations!
|
6 | 2639 | January 22, 2022 | |
|
How to get query preview from external
|
6 | 1435 | February 27, 2019 |