@Johnny Fugers From what I understand is that you have set of files inside a hdfs directory which is split by dates, would the directory structure look like this: /user/test/data/2016-03-12/<FILES> /user/test/data/2016-03-13/<FILES> /user/test/data/2016-03-14/<FILES> Like these, if yes then you will not be able to create a partition based table, what you can do is to create a regular table pointing the location to /user/test/data and set the below properties, this will look at all the files inside the subdirectory and get the result set. set hive.input.dir.recursive=true; set hive.mapred.supports.subdirectories=true; set hive.supports.subdirectories=true;
set mapreduce.input.fileinputformat.input.dir.recursive=true;
... View more
