Explicitly name each field in the SELECT statement:

SELECT LAST(<field_key_1>), LAST(<field_key_2>), LAST(<field_key_3>),
LAST(<field_key_4>)  FROM measurement

Wildcards are not yet allowed inside functions. Follow
https://github.com/influxdata/influxdb/issues/5750 and
https://github.com/influxdata/influxdb/issues/5978 for progress on that.

On Thu, Jul 7, 2016 at 9:03 AM, <[email protected]> wrote:

> On Wednesday, July 6, 2016 at 10:22:56 AM UTC-4, Sean Beckett wrote:
> >
> https://docs.influxdata.com/influxdb/v0.13/query_language/functions/#last
> >
> >
> >
> > SELECT LAST(<field_key>) FROM measurement
> >
> >
> > On Wed, Jul 6, 2016 at 6:16 AM,  <[email protected]> wrote:
> > My current query for this is SELECT * FROM measurement ORDER BY time
> DESC LIMIT 1. I'm just wondering if there is a better/faster way that this
> should be accomplished?
> >
> >
> >
> > --
> >
> > 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 [email protected].
> >
> > To post to this group, send email to [email protected].
> >
> > 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/68d7a627-d5c4-4dbf-8755-e6bf95e14149%40googlegroups.com
> .
> >
> > For more options, visit https://groups.google.com/d/optout.
> >
> >
> >
> >
> >
> > --
> >
> >
> > Sean Beckett
> > Director of Support and Professional Services
> > InfluxDB
>
> That will only work one field, what if I want an entry containing multiple
> fields?
>
> --
> 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 [email protected].
> To post to this group, send email to [email protected].
> 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/95dc2996-024b-405a-ac23-4e1f6b2205e5%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 the Google Groups 
"InfluxDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
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/CALGqCvMHbHgBBaEGZ3wQs5o-ADnZrSGkVxHJViDbX4qYYGhA9A%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to