Trying to follow the first course. The lesson versus the actual cloud site is completely different from each other. Can’t complete the first lesson:
executing query: failed to create Flight record reader: arrow/flight: could not create flight reader: arrow/ipc: could not read schema from stream: arrow/ipc: could not read message schema: rpc error: code = InvalidArgument desc = Error while planning query: SQL error: TokenizerError(“Unexpected EOF while in a multi-line comment at Line: 14, Column 26”)
import “experimental/csv”
relativeToNow = (tables=<-) => tables
|> elapsed()
|> sort(columns: [“_time”], desc: true)
|> cumulativeSum(columns: [“elapsed”])
|> map(fn: (r) => ({r with _time: time(v: int(v: now()) - r.elapsed * 1000000000)}))
csv.from(url: “https://influx-testdata.s3.amazonaws.com/noaa.csv”)
|> relativeToNow()
|> limit(n: 100)
|> to(bucket: “noaa”)
executing query: failed to create Flight record reader: arrow/flight: could not create flight reader: arrow/ipc: could not read schema from stream: arrow/ipc: could not read message schema: rpc error: code = InvalidArgument desc = Error while planning query: SQL error: ParserError(“Expected an SQL statement, found: import”)
Any ideas what is causing this?
I’m having the exact same problems. Really frustrating that the videos seem to be so out of date. It shouldn’t be too hard for them to add in some notes under the video to explain what is different in the latest version. Shame that no one from InfluxDB seems to be monitoring this forum!
