Hello everyone,
i have two datasets with around 36500 rows which i want to join but it throws Request timed out error. For smaller datasets it works fine (it is slower but it works). Does anyone know where can be a problem?
Here is my code:
`
mask = from(bucket:"metering")
|> range(start: ${moment().startOf('year').toISOString()}, stop: ${moment().endOf('year').toISOString()})
|> filter(fn: (r) => r._measurement == "vbattery_mask" and r.product == "premium")
accumulation = from(bucket:"metering")
|> range(start: ${moment().startOf('year').toISOString()}, stop: ${moment().endOf('year').toISOString()})
|> filter(fn: (r) => r._measurement == "vbattery_accumulation" and r.product == "premium")
join(
tables: {mask: mask, acc: accumulation},
on: ["_time"]
)
`