You try to load an xls file with a CSV loader. Convert *Country-Code.xlsx* to *Country-Code.csv* and then load it.
@*JB*Δ <http://jbigdata.fr/jbigdata/index.html> Le lun. 20 juil. 2020 à 13:44, Raghavendra Pai <rvpai...@rediffmail.com.invalid> a écrit : > Hi Sir, > I am stuck and not able to proceed in loading attached file > country-code.xlsx file using following command: > > > *country_data_load = LOAD > '/user/rvpai427385/Pig_Labs/Zomato_Analysis/Country-Code.xlsx' using > org.apache.pig.piggybank.storage.CSVExcelStorage(',', 'NO_MULTILINE', > 'NOCHANGE', 'SKIP_INPUT_HEADER');dump country_data_load;* > > It should load only 12 rows consisting of 12 country codes and 12 country > names but that is not happening. > It is loading junk data and not the 12 country data which we want. > Can you please check below command and advise ? > > > > > >> > > >
