hiveql - sum by dates (Hive)

Question

I want to sum(boolean field 1/0, int, "orders") by date(timestamp field, "event_date").

I have tried to do that but I have got output only for one date

Select to_date(event_date), sum(orders) from table where to_date(event_date) > '2021-01-01' group by to_date(event_date)

DB HIve

Can you help me what I do wrong here ?

Answer 1

等待大神答复