Skip to content

Instantly share code, notes, and snippets.

import timeit
from cassandra.cluster import Cluster
cluster = Cluster()
session = cluster.connect()
session.execute("CREATE KEYSPACE IF NOT EXISTS demodb WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };");
session.set_keyspace('demodb');
session.execute("CREATE TABLE IF NOT EXISTS TMCR (p1 int, c1 int, r1 text, PRIMARY KEY (p1, c1));")
@psarna
psarna / allow_filtering_examples_1
Created August 15, 2018 08:07
allow_filtering_examples
category | position | name | price
----------+----------+----------------+-------
starters | 3 | taco the pulpo | 8
category | position | name | price
----------+----------+----------------+-------
starters | 3 | taco the pulpo | 8
category | position | name | price
----------+----------+-----------------+-------
soups | 1 | sour rye soup | 12
soups | 2 | sorrel soup | 8
soups | 3 | beef tripe soup | 11.2
@psarna
psarna / allow_filtering_ex1
Created August 15, 2018 08:11
allow_filtering_ex1
category | position | name | price
----------+----------+----------------+-------
starters | 3 | taco the pulpo | 8
@psarna
psarna / allow_filtering_ex2
Created August 15, 2018 08:11
allow_filtering_ex2
category | position | name | price
----------+----------+-----------------+-------
soups | 1 | sour rye soup | 12
soups | 2 | sorrel soup | 8
soups | 3 | beef tripe soup | 11.2
@psarna
psarna / allow_filtering_ex3
Created August 15, 2018 08:12
allow_filtering_ex3
category | position | name | price
----------+----------+----------------+-------
soups | 2 | sorrel soup | 8
starters | 2 | steak tartare | 9.5
starters | 3 | taco the pulpo | 8
@psarna
psarna / allow_filtering_ex4
Created August 15, 2018 08:12
allow_filtering_ex4
category | position | name | price
----------+----------+---------------+-------
soups | 1 | sour rye soup | 12
@psarna
psarna / allow_filtering_ex5
Created August 15, 2018 08:12
allow_filtering_ex5
category | position | name | price
----------+----------+-----------+-------
starters | 1 | foie gras | 10.5
@psarna
psarna / allow_filtering_ex6
Created August 15, 2018 08:12
allow_filtering_ex6
category | position | name | price
----------+----------+----------------+-------
starters | 2 | steak tartare | 9.5
starters | 3 | taco the pulpo | 8