Multiple fields returned in single table from pandas

InfluxDB 2
, ,
1

Hi all,

I’m using flux to query my influxdb via python pandas. However, I noticed that one of the tables returned contains multiple fields. These fields are not tags.
I would have expected tables returned to contain only one field and the same number of rows. In this case, 2.
When running the same flux query using the data explorer, these fields show up as separate tables.

Why is this occurring ?

result table  ...    process_name        user

0 _result 0 … rocket_btcbusd yoloequity
1 _result 0 … rocket_btcbusd yoloequity
2 _result 1 … rocket_btcbusd yoloequity
3 _result 1 … rocket_btcbusd yoloequity
4 _result 2 … rocket_btcbusd yoloequity
5 _result 2 … rocket_btcbusd yoloequity

image
image1663×580 21.3 KB

I also noticed when querying without dataframes(ie. just for Flux tables), the results are more consistent with what I expect:
FluxTable() columns: 14, records: 2
FluxTable() columns: 14, records: 2
FluxTable() columns: 14, records: 2
FluxTable() columns: 14, records: 2
FluxTable() columns: 14, records: 2
FluxTable() columns: 14, records: 2
FluxTable() columns: 14, records: 2
FluxTable() columns: 14, records: 2
FluxTable() columns: 14, records: 2
FluxTable() columns: 14, records: 2
FluxTable() columns: 14, records: 2
FluxTable() columns: 14, records: 2

Many thanks in advance