Athena query that filter result from the last 1 hour ?

Question

Do anyone know how to filter athena waf log from the last hour?

for example
`SELECT count(*) AS countRequests,httprequest.clientip, terminatingruleid, httprequest.uri
FROM "waf_logs" 
WHERE 
 date >=date_format(current_date - interval '7' day, '%Y/%m/%d')  
GROUP BY httprequest.clientip,terminatingruleid, httprequest.uri
ORDER BY count(*) DESC`

Leo K · Accepted Answer

Try writing the filter like this:

```
WHERE timestamp>=to_unixtime(date_add('hour', -1, now()))*1000
```

Oleksii Bebych · Answer

Try this

```
SELECT 
    count(*) AS countRequests,
    httprequest.clientip,
    terminatingruleid,
    httprequest.uri
FROM 
    "waf_logs"
WHERE 
    date_diff('hour', from_iso8601_timestamp(timestamp), now()) <= 1
GROUP BY 
    httprequest.clientip,
    terminatingruleid,
    httprequest.uri
ORDER BY 
    countRequests DESC;
```

Athena query that filter result from the last 1 hour ?

相关内容