Influxdb: [feature request] ORDER BY tag values
beckettsean
All 43 comments
+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.
Jhors2
on 2 Sep 2015
Will that issue meet our needs like that?:
select count(values) from events group by event_type order by count desc
muratcorlu
on 8 Nov 2015
@muratcorlu no, that is a separate request. This is only for ordering by tag values, not by function return values.
beckettsean
on 9 Nov 2015
+1
timgriffiths
on 23 Nov 2015
+1
plus order by <field>
jgrobelny-dev
on 9 Feb 2016
very useful
+1
dstreppa
on 18 Jul 2016
:+1:
envintus
on 24 Sep 2016
Hi influxers,
any update on this issue? Anything planned?
martinschuberts
on 23 Nov 2016
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.
gerrickw
on 1 Feb 2017
Any update ?
haidaraM
on 23 May 2017
+1
dominic-miglar
on 18 Nov 2017
+1
tabeyti
on 30 Nov 2017
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
JamesGalt
on 27 Jan 2018
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.
NateZimmer
on 20 Apr 2018
+1
jcsdatera
on 6 Jun 2018
+1
dannybeeckman
on 28 Jun 2018
@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)
JulienChampseix
on 14 Sep 2018
we are now in Mar 2019 :) I will take clickhouse soon
umatomba
on 13 Mar 2019
+1
2019
laudukang
on 19 Mar 2019
what are you doing guys please do something about this matter, irritating sort system group by tag it is 2019 now
imohidul
on 10 Apr 2019
+1
debmalyapan53
on 10 Apr 2019
+1
Vanderlan
on 11 Apr 2019
+1
matheusnicolas
on 12 Apr 2019
+1
GersonSales
on 12 Apr 2019
+1
RamonSalem
on 12 Apr 2019
+1. 2019, order by field value is a must.
cybermax
on 14 Apr 2019
+1, super basic feature for a database
4nte
on 30 Apr 2019
+1, we hit that problem too. It would be very nice to have this function.
jkalnik
on 26 Jun 2019
+1, any announcement on this issue?
slachtar
on 12 Jul 2019
+1, please <3
fionera
on 31 Jul 2019
+1000
windkh
on 7 Aug 2019
Any update in this issue. Even a statement to say if it's in scope or there are no plans for this?
ahgit101
on 5 Sep 2019
+1
wurmrobert
on 13 Oct 2019
+1
shkarimpour
on 12 Nov 2019
+1
chopchopjames
on 18 Nov 2019
+1
thomas-tf
on 4 Dec 2019
+1
valerioformato
on 28 Jan 2020
+1
Vebryn
on 21 Feb 2020
+1
eRudy
on 29 Feb 2020
any plan to add this feature ?
ouinouin
on 6 Apr 2020
Support for sorting by tags will likely not be added to InfluxQL, but it is already supported in Flux.
sanderson
on 6 Apr 2020
+1
VytasMule
on 3 Jul 2020
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.
gabzim
on 3 Jan 2021
Related issues
affo
路
3Comments
allenbunny
路
3Comments
bigKS
路
3Comments
airyland
路
3Comments
dtouzeau
路
3Comments
Most helpful comment
+1
plus order by
<field>