2 réponses
- Le plus récent
- Le plus de votes
- La plupart des commentaires
1
Try writing the filter like this:
WHERE timestamp>=to_unixtime(date_add('hour', -1, now()))*1000
0
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;
FUNCTION_NOT_FOUND: line 9:23: Unexpected parameters (bigint) for function from_iso8601_timestamp. Expected: from_iso8601_timestamp(varchar(x)), from_iso8601_timestamp(char(x)) This query ran against the "default" database, unless qualified by the query.
Contenus pertinents
- demandé il y a 7 mois
- demandé il y a 2 mois
AWS OFFICIELA mis à jour il y a 10 mois- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans
works! many thanks