The AS aliasing only works if you explicitly declare each field. Otherwise,
the * matcher for fields automatically pre-pends the function name. We
intend to allow AS to operate on * matched fields, but for the first
version it was too complex to implement. (See
Currently, you can use SELECT LAST(*)... or you can have custom field keys
for the output, but not both.
On Mon, Sep 19, 2016 at 11:19 AM, <steve.r.we...@gmail.com> wrote:
> Moving and downsampling some data between two databases. Need the to
> maintain the names of the values.
> SELECT last(*)
> INTO "mfcf_vmware"."autogen".:measurement
> FROM /^vmware_.*/
> WHERE time >= '2016-01-01T00:00:00Z'
> GROUP BY time(30m), "host"
> This almost worked but the copy of the data has "last_" prefixed for all
> the values.
> What's the best way to alias the columns to the original name?
> is there a possible backreference?
> `SELECT last(*) AS .:?origina_name?`
> Also can you point me to the location in the documentation that shows this?
> If this information is not in the documents then perhaps an issue should
> be created.
> Remember to include the InfluxDB version number with all issue reports
> You received this message because you are subscribed to the Google Groups
> "InfluxDB" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to influxdb+unsubscr...@googlegroups.com.
> To post to this group, send email to firstname.lastname@example.org.
> Visit this group at https://groups.google.com/group/influxdb.
> To view this discussion on the web visit https://groups.google.com/d/ms
> For more options, visit https://groups.google.com/d/optout.
Director of Support and Professional Services
Remember to include the InfluxDB version number with all issue reports
You received this message because you are subscribed to the Google Groups
To unsubscribe from this group and stop receiving emails from it, send an email
To post to this group, send email to email@example.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit
For more options, visit https://groups.google.com/d/optout.