k8s-events-query2.sql

With nodes as (
    select
          e.event.reason,
          e.event.message,
          e.event.lastTimestamp as ts,
          e.event.metadata.name
    from
        commons.eventrouter_events e
    where
        e.event.involvedObject.kind = 'Node'
          AND e.event.type = 'Normal'
          AND e.event.reason = 'NodeNotReady'
    ORDER by ts DESC
)
select
    *
from
    nodes
Limit 100;