thanks for the help Sean!

On Tue, Sep 20, 2016 at 3:31 PM, Sean Beckett <s...@influxdb.com> wrote:

> 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/ms
>> gid/influxdb/CAAcLdHM7%2BcEn2C_ywq0DUwbOcAGMFG1Bbt4abpq4WT6c
>> 8TFVTA%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 a topic in the
> Google Groups "InfluxDB" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/
> topic/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/
> msgid/influxdb/CALGqCvPHX-TZ%2BoTa_hEJ1hTfHcsft_9-
> zND9jVs7nUoersd77g%40mail.gmail.com
> <https://groups.google.com/d/msgid/influxdb/CALGqCvPHX-TZ%2BoTa_hEJ1hTfHcsft_9-zND9jVs7nUoersd77g%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/CAAcLdHNKLpBheq0y6uNm%3DppXeV%3D4EknFyDjY%2Bboe4Q4UFkvvcQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to