Searching a trillion rows
Here are some sample queries for exploring BGP data
count by Peer_IP address for Dec 1st 2019
SELECT Peer_IP, count()
FROM sample.bgp
WHERE (timestamp BETWEEN '2019-12-01 00:00:00' AND '2019-12-02 00:00:00') GROUP BY Peer_IP;
curl --data-binary @- https://try3.hydrolix.live/query <<EOF
SELECT Peer_IP, count()
FROM sample.bgp
WHERE (timestamp BETWEEN '2019-12-01 00:00:00' AND '2019-12-02 00:00:00') GROUP BY Peer_IP
EOF
count by Peer_ASN for Dec 1st 2019
SELECT Peer_ASN, count()
FROM sample.bgp
WHERE (timestamp BETWEEN '2019-12-01 00:00:00' AND '2019-12-02 00:00:00') GROUP BY Peer_ASN
curl --data-binary @- https://try3.hydrolix.live/query <<EOF
SELECT Peer_ASN, count()
FROM sample.bgp
WHERE (timestamp BETWEEN '2019-12-01 00:00:00' AND '2019-12-02 00:00:00') GROUP BY Peer_ASN
EOF
Updated 10 months ago