create table "MyKeyspace"."CkeyTest" (accountid bigint, descbigint1 bigint, ascbigint2 bigint, 
	ascstring1 ascii, value text, PRIMARY KEY ((accountid), descbigint1, ascbigint2, ascstring1))
	WITH CLUSTERING ORDER BY (descbigint1 DESC, ascbigint2 ASC, ascstring1 ASC) 
	AND COMPACT STORAGE;


INSERT INTO "MyKeyspace"."CkeyTest" (accountid, descbigint1, ascbigint2, ascstring1, value) VALUES
(111, 222, 333, 'apple', 'green');
INSERT INTO "MyKeyspace"."CkeyTest" (accountid, descbigint1, ascbigint2, ascstring1, value) VALUES
(111, 222, 333, 'banana', 'yellow');
INSERT INTO "MyKeyspace"."CkeyTest" (accountid, descbigint1, ascbigint2, ascstring1, value) VALUES
(111, 222, 333, 'kiwi', 'green');
INSERT INTO "MyKeyspace"."CkeyTest" (accountid, descbigint1, ascbigint2, ascstring1, value) VALUES
(111, 222, 333, 'cherry', 'red');

INSERT INTO "MyKeyspace"."CkeyTest" (accountid, descbigint1, ascbigint2, ascstring1, value) VALUES
(111, 222, 363, 'apple', 'green');
INSERT INTO "MyKeyspace"."CkeyTest" (accountid, descbigint1, ascbigint2, ascstring1, value) VALUES
(111, 222, 353, 'banana', 'yellow');
INSERT INTO "MyKeyspace"."CkeyTest" (accountid, descbigint1, ascbigint2, ascstring1, value) VALUES
(111, 222, 343, 'kiwi', 'green');


INSERT INTO "MyKeyspace"."CkeyTest" (accountid, descbigint1, ascbigint2, ascstring1, value) VALUES
(111, 232, 363, 'apple', 'green');
INSERT INTO "MyKeyspace"."CkeyTest" (accountid, descbigint1, ascbigint2, ascstring1, value) VALUES
(111, 242, 353, 'banana', 'yellow');
INSERT INTO "MyKeyspace"."CkeyTest" (accountid, descbigint1, ascbigint2, ascstring1, value) VALUES
(111, 252, 343, 'kiwi', 'green');
INSERT INTO "MyKeyspace"."CkeyTest" (accountid, descbigint1, ascbigint2, ascstring1, value) VALUES
(111, 262, 333, 'cherry', 'red');

INSERT INTO "MyKeyspace"."CkeyTest" (accountid, descbigint1, ascbigint2, ascstring1, value) VALUES
(111, 232, 322, 'apple', 'green');
INSERT INTO "MyKeyspace"."CkeyTest" (accountid, descbigint1, ascbigint2, ascstring1, value) VALUES
(111, 242, 323, 'banana', 'yellow');
INSERT INTO "MyKeyspace"."CkeyTest" (accountid, descbigint1, ascbigint2, ascstring1, value) VALUES
(111, 252, 324, 'kiwi', 'green');
INSERT INTO "MyKeyspace"."CkeyTest" (accountid, descbigint1, ascbigint2, ascstring1, value) VALUES
(111, 262, 325, 'cherry', 'red');