CREATE KEYSPACE typeconversion WITH replication = {'class': 'NetworkTopologyStrategy', 'PloetzLabs': '1'} AND durable_writes = true; use typeconversion; CREATE TABLE asciiconvert ( key int PRIMARY KEY, c1 ascii, c2 ascii, c3 ascii, c4 ascii, c5 ascii, c6 ascii, c7 ascii, c8 ascii, c9 ascii, c10 ascii, c11 ascii, c12 ascii, c13 ascii, c14 ascii, c15 ascii, c16 ascii, c17 ascii, c18 ascii, c19 ascii, c20 ascii, c21 ascii); INSERT INTO asciiconvert (key,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21) VALUES (1,'1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1'); CREATE TABLE bigintconvert ( key int PRIMARY KEY, c1 bigint, c2 bigint, c3 bigint, c4 bigint, c5 bigint, c6 bigint, c7 bigint, c8 bigint, c9 bigint, c10 bigint, c11 bigint, c12 bigint, c13 bigint, c14 bigint, c15 bigint, c16 bigint, c17 bigint, c18 bigint, c19 bigint, c20 bigint, c21 bigint); INSERT INTO bigintconvert (key,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21) VALUES (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1); CREATE TABLE blobconvert ( key int PRIMARY KEY, c1 blob, c2 blob, c3 blob, c4 blob, c5 blob, c6 blob, c7 blob, c8 blob, c9 blob, c10 blob, c11 blob, c12 blob, c13 blob, c14 blob, c15 blob, c16 blob, c17 blob, c18 blob, c19 blob, c20 blob, c21 blob); INSERT INTO blobconvert (key,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21) VALUES (1,intasblob(1),intasblob(1),intasblob(1),intasblob(1),intasblob(1),intasblob(1),intasblob(1),intasblob(1),intasblob(1),intasblob(1),intasblob(1),intasblob(1),intasblob(1),intasblob(1),intasblob(1),intasblob(1),intasblob(1),intasblob(1),intasblob(1),intasblob(1),intasblob(1)); CREATE TABLE booleanconvert ( key int PRIMARY KEY, c1 boolean, c2 boolean, c3 boolean, c4 boolean, c5 boolean, c6 boolean, c7 boolean, c8 boolean, c9 boolean, c10 boolean, c11 boolean, c12 boolean, c13 boolean, c14 boolean, c15 boolean, c16 boolean, c17 boolean, c18 boolean, c19 boolean, c20 boolean, c21 boolean); INSERT INTO booleanconvert (key,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21) VALUES (1,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true); CREATE TABLE dateconvert ( key int PRIMARY KEY, c1 date, c2 date, c3 date, c4 date, c5 date, c6 date, c7 date, c8 date, c9 date, c10 date, c11 date, c12 date, c13 date, c14 date, c15 date, c16 date, c17 date, c18 date, c19 date, c20 date, c21 date); INSERT INTO dateconvert (key,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21) VALUES (1,'2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08'); CREATE TABLE decimalconvert ( key int PRIMARY KEY, c1 decimal, c2 decimal, c3 decimal, c4 decimal, c5 decimal, c6 decimal, c7 decimal, c8 decimal, c9 decimal, c10 decimal, c11 decimal, c12 decimal, c13 decimal, c14 decimal, c15 decimal, c16 decimal, c17 decimal, c18 decimal, c19 decimal, c20 decimal, c21 decimal); INSERT INTO decimalconvert (key,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21) VALUES (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1); CREATE TABLE doubleconvert ( key int PRIMARY KEY, c1 double, c2 double, c3 double, c4 double, c5 double, c6 double, c7 double, c8 double, c9 double, c10 double, c11 double, c12 double, c13 double, c14 double, c15 double, c16 double, c17 double, c18 double, c19 double, c20 double, c21 double); INSERT INTO doubleconvert (key,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21) VALUES (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1); CREATE TABLE floatconvert ( key int PRIMARY KEY, c1 float, c2 float, c3 float, c4 float, c5 float, c6 float, c7 float, c8 float, c9 float, c10 float, c11 float, c12 float, c13 float, c14 float, c15 float, c16 float, c17 float, c18 float, c19 float, c20 float, c21 float); INSERT INTO floatconvert (key,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21) VALUES (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1); CREATE TABLE inetconvert ( key int PRIMARY KEY, c1 inet, c2 inet, c3 inet, c4 inet, c5 inet, c6 inet, c7 inet, c8 inet, c9 inet, c10 inet, c11 inet, c12 inet, c13 inet, c14 inet, c15 inet, c16 inet, c17 inet, c18 inet, c19 inet, c20 inet, c21 inet); INSERT INTO inetconvert (key,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21) VALUES (1,'1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1'); CREATE TABLE intconvert ( key int PRIMARY KEY, c1 int, c2 int, c3 int, c4 int, c5 int, c6 int, c7 int, c8 int, c9 int, c10 int, c11 int, c12 int, c13 int, c14 int, c15 int, c16 int, c17 int, c18 int, c19 int, c20 int, c21 int); INSERT INTO intconvert (key,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21) VALUES (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1); CREATE TABLE smallintconvert ( key int PRIMARY KEY, c1 smallint, c2 smallint, c3 smallint, c4 smallint, c5 smallint, c6 smallint, c7 smallint, c8 smallint, c9 smallint, c10 smallint, c11 smallint, c12 smallint, c13 smallint, c14 smallint, c15 smallint, c16 smallint, c17 smallint, c18 smallint, c19 smallint, c20 smallint, c21 smallint); INSERT INTO smallintconvert (key,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21) VALUES (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1); CREATE TABLE textconvert ( key int PRIMARY KEY, c1 text, c2 text, c3 text, c4 text, c5 text, c6 text, c7 text, c8 text, c9 text, c10 text, c11 text, c12 text, c13 text, c14 text, c15 text, c16 text, c17 text, c18 text, c19 text, c20 text, c21 text); INSERT INTO textconvert (key,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21) VALUES (1,'1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1'); CREATE TABLE timestampconvert ( key int PRIMARY KEY, c1 timestamp, c2 timestamp, c3 timestamp, c4 timestamp, c5 timestamp, c6 timestamp, c7 timestamp, c8 timestamp, c9 timestamp, c10 timestamp, c11 timestamp, c12 timestamp, c13 timestamp, c14 timestamp, c15 timestamp, c16 timestamp, c17 timestamp, c18 timestamp, c19 timestamp, c20 timestamp, c21 timestamp); INSERT INTO timestampconvert (key,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21) VALUES (1,'2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08','2015-08-08'); CREATE TABLE timeuuidconvert ( key int PRIMARY KEY, c1 timeuuid, c2 timeuuid, c3 timeuuid, c4 timeuuid, c5 timeuuid, c6 timeuuid, c7 timeuuid, c8 timeuuid, c9 timeuuid, c10 timeuuid, c11 timeuuid, c12 timeuuid, c13 timeuuid, c14 timeuuid, c15 timeuuid, c16 timeuuid, c17 timeuuid, c18 timeuuid, c19 timeuuid, c20 timeuuid, c21 timeuuid); INSERT INTO timeuuidconvert (key,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21) VALUES (1,mintimeuuid('2015-08-08'),mintimeuuid('2015-08-08'),mintimeuuid('2015-08-08'),mintimeuuid('2015-08-08'),mintimeuuid('2015-08-08'),mintimeuuid('2015-08-08'),mintimeuuid('2015-08-08'),mintimeuuid('2015-08-08'),mintimeuuid('2015-08-08'),mintimeuuid('2015-08-08'),mintimeuuid('2015-08-08'),mintimeuuid('2015-08-08'),mintimeuuid('2015-08-08'),mintimeuuid('2015-08-08'),mintimeuuid('2015-08-08'),mintimeuuid('2015-08-08'),mintimeuuid('2015-08-08'),mintimeuuid('2015-08-08'),mintimeuuid('2015-08-08'),mintimeuuid('2015-08-08'),mintimeuuid('2015-08-08')); CREATE TABLE tinyintconvert ( key int PRIMARY KEY, c1 tinyint, c2 tinyint, c3 tinyint, c4 tinyint, c5 tinyint, c6 tinyint, c7 tinyint, c8 tinyint, c9 tinyint, c10 tinyint, c11 tinyint, c12 tinyint, c13 tinyint, c14 tinyint, c15 tinyint, c16 tinyint, c17 tinyint, c18 tinyint, c19 tinyint, c20 tinyint, c21 tinyint); INSERT INTO tinyintconvert (key,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21) VALUES (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1); CREATE TABLE uuidconvert ( key int PRIMARY KEY, c1 uuid, c2 uuid, c3 uuid, c4 uuid, c5 uuid, c6 uuid, c7 uuid, c8 uuid, c9 uuid, c10 uuid, c11 uuid, c12 uuid, c13 uuid, c14 uuid, c15 uuid, c16 uuid, c17 uuid, c18 uuid, c19 uuid, c20 uuid, c21 uuid); INSERT INTO uuidconvert (key,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21) VALUES (1,uuid(),uuid(),uuid(),uuid(),uuid(),uuid(),uuid(),uuid(),uuid(),uuid(),uuid(),uuid(),uuid(),uuid(),uuid(),uuid(),uuid(),uuid(),uuid(),uuid(),uuid()); CREATE TABLE varcharconvert ( key int PRIMARY KEY, c1 varchar, c2 varchar, c3 varchar, c4 varchar, c5 varchar, c6 varchar, c7 varchar, c8 varchar, c9 varchar, c10 varchar, c11 varchar, c12 varchar, c13 varchar, c14 varchar, c15 varchar, c16 varchar, c17 varchar, c18 varchar, c19 varchar, c20 varchar, c21 varchar); INSERT INTO varcharconvert (key,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21) VALUES (1,'1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1'); CREATE TABLE varintconvert ( key int PRIMARY KEY, c1 varint, c2 varint, c3 varint, c4 varint, c5 varint, c6 varint, c7 varint, c8 varint, c9 varint, c10 varint, c11 varint, c12 varint, c13 varint, c14 varint, c15 varint, c16 varint, c17 varint, c18 varint, c19 varint, c20 varint, c21 varint); INSERT INTO varintconvert (key,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21) VALUES (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1);