CODEWITHSUNDEEP
time-seriesinfluxdbinfluxql
fxweidinger
fxweidinger

Reputation: 303

Is there a way to specify the field-key when using the INTO statement?

I have the need to combine two measurements into one single measurement for cross-measurement operations, but both of the measurements only have one single field-key "value".

(I know, that this is not a "pretty" Schema Design and I know about Flux query language but I am not allowed to use Beta features in this case.)

Example:

Base Series: 

voltage, field-key: "value"=x,<tags>
current, field-key: "value"=x,<tags>

Should become this:

New Series

newMeasurement,field-key: "current"=x,field-key: "voltage"=x, <tags>

I tried SELECT_clause INTO <measurement_name> FROM_clause [WHERE_clause] [GROUP_BY_clause] but I could not achieve the desired result. Is this possible or do I have to re-arrange my schema and rename field-keys?

Upvotes: 0

Views: 150

Answers (1)

Nikolay H&#252;ttenberend
Nikolay H&#252;ttenberend

Reputation: 1368

Did you try
SELECT value AS current INTO newMeasurement FROM current GROUP BY *
SELECT value AS voltage INTO newMeasurement FROM voltage GROUP BY *
?

Upvotes: 1

Related Questions