amplab tables

amplab_tables.sql

create table rankings (
"pageURL" string primary key,
"pageRank" int,
"avgDuration" int
) clustered into 48 shards with (number_of_replicas=0, refresh_interval=0);

create table uservisits (
"sourceIP" string,
"destinationURL" string,
"visitDate" timestamp,
"adRevenue" float,
"UserAgent" string INDEX using fulltext,
"cCode" string,
"lCode" string,
"searchWord" string,
"duration" int
) clustered into 96 shards with (number_of_replicas = 0, refresh_interval = 0);