You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@druid.apache.org by pu...@gmail.com,
pu...@gmail.com on 2019/03/05 02:21:01 UTC
Ordering by other dimensions
Will there ever be support within druid to order by a specific dimension other than the __time field for select queries?
For example, I may run a select query and specify an order by a particular dimension. So SELECT * from table ORDER BY aStringDimension desc|asc
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@druid.apache.org
For additional commands, e-mail: dev-help@druid.apache.org
Re: Ordering by other dimensions
Posted by pu...@gmail.com,
pu...@gmail.com.
Ordering for aggregations is great, but am also looking for ordering select queries (where we pull the raw values back)
More specifically: http://druid.io/docs/latest/querying/select-query.html
On 2019/03/05 05:41:43, Furkan KAMACI <fu...@gmail.com> wrote:
> Hi,
>
> For aggregation queries, ORDER BY can order by any column. Here is the
> documentation for Druid SQL Order By:
>
> The ORDER BY clause refers to columns that are present after execution of
> GROUP BY. It can be used to order the results based on either grouping
> expressions or aggregated values. ORDER BY can refer to an expression or a
> select clause ordinal position (like ORDER BY 2 to order by the second
> selected column). For non-aggregation queries, ORDER BY can only order by
> the __time column. For aggregation queries, ORDER BY can order by any
> column [1].
>
> [1] http://druid.io/docs/latest/querying/sql
>
> Kind Regards,
> Furkan KAMACI
>
> On Tue, Mar 5, 2019 at 5:55 AM puttbrian@gmail.com <pu...@gmail.com>
> wrote:
>
> > Will there ever be support within druid to order by a specific dimension
> > other than the __time field for select queries?
> >
> > For example, I may run a select query and specify an order by a particular
> > dimension. So SELECT * from table ORDER BY aStringDimension desc|asc
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: dev-unsubscribe@druid.apache.org
> > For additional commands, e-mail: dev-help@druid.apache.org
> >
> >
>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@druid.apache.org
For additional commands, e-mail: dev-help@druid.apache.org
Re: Ordering by other dimensions
Posted by Furkan KAMACI <fu...@gmail.com>.
Hi,
For aggregation queries, ORDER BY can order by any column. Here is the
documentation for Druid SQL Order By:
The ORDER BY clause refers to columns that are present after execution of
GROUP BY. It can be used to order the results based on either grouping
expressions or aggregated values. ORDER BY can refer to an expression or a
select clause ordinal position (like ORDER BY 2 to order by the second
selected column). For non-aggregation queries, ORDER BY can only order by
the __time column. For aggregation queries, ORDER BY can order by any
column [1].
[1] http://druid.io/docs/latest/querying/sql
Kind Regards,
Furkan KAMACI
On Tue, Mar 5, 2019 at 5:55 AM puttbrian@gmail.com <pu...@gmail.com>
wrote:
> Will there ever be support within druid to order by a specific dimension
> other than the __time field for select queries?
>
> For example, I may run a select query and specify an order by a particular
> dimension. So SELECT * from table ORDER BY aStringDimension desc|asc
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@druid.apache.org
> For additional commands, e-mail: dev-help@druid.apache.org
>
>