Creating Tables DDL

Name

create external table name_essential_v1 (
  awards array<
    struct<
      awardName:string,
      awardNominationId:string,
      category:string,
      event:string,
      titles:array<
        string
      >,
      winner:boolean,
      year:bigint
    >
  >,
  death struct<
    deathCause:string,
    deathDate:string,
    deathLocation:string,
    deathStatus:string
  >,
  filmography array<
    struct<
      attributes:array<
        string
      >,
      billing:bigint,
      category:string,
      jobs:array<
        string
      >,
      roles:array<
        string
      >,
      titleId:string
    >
  >,
  imdbUrl string,
  knownFor array<
    struct<
      category:string,
      titleId:string
    >
  >,
  name string,
  nameId string,
  remappedTo string,
  trademarks array<
    string
  >
)
row format serde 'org.openx.data.jsonserde.JsonSerDe'
location 's3://S3-BUCKET/S3-KEY/'

Title

create external table title_essential_v2 (
  akas array<
    struct<
      country:string,
      language:string,
      title:string
    >
  >,
  awards array<
    struct<
      awardName:string,
      awardNominationId:string,
      category:string,
      event:string,
      names:array<
        string
      >,
      winner:boolean,
      year:bigint
    >
  >,
  certificates array<
    struct<
      attributes:array<
        string
      >,
      country:string,
      rating:string,
      ratingsBody:string,
      reason:string
    >
  >,
  color array<
    string
  >,
  companies struct<
    distribution:array<
      struct<
        company:struct<
          country:string,
          id:string,
          name:string
        >,
        countries:array<
          string
        >,
        endYear:bigint,
        formats:array<
          string
        >,
        isUncredited:boolean,
        startYear:bigint
      >
    >,
    miscellaneous:array<
      struct<
        company:struct<
          country:string,
          id:string,
          name:string
        >
      >
    >,
    production:array<
      struct<
        company:struct<
          country:string,
          id:string,
          name:string
        >,
        isUncredited:boolean
      >
    >,
    specialEffects:array<
      struct<
        company:struct<
          country:string,
          id:string,
          name:string
        >
      >
    >
  >,
  countries array<
    string
  >,
  creditsByCategory array<
    struct<
      category:string,
      credits:array<
        struct<
          attributes:array<
            string
          >,
          billing:bigint,
          category:string,
          creditedAs:string,
          jobs:array<
            string
          >,
          nameId:string,
          roles:array<
            string
          >
        >
      >
    >
  >,
  episodeInfo struct<
    episodeNumber:bigint,
    seasonNumber:bigint,
    seriesTitleId:string
  >,
  genres array<
    string
  >,
  image struct<
    height:bigint,
    id:string,
    url:string,
    width:bigint
  >,
  imdbRating struct<
    numberOfVotes:bigint,
    rating:double
  >,
  imdbUrl string,
  isAdult boolean,
  keywords array<
    struct<
      category:string,
      keyword:string,
      votes:struct<
        down:bigint,
        up:bigint
      >
    >
  >,
  languages array<
    string
  >,
  locations array<
    struct<
      interestScore:struct<
        usersInterested:bigint,
        usersVoted:bigint
      >,
      place:string,
      scenes:array<
        string
      >
    >
  >,
  movieConnections array<
    struct<
      text:string,
      titleId:string,
      type:string
    >
  >,
  officialSiteLinks array<
    struct<
      linkTitle:string,
      url:string
    >
  >,
  originalTitle string,
  plot string,
  plotLong string,
  plotMedium string,
  plotShort string,
  principalCastMembers array<
    struct<
      attributes:array<
        string
      >,
      billing:bigint,
      category:string,
      creditedAs:string,
      nameId:string,
      roles:array<
        string
      >
    >
  >,
  principalCrewMembers array<
    struct<
      attributes:array<
        string
      >,
      category:string,
      creditedAs:string,
      job:string,
      nameId:string
    >
  >,
  productionStatus array<
    struct<
      date:string,
      status:string
    >
  >,
  releaseDates array<
    struct<
      country:string,
      date:string
    >
  >,
  remappedTo string,
  runtimeMinutes bigint,
  seriesInfo struct<
    endYear:bigint,
    episodeTitleIds:array<
      string
    >,
    startYear:bigint
  >,
  taglines array<
    string
  >,
  titleDisplay array<
    struct<
      country:string,
      language:string,
      title:string
    >
  >,
  titleId string,
  titleType string,
  year bigint
)
row format serde 'org.openx.data.jsonserde.JsonSerDe'
location 's3://S3-BUCKET/S3-KEY/'

STARmeter

create external table star_meter_v1 (
      nameId string,
      date string,
      rank bigint
)
row format serde 'org.openx.data.jsonserde.JsonSerDe'
location 's3://S3-BUCKET/S3-KEY/'

TITLEmeter

create external table title_meter_v1 (
      titleId string,
      date string,
      rank bigint
)
row format serde 'org.openx.data.jsonserde.JsonSerDe'
location 's3://S3-BUCKET/S3-KEY/'

TVmeter

create external table tv_meter_v1 (
      titleId string,
      date string,
      rank bigint
)
row format serde 'org.openx.data.jsonserde.JsonSerDe'
location 's3://S3-BUCKET/S3-KEY/'

MOVIEmeter

create external table movie_meter_v1 (
      titleId string,
      date string,
      rank bigint
)
row format serde 'org.openx.data.jsonserde.JsonSerDe'
location 's3://S3-BUCKET/S3-KEY/'