Online Reflection Training -- not seeing "too expensive"

Dremio University
1

Hello,
I’m going through the D.U. Reflection training. The training doc shows that the Acceleration profile should show “Too expensive” in some scenarios. I only see “Did not cover query” when I execute the same scenario described in the “More on Substitution” section of the training . Attached is my associated job profile.

Can dremio actually report the distinction between Did not cover query and Too expensive, or did I do something wrong setting up the reflections? Thanks.

2193adef-eb56-4810-94f9-68b22c5a1b01.zip (12.6 KB)

1 Like
2

@jabaier117

For the Raw reflection “no_vendor_id” on dataset “Reflections Lab (WIP)”.trips what does it say?

Thanks
@balaji.ramaswamy

3

The lab instance of Dremio I was using has expired. Here’s the query I ran:

SELECT DATE_PART('day',pickup_datetime) AS day_num, COUNT(*) AS C

FROM "Reflections Lab (WIP)".trips

GROUP BY DATE_PART('day', pickup_datetime)

ORDER BY COUNT(*) DESC

The course says I should have seen this:

image
image929×438 57.9 KB

But for me, all reflections showed “Did not cover query”