I have thousands of Avro files in HDFS directories in the format of yyyy/mm/dd/. In each of these directories there may be 200-400 .avro files with data from that day.

When I create an EXTERNAL table, I think the LOCATION attribute assumes a single file... is there a way to point it at a directory of files and have it read all of them?