hawkeye

impression

CREATE TABLE impression_attribution (  
   clickId varchar PRIMARY KEY,
   timestamp timestamp,  
   date int,  
   time int,
   advertiserId int,
   appId int,
   platform varchar,
   packageName varchar,
   bundleId varchar,
   type int,
   cookieUserId varchar,
   domain varchar,
   uri varchar,
   pId varchar,
   pCampaignId varchar,
   pCampaignName varchar,
   pClickId varchar,
   pSiteId varchar,
   pSubSiteId varchar,
   pPackageName varchar,
   pAdName varchar,
   pAdId varchar,
   pAdType varchar,
   pChannel varchar,
   s2s Boolean,
   viewThroughLookBack int,
   clickThroughLookBack int,
   isRetargeting Boolean,
   reengagementWindow int,
   pCostModel varchar,
   pCostCurrency varchar,
   pCostValue double,
   extPDeeplink varchar,
   referrer varchar,
   gaid varchar,
   gaidSha1 varchar,
   gaidMD5 varchar,
   imei varchar,
   imeiSha1 varchar,
   imeiMD5 varchar,
   androidId varchar,
   androidIdSha1 varchar,
   androidIdMD5 varchar,
   oaid varchar,
   oaidSha1 varchar,
   oaidMD5 varchar,
   idfa varchar,
   idfaSha1 varchar,
   idfaMD5 varchar,
   idfv varchar,
   idfvSha1 varchar,
   idfvMD5 varchar,
   mac varchar,
   macSha1 varchar,
   macMD5 varchar,
   ip varchar,
   userAgent varchar,
   language varchar,
   headerIP list<varchar>,
   headerUserAgent varchar,
   headerLanguage varchar,
);