Assignment 2: Loading data into InfluxDB (Beginner Flux course)

InfluxDB University
1

I tried several times to import sample data from
Release 103_beginner_flux_2022.09.08_00-27 · influxdata/influxdb-university (github.com),
for example “oven-data.txt” and it seems it was successfully but every query I try to run returns nothing?
What am I doing wrong?

2

Hello @SergioEanX,
Welcome!
Are you running queries in the Data Explorer?
Can you please share an example of the query you’re running?
My suspicion is that you might be using the date selector which defaults to the last hour(?) of data?
I took the timestamp from the txt file:
1662638400000000000
and used the following converter:

To realize that the first date was -5 days ago. (Which I’m guessing means that this data is periodically being updated, but I’m not sure).
I’d make sure that my query looks like:

from(bucket: "<whatever bucket you wrote your data to>")
  |> range(start: -6d)
  |> filter(fn: (r) => r["_measurement"] == "iot-oven")

Does that help?

Thanks for letting me know about this issue!

3

Hi @SergioEanX,
Just to add to @Anaisdg solution. We release an updated data sample each day. All timestamps are updated to 12 pm UTC for that day. So depending on your time zone this might vary your range.

Here is the link for all releases here: Releases · influxdata/influxdb-university · GitHub

In the case you are uploading and trying to access data before the 12pm UTC time then you will want to do a range like this:

  |> range(start: now(), stop: 3h)

As an example. Let us know how you get on! :slight_smile:

1 Like
4

@Jay_Clifford thank you for clarifying