CREATE TABLE aggregated_analytics
(
   download_activity_date           date encode lzo,
   download_accounting_month        date encode lzo,
   units                            integer encode lzo,
   paidunits                        integer encode lzo,
   freeunits                        integer encode lzo,
   is_royaltydollar_zero            boolean,
   royaltydollar_times_paidunits    numeric(20,6) encode lzo,
   country_name                     varchar(255) encode lzo,
   country_code                     varchar(2) encode lzo,
   continent                        varchar(32) encode lzo,
   continent_group                  varchar(12) encode lzo,
   continent_ordered                varchar(18) encode lzo,
   storeid                          integer encode lzo,
   store_name                       varchar(64) encode lzo,
   store_name_short                 varchar(64) encode lzo,
   store_group                      varchar(32) encode lzo,
   store_group_less                 varchar(32) encode lzo,
   store_musicbucket                varchar(32) encode lzo,
   store_videobucket                varchar(32) encode lzo,
   is_store_itunesusa               boolean,
   releaseid                        bigint encode lzo,
   release_name                     varchar(1000) encode lzo,
   release_releasedate              date encode lzo,
   release_sale_start_date          date encode lzo,
   release_sale_preorder_date       date encode lzo,
   release_sale_physical_date       date encode lzo,
   release_theatrical_release_date  date encode lzo,
   release_vod_sale_start_date      date encode lzo,
   release_priority                 varchar(10) encode lzo,
   release_version                  varchar(1000) encode lzo,
   release_new_or_catalog           varchar(16) encode lzo,
   release_is_itunes_previewable    boolean,
   release_is_compilation           boolean,
   release_is_deleted               boolean,
   release_is_digital_only          boolean,
   release_video_is_vod             boolean,
   release_video_channel            varchar(18) encode lzo,
   release_product_type             varchar(32) encode lzo,
   music_vs_video_by_product        varchar(32) encode lzo,
   release_genre                    varchar(32) encode lzo,
   release_genre_group              varchar(40) encode lzo,
   release_genre_group_less         varchar(40) encode lzo,
   labelid                          integer encode lzo,
   label_name                       varchar(100) encode lzo,
   label_priority                   integer encode lzo,
   label_ownerid                    integer encode lzo,
   label_owner                      varchar(10) encode lzo,
   label_is_distributor             varchar(3) encode lzo,
   label_is_red                     boolean,
   label_is_supplychain             boolean,
   label_sc_group                   varchar(10) encode lzo,
   label_is_ioda                    boolean,
   label_country                    varchar(255) encode lzo,
   label_continent                  varchar(32) encode lzo,
   artistid                         bigint encode lzo,
   artist_name                      varchar(1000) encode lzo,
   artist_country                   varchar(255) encode lzo,
   transac_typeid                   integer encode lzo,
   transac_type_abbr                varchar(4) encode lzo,
   transac_type                     varchar(255) encode lzo,
   transac_type_group               varchar(32) encode lzo,
   music_vs_video_by_transac        varchar(32) encode lzo,
   stream_vs_download               varchar(32) encode lzo,
   album_vs_track                   varchar(32) encode lzo,
   music_vs_video                   varchar(32) encode lzo,
   accounting_month_start           date encode lzo,
   accounting_month_end             date encode lzo,
   accounting_max_date_by_group     date encode lzo,
   accounting_days_in_month         numeric(22,9) encode lzo,
   accounting_days_present          numeric(22,9) encode lzo,
   accounting_days_missing          numeric(22,9) encode lzo,
   paidunits_expected_ratio         numeric(20,6) encode lzo,
   gpuest                           numeric(20,10) encode lzo,
   gest                             numeric(20,6) encode lzo,
   gestwithmargin                   numeric(20,6) encode lzo,
   gest_no_rd                       numeric(20,6) encode lzo,
   gestwithmargin_no_rd             numeric(20,6) encode lzo,
   music_vs_video_by_tracktype      varchar(32) encode lzo
) sortkey(download_activity_date);