Join two measurements with different timestamps

InfluxDB 2
,
1

Hi!

Could you point me out the way to have data from two measurements or update measurement_1 from the below two measurements in influxdb2? Expected a measurement_1 of 9 series of both measurements. In case of existing timestamps in both measurements - measurement_2 should be skipped.
-----------------measurement_1 ----------------|-------------- | measurement_2
datetime____________tag_____fields__ ||__ datetime__________ tag ___fields
2020-11-26T00:00:10 | coffee | json_data1 || 2020-11-26T00:00:21 | coffee | json_data
2020-11-26T00:00:30 | coffee | json_data1 || 2020-11-26T00:00:43 | coffee | json_data
2020-11-26T00:00:50 | coffee | json_data1 || 2020-11-26T00:01:02 | coffee | json_data
2020-11-26T00:01:10 | coffee | json_data1 || 2020-11-26T00:01:31 | coffee json_data
2020-11-26T00:02:00 | coffee | json_data1 || 2020-11-26T00:02:00 | coffee | json_data

Expectedmeasurement_1
datetime tag _fields
2020-11-26T00:00:10 coffee json_data1
2020-11-26T00:00:21 coffee json_data
2020-11-26T00:00:30 coffee json_data1
2020-11-26T00:00:43 coffee json_data
2020-11-26T00:00:50 coffee json_data1
2020-11-26T00:01:02 coffee json_data
2020-11-26T00:01:10 coffee json_data1
2020-11-26T00:01:31 coffee json_data
2020-11-26T00:02:00 coffee json_data1

2

Hello @sboris,
Have you tried using union instead?

3

Hello
Yes, I have tried. >> But the result is strange.