Skip to content

Instantly share code, notes, and snippets.

@puyokw

puyokw/fm_test_exploded.sql

Created March 11, 2016 06:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save puyokw/3daf092213391cd73660 to your computer and use it in GitHub Desktop.
Save puyokw/3daf092213391cd73660 to your computer and use it in GitHub Desktop.
Download ZIP
td_intern criteo
Raw
fm_test_exploded.sql
INSERT OVERWRITE TABLE fm_test_exploded
select
rowid,
extract_feature(fv) as feature,
extract_weight(fv) as Xi
from
fm_test t1 LATERAL VIEW explode(features) t2 as fv;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment