URGENT: Query View SQL executes Quickly,Select from View is Slow

1

I have some SQL that completes in ~20 seconds. When I save that SQL as a VDS named CycleTimeLive and then run SELECT * FROM CycleTimeLive, it takes 2 minutes to complete. Each of these queries use the same Reflections. Why would the view SQL run so much faster than selecting from the view itself? I would expect the performance to be similar in each case. This is an urgent issue for me as I have a corp demo of Dremio coming up and I’m trying to get it adopted as a replacement for a current technology.

Attached are the profiles from each run.

SelectFromViewName.zip (2.1 MB)
SelectViewCode.zip (1.8 MB)

2

We are looking into this and will get back to you soon.

3

@summersmd, is it possible you were using Preview in the shorter case case and Run in the longer one?

If possible, please send me the zipped profiles (ben@dremio.com), without changing the file names (or altering them in any way).

4

I was definitely not using preview. I will send unmodified zip files.I was using the run option in both cases. I’ve tested this numerous times and the results are always the same.

5

7f3f43ab-2e0a-4f0f-bf0b-41da3896e02f.zip (2.1 MB)
2a82841e-bed0-49e7-830b-bf3e3f9dd35f.zip (1.8 MB)