Yes, that's a feature we intend to support, but "AS" was specifically left
out of the first wildcard for fields PR, as it complicates things
significantly.

On Tue, Sep 20, 2016 at 6:59 AM, Steve Weber <steve.r.we...@gmail.com>
wrote:

> Ah thanks... so what im looking for is something like
>
> ```
> SELECT last(*) as ""  from vmware_cpu limit 1
> ```
>
> I moved over to the pullrequest/issue to see what the devs think.
>
> On Mon, Sep 19, 2016 at 7:52 PM, Sean Beckett <s...@influxdb.com> wrote:
>
>> 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
>> https://github.com/influxdata/influxdb/pull/7009)
>>
>> 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.
>>>
>>> Thanks
>>>
>>> --
>>> 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 influxdb@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/influxdb.
>>> To view this discussion on the web visit https://groups.google.com/d/ms
>>> gid/influxdb/5463f361-4501-4210-9354-a144eedb08f1%40googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>>
>> --
>> Sean Beckett
>> Director of Support and Professional Services
>> InfluxDB
>>
>> --
>> Remember to include the InfluxDB version number with all issue reports
>> ---
>> You received this message because you are subscribed to a topic in the
>> Google Groups "InfluxDB" group.
>> To unsubscribe from this topic, visit https://groups.google.com/d/to
>> pic/influxdb/hMfAITLnloA/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> influxdb+unsubscr...@googlegroups.com.
>> To post to this group, send email to influxdb@googlegroups.com.
>> Visit this group at https://groups.google.com/group/influxdb.
>> To view this discussion on the web visit https://groups.google.com/d/ms
>> gid/influxdb/CALGqCvPsvg9u-vaTAmna5EF%2BoOPv-kqnHQLv22EneuXH
>> n5zbZg%40mail.gmail.com
>> <https://groups.google.com/d/msgid/influxdb/CALGqCvPsvg9u-vaTAmna5EF%2BoOPv-kqnHQLv22EneuXHn5zbZg%40mail.gmail.com?utm_medium=email&utm_source=footer>
>> .
>>
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> 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 influxdb@googlegroups.com.
> Visit this group at https://groups.google.com/group/influxdb.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/influxdb/CAAcLdHM7%2BcEn2C_ywq0DUwbOcAGMFG1Bbt4abpq4WT6c8
> TFVTA%40mail.gmail.com
> <https://groups.google.com/d/msgid/influxdb/CAAcLdHM7%2BcEn2C_ywq0DUwbOcAGMFG1Bbt4abpq4WT6c8TFVTA%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Sean Beckett
Director of Support and Professional Services
InfluxDB

-- 
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 influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/CALGqCvPHX-TZ%2BoTa_hEJ1hTfHcsft_9-zND9jVs7nUoersd77g%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to