Closed
Description
Version
latest
Which SQL?
Flink
SQL content
select
request_id,
click_time,
date_format (click_time, 'yyyy-MM-dd') as click_date,
cast(wid as bigint) as wid,
query,
row_number() over (
partition by
wid,
date_format (click_time, 'yyyy-MM-dd')
order by
click_time
) as ranks
from
search_product
where
wid is not null
and wid <> 'None'
and date_format (click_time, 'yyyy-MM-dd') >= to_date ('2024-12-04', 'yyyy-MM-dd');
JavaScript/TypeScript code
No response
What happened?
期望正确的语法不飘红
Relevant log output
No response
Metadata
Metadata
Assignees
Labels
No labels