2 Respuestas
- Más nuevo
- Más votos
- Más comentarios
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.
Contenido relevante
- preguntada hace un mes
- preguntada hace un mes
works! many thanks