The following statements create the input tables:
CREATE TABLE purchases_table ( userid VARCHAR, purchaseDate TIMESTAMP, purchaseId INTEGER, itemid INTEGER, numitem INTEGER, pricePerItem DOUBLE, sessionid INTEGER, partition key(userid) ); CREATE TABLE addToCart_table ( userid VARCHAR, addtocartDate TIMESTAMP, cartId int, itemid INTEGER, numitem INTEGER, pricePerItem DOUBLE, sessionid INTEGER, partition key(userid) ); CREATE table removeFromCart_table( userid VARCHAR, removefromcartDate TIMESTAMP, cartId INTEGER, itemid INTEGER, numitem INTEGER, pricePerItem DOUBLE, sessionid INTEGER, partition key(userid) ); CREATE table ItemViews_table( userid VARCHAR, viewDate TIMESTAMP, pricedisplayPerItem DOUBLE, sessionid INTEGER, partition key(userid) );