REGISTER /usr/hdp/current/pig-client/piggybank.jar;


lifes = LOAD 'labs/hadoop/pig/Life_Expectancy_Data.csv' USING org.apache.pig.piggybank.storage.CSVExcelStorage() as (
country:chararray,
year:int,
status:chararray,
life_expectancy:double,
adult_mortality:int,
infant_deaths:int,
alcohol:double,
percentage_expenditure:double,
hepatitis_b:int,
measles:int,
BMI:double,
under_five_deaths:int,
polio:int,
total_expenditure:double,
diphtheria:int,
HIV_AIDS:double,
GDP:double,
Population:int,
thinness_1_19_years:double,
thinness_5_9_years:double,
income_composition_of_resources:double,
schooling:double);

ranked_lifes = RANK lifes;


res = ORDER ranked_lifes BY life_expectancy DESC;
res = LIMIT res 3;

DUMP res;