Create Hive table on top of nested directories [Merge with sth else] - ignacio-alorre/Hive GitHub Wiki

Use this Hive settings to enable recursive directories:

set hive.mapred.supports.subdirectories=TRUE;
set mapred.input.dir.recursive=TRUE;

Create external table and specify root directory as a location:

LOCATION 'hdfs://.../data'