Syntax issue with one of the interpolation queries.

[simonprickett]

An issue's been reported through support with the syntax of one of the queries:

Hey, I noticed that the interpolated query in the examples is incorrect (Bad usage of paratheses)
ORIGINAL: COALESCE(temperature,(prev_temp + next_temp)) / 2 AS interpolated_temperature
UPDATED: COALESCE(temperature,(prev_temp + next_temp) / 2) AS interpolated_temperature

Find this and fix it if possible.

[amotl]

Is it that spot? However, over there, the SQL statement says

COALESCE(temperature, (prev_temp + next_temp)/2) AS interpolated_temperature

.... so I guess it is about this SQL clause, but NOT at this very spot?

[amotl]

Is it that spot, in the Cloud UI? Also here in pre-sales?

-- Query: https://github.com/search?q=org%3Acrate%20prev_temp%20%2B%20next_temp&type=code

[amotl]

Hi Simon. Is it something which needs more love, or can we close the ticket, as you may have fixed it already?

[simonprickett]

I think this is in the time series course which isn't as fully contained in a github repository as the fundamentals one is. I'll leave it open for now and see if I can find it... it might be shown on screen in the video. The original report didn't have much useful context unfortunately.