CREATE TABLE default.factdailyuser3 (
  date STRING, 
  userid BIGINT, 
  clusterid INT, 
  mainsegmentid BIGINT, 
  isregistrationday BOOLEAN, 
  ismadefirstactivity BOOLEAN, 
  sessionscount INT, 
  totalsessionsduration BIGINT, 
  firstsessiontime STRING, 
  lastsessiontime STRING, 
  startlevel INT, 
  endlevel INT, 
  isfirstdeposit BOOLEAN, 
  isdepositor BOOLEAN, 
  depositscount INT, 
  depositsamountusdnetbeforetax DOUBLE, 
  depositsamountusdgross DOUBLE, 
  refundscount INT, 
  refundsamountusdnet DOUBLE, 
  refundsamountusdgross DOUBLE, 
  depositsgoldtotal INT, 
  depositsgoldbonus INT, 
  isclanchange BOOLEAN, 
  startbalancegold INT, 
  startbalancemoney INT, 
  startbalanceuranium INT, 
  startbalancetitanite INT, 
  startbalancebiochips INT, 
  startbalanceblackcrystals INT, 
  startexperiencepoints BIGINT, 
  endbalancegold INT, 
  endbalancemoney INT, 
  endbalanceuranium INT, 
  endbalancetitanite INT, 
  endbalancebiochips INT, 
  endbalanceblackcrystals INT, 
  endexperiencepoints BIGINT, 
  spentgold INT, 
  spentmoney INT, 
  spenturanium INT, 
  spenttitanite INT, 
  spentbiochips INT, 
  spentblackcrystals INT, 
  spentusd DOUBLE, 
  totalbonusgold INT, 
  totalbonusblackcrystals INT, 
  purchasesgoldcount INT, 
  purchasesgoldquantity INT, 
  purchasesnongoldcount INT, 
  purchasesnongoldquantity INT, 
  purchasesworthusd DOUBLE, 
  purchasesoffencepower BIGINT, 
  purchasesdefencepower BIGINT, 
  battlewoncount INT, 
  battlelostcount INT, 
  battlerewardresourcesusd DOUBLE, 
  battleunitslossesusd DOUBLE, 
  battlerewardunitsusd DOUBLE, 
  gmcollectedobjects BIGINT, 
  invitedfriendscount INT, 
  sendfreegiftscount INT, 
  receivedfreegiftscount INT, 
  returnfreegiftscount INT, 
  acceptedfreegiftscount INT, 
  freegiftsreceivedmoney INT, 
  freegiftsreceiveduranium INT, 
  freegiftsreceivedtitanium INT, 
  freegiftsresourceworthusd DOUBLE, 
  freegiftsbonusworthusd DOUBLE, 
  freegiftsbonuscount INT, 
  useraccountgenericid STRING, 
  vippoints INT, 
  viplevel INT, 
  isvipstatusactive BOOLEAN, 
  loyaltyplanday INT, 
  dailyquestsrewardid BIGINT, 
  dailyindividualquestscount INT, 
  dailyalliancequestscount INT, 
  dailyvipquestscount INT, 
  clanid BIGINT, 
  dayssincelastsession INT, 
  clanroleid INT, 
  totaloffensepower INT, 
  totaldefensepower INT, 
  productiontitanium INT, 
  productionuranium INT, 
  productionmoney INT, 
  unitsconsumption INT, 
  depositsamountusdnetbeforetaxusingdayrate DOUBLE, 
  depositsamountusdgrossusingdayrate DOUBLE, 
  chargebackscount INT, 
  chargebacksamountusdnet DOUBLE, 
  chargebacksamountusdgross DOUBLE, 
  dayinarow INT, 
  depositsamountusdnet DOUBLE, 
  depositsamountusdnetusingdayrate DOUBLE
)
 COMMENT 'Imported by sqoop on 2015/02/09 21:08:40'
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\u0001' LINES TERMINATED BY '\n'
WITH SERDEPROPERTIES ('line.delim'='\n', 'field.delim'='\u0001', 'serialization.format'='\u0001')
STORED AS TEXTFILE
LOCATION 'hdfs://master:8020/user/hive/warehouse/factdailyuser3'
TBLPROPERTIES ('numFiles'='10', 'COLUMN_STATS_ACCURATE'='true', 'transient_lastDdlTime'='1423508932', 'numRows'='0', 'totalSize'='1102792030085', 'rawDataSize'='0')


