Influxdb: How can I order by count(somecolumn)?

[airyland]

I was confused as I was trying to query and order by some column but failed.

select count(uuid) from mt group by ip order by count desc

[marcosnils]

@airyland you need to make an alias of the column in order to by it .

I.E: `select count(uuid) AS total from mt group by ip order by total [DESC|ASC]

[airyland]

I tried but still fail.
I'm using [email protected], does it support?

[marcosnils]

@airyland I was talking about 0.9. I have no idea how to do it in 0.8

[beckettsean]

Could not order by anything but time in 0.8.x versions.

[adriancuadros]

Hello @beckettsean, right now when trying to order by an alias of the column it also returns: "only ORDER BY time supported at this time".

Was this feature removed?

[beckettsean]

@adriancuadros the functionality did not survive to the official 0.9.1 release and is not part of any 0.9 or 0.10 official release.

[adriancuadros]

sad to hear, found a workaround but this would have been pretty sweet. hope it turns up sometime soon.

[deepujain]

v : influxdb-0.11.0-1
... order by numMappers
ERR: error parsing query: only ORDER BY time supported at this time

[beckettsean]

@deepujain see https://github.com/influxdata/influxdb/issues/5688, https://github.com/influxdata/influxdb/issues/3954, and https://github.com/influxdata/influxdb/issues/4794

[mans2singh]

@adriancuadros - Can you please let us know what was the workaround ? Thanks