Apache Pinot

hey , wondering if there is a way to get first row of a group after group by?

select brand_id, *first(brand_name), first(brand_logo)* from ofo_store_channel where REGEXP_LIKE(brand_name, ‘肯德基.*’) and partition_timestamp_second = 1659225600 and city=‘shanghai’ and country=‘CHN’ group by brand_id  limit 10

how can i get first(brand_name), first(brand_logoal).
one brand_id could have mulple brand_name and brand_logo

maybe not specific first row ,random row in the group is ok.

what i want to do is first group by brand_id,
and then get random row in each group

in trino, i can just use a window function.

something like
```       rank() OVER (PARTITION BY clerk
                    ORDER BY totalprice DESC) AS rnk```

Yeah I don’t think this is possible using v1 engine today. cc: <@UK6JD1E85> for v2 engine

For my understanding, how will the query look like?

```select brand_id, FIRSTWITHTIME(brand_logo_url, partition_timestamp_second, 'STRING')
from ofo_store_channel 
where REGEXP_LIKE(brand_name, '肯德基.*') and partition_day = '2022-07-31' and city='shanghai'
group by brand_id
limit 10```