Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement