Details
Description
e..g. After typing "business_group = GROUP", it would be great if the autocomplete was proposing "business".
business =
LOAD '/user/hive/warehouse/business/yelp_academic_dataset_business_clean.json'
AS (business_id: CHARARRAY, categories: CHARARRAY, city: CHARARRAY, full_address: CHARARRAY,
latitude: FLOAT, longitude: FLOAT, name: CHARARRAY, neighborhoods: CHARARRAY,
open: BOOLEAN, review_count: INT, stars: FLOAT, state: CHARARRAY, type: CHARARRAY);
business_group =
GROUP business
BY city;
business_by_city =
FOREACH business_group
GENERATE group, COUNT(business) AS ct;
top =
ORDER business_by_city
BY ct DESC;
top_25 = LIMIT top 25;
DUMP top_25;