If those files are all the same format, you would point the Hive table to the parent directory. It will resource through and find all of the files to include on the table.
You can filter files to use multiple tables, but recursion is designed in. Sent from my gadget. Please excuse any spelling errors. > On May 14, 2014, at 7:31 AM, "Matouk IFTISSEN" <matouk.iftis...@ysance.com> > wrote: > > Hé Geeks, > Is there a best manner to load or read data in hive table (normal or > external) from plural subdirectories? > exemple : I have a directory my_directory and in there are lot of > subdirectory ie: > my_directory --> my_subdirectory1 , my_subdirectory2, ..., my_subdirectoryx > and my data (files) are in those subdirectories!!!, how can I read them with > one/two Hive tables ? > > Thanks by advance > -- > Matouk IFTISSEN | Consultant BI & Big Data > > 24 rue du sentier - 75002 Paris - www.ysance.com > Fax : +33 1 73 72 97 26 > Ysance sur :Twitter | Facebook | Google+ | LinkedIn | Newsletter > Nos autres sites : ys4you | labdecisionnel | decrypt