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

Did this page help you?