Dynamic order by in clickhouse row_number()

Question

I have (24.1.4.20) view in clickhouse and want change order by columns inside over() of row_number().

create or replace view data.v1 as
select row_number() over(order by COLUMNS({p_order_by:String})) as rn,
       ...

Is it possible to use something like this?

select *
from   data.v1(p_order_by = 'col1,col2,col3...')

Slach · Accepted Answer · 2024-05-16 08:02:21Z

1

{p_order_by:String} is regexp so you could try to use col1|col2|col3

answered May 16, 2024 at 8:02

Slach

2,7081 gold badge18 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1