Skip to content

Instantly share code, notes, and snippets.

@mfelsche

mfelsche/amplab_tables.sql

Created January 29, 2015 11:13
Show Gist options
  • Save mfelsche/c65d1303b47b1f2af8f2 to your computer and use it in GitHub Desktop.
Save mfelsche/c65d1303b47b1f2af8f2 to your computer and use it in GitHub Desktop.
Download ZIP
amplab tables
Raw
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);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment