Skip to content

Instantly share code, notes, and snippets.

View guy9's full-sized avatar

Guy Shtub guy9

5 followers · 0 following
View GitHub Profile
@guy9
guy9 / mms2-day2-1.cql
Last active April 20, 2020 08:15
first_name | last_name | timestamp | heat | location | speed | telepathy_powers
------------+-----------+--------------------------+------+------------+-------+------------------
Bob | Loblaw | 2017-11-11 12:05:00+0000 | 10 | Cincinnati | 12 | 60
Bob | Loblaw | 2017-11-11 11:05:00+0000 | 2 | Cincinnati | 10 | 3
Bob | Loblaw | 2017-11-11 10:22:00+0000 | 3 | Cincinnati | 8 | 6
Bob | Loblaw | 2017-11-11 10:05:00+0000 | 1 | Cincinnati | 6 | 15
Bob | Loblaw | 2017-11-11 09:05:00+0000 | 1 | Cincinnati | 4 | 10
Bob | Loblaw | 2017-11-11 08:05:00+0000 | 6 | Cincinnati | 2 | 5
Jim | Jeffries | 2017-11-11 12:05:00+0000 | 24 | New York | 4 | 57
Jim | Jeffries | 2017-11-11 11:05:00+0000 | 9 | New York | 4 | 87
@guy9
guy9 / mms2-day2-2.cql
Last active April 20, 2020 08:15
first_name | last_name | timestamp | heat | location | speed | telepathy_powers
------------+-----------+--------------------------+------+----------+-------+------------------
Jim | Jeffries | 2017-11-11 10:05:00+0000 | 5 | New York | 3 | 37
Jim | Jeffries | 2017-11-11 09:05:00+0000 | 4 | New York | 2 | 27
@guy9
guy9 / mms2-day2-3.cql
Last active April 20, 2020 08:15
mms-day2-3-updated
first_name | last_name | timestamp | heat | location | speed | telepathy_powers
------------+-----------+--------------------------+------+----------+-------+------------------
Jim | Jeffries | 2017-11-11 12:05:00+0000 | 24 | New York | 4 | 57
@guy9
guy9 / mms2-day2-4.cql
Last active April 20, 2020 08:15
system.max(speed)
-------------------
4
@guy9
guy9 / mms2-day1-1
Created April 30, 2019 12:32
Datacenter: DC1
===============
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
-- Address Load Tokens Owns (effective) Host ID Rack
UN 172.18.0.2 355.29 KB 256 70.3% afe13402-ec84-4eae-a781-ef92c10b6870 Rack1
UN 172.18.0.3 360.04 KB 256 59.2% 627f496e-4254-4ecd-b2f5-3296ddca25f1 Rack1
UN 172.18.0.4 412.53 KB 256 70.5% f8d3c9df-268e-4e41-84c5-74ac94b3c7a3 Rack1
@guy9
guy9 / mms2-day1-2.cql
Last active April 20, 2020 08:15
first_name | last_name | address | picture_location
------------+-----------+-----------------------+-----------------------------------
Bob | Loblaw | 1313 Mockingbird Lane | http://www.facebook.com/bobloblaw
Jim | Jeffries | 1211 Hollywood Lane | http://www.facebook.com/jeffries
Bob | Zemuda | 1202 Coffman Lane | http://www.facebook.com/bzemuda
@guy9
guy9 / mms2-day1-3.cql
Last active April 20, 2020 08:15
first_name | last_name | address | picture_location
------------+-----------+-----------------------+-----------------------------------
Bob | Loblaw | 1313 Mockingbird Lane | http://www.facebook.com/bobloblaw
(1 rows)
@guy9
guy9 / mms2-day3-1
Created May 7, 2019 10:51
Datacenter: DC1
===============
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
-- Address Load Tokens Owns Host ID Rack
UN 172.18.0.2 425.12 KB 256 ? ebf3f006-26c3-4f98-a0a9-45fc47ec44eb Rack1
UN 172.18.0.3 441.88 KB 256 ? 519cf2c6-0c3e-44e6-98b9-84091757000b Rack1
UN 172.18.0.4 464.4 KB 256 ? 017dd9a1-904b-4152-bcfb-e7a501d6d2ad Rack1
@guy9
guy9 / mm2-day3-2
Created May 7, 2019 10:52
Datacenter: DC1
===============
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
-- Address Load Tokens Owns Host ID Rack
UN 172.18.0.2 425.12 KB 256 ? ebf3f006-26c3-4f98-a0a9-45fc47ec44eb Rack1
DN 172.18.0.3 441.88 KB 256 ? 519cf2c6-0c3e-44e6-98b9-84091757000b Rack1
UN 172.18.0.4 464.4 KB 256 ? 017dd9a1-904b-4152-bcfb-e7a501d6d2ad Rack1
@guy9
guy9 / mms2-day3-3.cql
Last active April 20, 2020 08:15
mms2-day3-3
first_name | last_name | address | picture_location
------------+-----------+-----------------------+-----------------------------------
Bob | Loblaw | 1313 Mockingbird Lane | http://www.facebook.com/bobloblaw
Jim | Jeffries | 1211 Hollywood Lane | http://www.facebook.com/jeffries
Bob | Zemuda | 1202 Coffman Lane | http://www.facebook.com/bzemuda