Apache Pig version 0.12.1.2.1.7.0-784 I have data where one of the field doesn't have data like 2015,,08
2015,,09
2015,,11
2015,,04
2015,,05 Now i run the pig command like grunt> given_input = load '/pigtest/flightdelays/' using PigStorage(',') as (year,month,day);
grunt> ori = foreach given_input generate month;
grunt> illustrate ori;
generating error like : Caused by: java.lang.RuntimeException: No (valid) input data found! when i replace the loader with CSVExcelStorage like grunt> given_input = load '/pigtest/flightdelays/' using org.apache.pig.piggybank.storage.CSVExcelStorage(',') as (year,month,day);
grunt> ori = foreach given_input generate month;
grunt> illustrate ori; getting output like -------------------------------------------------------------------------------
| given_input | year:bytearray | month:bytearray | day:bytearray |
-------------------------------------------------------------------------------
| | 2015 | | 05 |
-------------------------------------------------------------------------------
--------------------------------
| ori | month:bytearray |
--------------------------------
| | |
-------------------------------- So,I would like to know 1)What is the problem with Pigstorage. 2)Is it loader problem or pig version problem. 3)If i want to use PigStoarage in this,How is should??? Not only illustrate even dump behaves the same.
... View more