CREATE TABLE dwh.factdailyuser (
  date TIMESTAMP, 
  userid BIGINT, 
  clusterid INT, 
  mainsegmentid BIGINT, 
  isregistrationday BOOLEAN, 
  ismadefirstactivity BOOLEAN, 
  sessionscount INT, 
  totalsessionsduration BIGINT, 
  firstsessiontime TIMESTAMP, 
  lastsessiontime TIMESTAMP, 
  startlevel INT, 
  endlevel INT, 
  isfirstdeposit BOOLEAN, 
  isdepositor BOOLEAN, 
  depositscount INT, 
  depositsamountusdnetbeforetax DOUBLE, 
  depositsamountusdgross DOUBLE, 
  refundscount INT, 
  refundsamountusdnet DOUBLE, 
  refundsamountusdgross DOUBLE, 
  depositsgoldtotal INT, 
  depositsgoldbonus INT, 
  isclanchange BOOLEAN, 
  startbalancegold INT, 
  startbalancemoney INT, 
  startbalanceuranium INT, 
  startbalancetitanite INT, 
  startbalancebiochips INT, 
  startbalanceblackcrystals INT, 
  startexperiencepoints BIGINT, 
  endbalancegold INT, 
  endbalancemoney INT, 
  endbalanceuranium INT, 
  endbalancetitanite INT, 
  endbalancebiochips INT, 
  endbalanceblackcrystals INT, 
  endexperiencepoints BIGINT, 
  spentgold INT, 
  spentmoney INT, 
  spenturanium INT, 
  spenttitanite INT, 
  spentbiochips INT, 
  spentblackcrystals INT, 
  spentusd DOUBLE, 
  totalbonusgold INT, 
  totalbonusblackcrystals INT, 
  purchasesgoldcount INT, 
  purchasesgoldquantity INT, 
  purchasesnongoldcount INT, 
  purchasesnongoldquantity INT, 
  purchasesworthusd DOUBLE, 
  purchasesoffencepower BIGINT, 
  purchasesdefencepower BIGINT, 
  battlewoncount INT, 
  battlelostcount INT, 
  battlerewardresourcesusd DOUBLE, 
  battleunitslossesusd DOUBLE, 
  battlerewardunitsusd DOUBLE, 
  gmcollectedobjects BIGINT, 
  invitedfriendscount INT, 
  sendfreegiftscount INT, 
  receivedfreegiftscount INT, 
  returnfreegiftscount INT, 
  acceptedfreegiftscount INT, 
  freegiftsreceivedmoney INT, 
  freegiftsreceiveduranium INT, 
  freegiftsreceivedtitanium INT, 
  freegiftsresourceworthusd DOUBLE, 
  freegiftsbonusworthusd DOUBLE, 
  freegiftsbonuscount INT, 
  useraccountgenericid STRING, 
  vippoints INT, 
  viplevel INT, 
  isvipstatusactive BOOLEAN, 
  loyaltyplanday INT, 
  dailyquestsrewardid BIGINT, 
  dailyindividualquestscount INT, 
  dailyalliancequestscount INT, 
  dailyvipquestscount INT, 
  clanid BIGINT, 
  dayssincelastsession INT, 
  clanroleid INT, 
  totaloffensepower INT, 
  totaldefensepower INT, 
  productiontitanium INT, 
  productionuranium INT, 
  productionmoney INT, 
  unitsconsumption INT, 
  depositsamountusdnetbeforetaxusingdayrate DOUBLE, 
  depositsamountusdgrossusingdayrate DOUBLE, 
  chargebackscount INT, 
  chargebacksamountusdnet DOUBLE, 
  chargebacksamountusdgross DOUBLE, 
  dayinarow INT, 
  depositsamountusdnet DOUBLE, 
  depositsamountusdnetusingdayrate DOUBLE
)
PARTITIONED BY (
  dt STRING
)
STORED AS PARQUET
LOCATION 'hdfs://master:8020/user/hive/warehouse/dwh.db/factdailyuser'
TBLPROPERTIES ('transient_lastDdlTime'='1423759482')