I have the output of pig that is partitioned based on date and customer segment(2 level of segments).
I wanted to load data into hive for a particular date. In load command if I point the INPATH location to date, I get error as "source contains directory". Could you suggest how to load the data from a partition directory.
I also tried creating an external table with the LOCATION as partition folder. The table was created but there were no data.
I wanted to do a LOAD since I wanted to remove the header and footer while loading.