Following this question and its answer I would like to know if this instruction are well performed for Cassandra 2.0, according that in this version the CLI and the comparator stuff is deprecated, as show in this link.
Table users: CREATE TABLE users (userID bigint, itemID bigint, value float, PRIMARY KEY (userID, itemID));
Table items: CREATE TABLE items (itemID bigint, userID bigint, value float, PRIMARY KEY (itemID, userID));
Table userIDs: CREATE TABLE userIDs (id bigint, userID bigint PRIMARY KEY(id, userID));
Table itemIDs: CREATE TABLE itemIDs (id bigint, itemID bigint PRIMARY KEY(id, itemID));
Thanks for your help!