Can't remove "table" and "result" from query results using `drop`

influxdata / flux

Flux is a lightweight scripting language for querying databases (like InfluxDB) and working with data. It's part of InfluxDB 1.7 and 2.0, but can be run independently of those.

https://influxdata.com

MIT License

769 stars 153 forks source link

Can't remove "table" and "result" from query results using `drop` #5418

Closed sezanzeb closed 1 year ago

sezanzeb commented 1 year ago

I'm trying to remove all internal fields from a query result using

|> some other transformations
|> rename(columns: {_time: "time"})
|> drop(columns: [
    "_time",
    "_field",
    "_value",
    "_measurement",
    "_start",
    "_stop",
    "result",
    "table",
    "host"
])

However, "table" and "result" are still there. Apart from that the first column is completely empty and doesn't even have a column name, but that is a different topic.

,result,table,time,foo,bar
,,0,2021-12-24T02:00:00Z,foo,1

github-actions[bot] commented 1 year ago

This issue has had no recent activity and will be closed soon.