is ORDER BY multiple fields not working properly on pinot?

SELECT product_id, COUNT(*) as views
FROM table
ORDER BY views, product_id DESC

in regular RDBMS I would expect for it to order by the views first and then product id so something like

views, product_id
3      3
3      2
3      1

but pinot does something completely different is doing

views, product_id
1      10
1      9
1      8

anyone has an idea why this may be?

The result seems correct to me, it's ordering by descending order on both columns, except that

views

has only value 1

but I'm specifying I want it to be sorted by views

Are you GROUPing BY?

upon checking the code. DESC applies to each individual column

Except isn’t

views

just a

COUNT(*)

without any group? So what would that mean? I think there’s a missing

GROUP BY product_id

oooo so I just have to specify on both

i believe this is common practices upon searching on stackoverflow. i don’t know however whether this ANSI standard.

cool cool thanks I will test it out

but what @User mention is another point to investigate, upon checking your SQL wouldn’t compile since it is unclear what you want to count(*) on

yea sorry I think I miss copied the query the group by is missing

that’s what i’ve guessed 😆