metabase_test_table.sql

CREATE EXTERNAL TABLE IF NOT EXISTS checkins (
    id int
    user_id int,
    venue_id int,
    date timestamp
    )
ROW FORMAT SERDE 
  'org.openx.data.jsonserde.JsonSerDe' 
LOCATION
  's3://YOUR_BUCKET/checkins'


CREATE EXTERNAL TABLE IF NOT EXISTS categories (
    id int,
    name string)
ROW FORMAT SERDE 
  'org.openx.data.jsonserde.JsonSerDe' 
LOCATION
  's3://YOUR_BUCKET/categories'


CREATE EXTERNAL TABLE IF NOT EXISTS users (
    id int,
    name string,
    last_login timestamp,
    password string)
ROW FORMAT SERDE 
  'org.openx.data.jsonserde.JsonSerDe' 
LOCATION
  's3://YOUR_BUCKET/users'

CREATE EXTERNAL TABLE IF NOT EXISTS venues (
    id int,
    name string,
    latitude float,
    longitude float,
    price int,
    category_id int)
ROW FORMAT SERDE 
  'org.openx.data.jsonserde.JsonSerDe' 
LOCATION
  's3://YOUR_BUCKET/venues'


CREATE EXTERNAL TABLE IF NOT EXISTS sightings (
    id int,
    city_id int,
    category_id int,
    timestamp bigint)
ROW FORMAT SERDE 
  'org.openx.data.jsonserde.JsonSerDe' 
LOCATION
  's3://YOUR_BUCKET/tupac/sightings'

CREATE EXTERNAL TABLE IF NOT EXISTS incidents (
    id int,
    severity int, 
    timestamp bigint)
ROW FORMAT SERDE 
  'org.openx.data.jsonserde.JsonSerDe' 
LOCATION
  's3://YOUR_BUCKET/toucan/incidents'


CREATE EXTERNAL TABLE IF NOT EXISTS urls (
    id int,
    url string)
ROW FORMAT SERDE 
  'org.openx.data.jsonserde.JsonSerDe' 
LOCATION
  's3://YOUR_BUCKET/urls'


CREATE EXTERNAL TABLE IF NOT EXISTS places (
    id int,
    liked boolean,
    name string)
ROW FORMAT SERDE 
  'org.openx.data.jsonserde.JsonSerDe' 
LOCATION
  's3://YOUR_BUCKET/places'

CREATE EXTERNAL TABLE IF NOT EXISTS cities (
    id int,
    name string,
    latitude float,
    longitude float)
ROW FORMAT SERDE 
  'org.openx.data.jsonserde.JsonSerDe' 
LOCATION
  's3://YOUR_BUCKET/tupac/cities'