I have a folder full of logs aggregated by hour like so: logs/ > 20110812-070000 > 20110812-080000 > 20110812-090000 > 20110812-100000 > ... > 20110812-230000 > 20110813-000000 > 20110813-010000 > 20110813-020000 > 20110813-030000 > ... >
Is there a way to selective include files files into an EXTERNAL TABLE using regex/symlink WITHOUT copying/moving files or altering the layout of the directory? Any suggestions appreciated.