Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
11 lines (6 sloc) 536 Bytes
-- funny, useful, cool,user_id, review_id, stars, text, date, type, business_id
reviews = load 'yelp_academic_dataset_review.json'
using JsonLoader('votes:map[],user_id:chararray,review_id:chararray,stars:int,date:chararray,text:chararray,type:chararray,business_id:chararray');
tabs = FOREACH reviews generate
(INT) votes#'funny', (INT) votes#'useful', (INT) votes#'cool', user_id, review_id, stars, REPLACE(REPLACE(text, '\n', ''), '\t', ''), date, type, business_id;
STORE tabs INTO 'yelp_academic_dataset_review.tsv';