SET mapred.output.compression.codec=org.apache.hadoop.io.compress.GzipCodec;
SET hive.EXEC.compress.output=TRUE;

INSERT OVERWRITE TABLE copy_of_original_table_new (dt)
SELECT
  p.dt AS fact_date_do_not_use,
  install_id,
  icecream_flavour_id,
  app_id,
  millisecond_ts,
  substr(transaction_id, 256),
  tranx_type,
  tranx_subtype,
  market,
  currency_local,
  spend_local,
  spend_usd,
  spend_usd_pl,
  millisecond_client,
  user_id,
  geographical_coords,
  dt
FROM m_purchases p
  LEFT OUTER JOINs
.....
WHERE p.dt BETWEEN'2013-04-01' AND '2013-04-30';