[feature request] ORDER BY tag values

[beckettsean]

No description provided.

[Jhors2]

+1, would love this. Would also like to pass more than 1 tag to the order by operation so they are alpha sorted first by tag1 then by tag2, etc.

[muratcorlu]

Will that issue meet our needs like that?:

select count(values) from events group by event_type order by count desc

[beckettsean]

@muratcorlu no, that is a separate request. This is only for ordering by tag values, not by function return values.

[timgriffiths]

+1

[jgrobelny-dev]

+1
plus order by <field>

[dstreppa]

very useful
+1

[envintus]

👍

[martinschuberts]

Hi influxers,
any update on this issue? Anything planned?

[gerrickw]

Any workaround for this? For some reason influxdb decides tag values return should be sorted 100,101,102,...,198,199,001,002,003. As grafana writes whatever is returned by the database I have a large drop down menu of template values with a whacky sort that makes people confused how it even determined that is the correct sort.

[haidaraM]

Any update ?

[dominic-miglar]

+1

[tabeyti]

+1

[JamesGalt]

Hi, Would be great especially if we use the tag to avoid overriding when 2 points with same tags values and same timestamp are written.
Any workaround?
Thanks

[NateZimmer]

So if someone is using influxDB to track device diagnostics naturally one would wish to sort by value. For example, if one is investigating device resets, one would wish to sort a list and prioritize the devices that are resetting the most. Without this... metrics that target problematic units are nearly impossible.

[jcsdatera]

+1

[dannybeeckman]

+1

[JulienChampseix]

@beckettsean we are now in August 2018 (issue created in 2015) any update on it or plan in influx roadmap ? (order by part capability is really a strong functionnality missing to influx)

[umatomba]

we are now in Mar 2019 :) I will take clickhouse soon

[laudukang]

+1

2019

[imohidul]

what are you doing guys please do something about this matter, irritating sort system group by tag it is 2019 now

[debmalyapan53]

+1

[matheusnicolas]

+1

[GersonSales]

+1

[RamonSalem]

+1

[cybermax]

+1. 2019, order by field value is a must.

[4nte]

+1, super basic feature for a database

[jkalnik]

+1, we hit that problem too. It would be very nice to have this function.

[slachtar]

+1, any announcement on this issue?

[fionera]

+1, please <3

[windkh]

+1000

[ahgit101]

Any update in this issue. Even a statement to say if it's in scope or there are no plans for this?

[wurmrobert]

+1

[shkarimpour]

+1

[chopchopjames]

+1

[thomas-tf]

+1

[valerioformato]

+1

[Vebryn]

+1

[eRudy]

+1

[ouinouin]

any plan to add this feature ?

[sanderson]

Support for sorting by tags will likely not be added to InfluxQL, but it is already supported in Flux.

[VytasMule]

+1

[gabzim]

Support for sorting by tags will likely not be added to InfluxQL, but it is already supported in Flux.

I would buy this, the problem is that flux is orders of magnitude slower than influxql.

[Styx13]

+1

[gabzim]

Support for sorting by tags will likely not be added to InfluxQL, but it is already supported in Flux.

I would buy this, the problem is that flux is orders of magnitude slower than influxql.

I was on influx 1.x, I've noticed that Influx 2.x has much better performance for flux, so I take that back.

[AlexHeylin]

+1

[riteshs-cashify]

+1

[rijenkii]

Support for sorting by tags will likely not be added to InfluxQL, but it is already supported in Flux.

What about influx 3.0, where flux is basically deprecated?

[pauldix]

@rijenkii InfluxDB 3.0 has a fully featured SQL query engine so this is supported in that language. InfluxQL is also supported, but doesn't support sorting by tags.