Skip to content

Instantly share code, notes, and snippets.

@mwinkle

mwinkle/python_processing.sql

Last active August 29, 2015 14:17
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 mwinkle/6ce567f29d7923b72f16 to your computer and use it in GitHub Desktop.
Save mwinkle/6ce567f29d7923b72f16 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
python_processing.sql
# assumes table is my_json, with one column containing all of the json body
add file wasb:///example/apps/process_json.py;
SELECT transform(json_body)
USING 'd:\python27\python.exe process_json.py'
AS id, lessonbranch, elapsedseconds, activity, the_date
FROM my_json;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment