SHARE
TWEET

Untitled

a guest Nov 7th, 2013 97 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SET mapred.output.compression.codec=org.apache.hadoop.io.compress.GzipCodec;
  2. SET hive.EXEC.compress.output=TRUE;
  3.  
  4. INSERT OVERWRITE TABLE copy_of_original_table_new (dt)
  5. SELECT
  6.   p.dt AS fact_date_do_not_use,
  7.   install_id,
  8.   icecream_flavour_id,
  9.   app_id,
  10.   millisecond_ts,
  11.   substr(transaction_id, 256),
  12.   tranx_type,
  13.   tranx_subtype,
  14.   market,
  15.   currency_local,
  16.   spend_local,
  17.   spend_usd,
  18.   spend_usd_pl,
  19.   millisecond_client,
  20.   user_id,
  21.   geographical_coords,
  22.   dt
  23. FROM m_purchases p
  24.   LEFT OUTER JOINs
  25. .....
  26. WHERE p.dt BETWEEN'2013-04-01' AND '2013-04-30';
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top