title: Hive date based partitions
body: <p>I have data in the following form on HDFS:-</p>
  
  <pre><code>/basedir/yyyymmdd/fixedname/files
  </code></pre>
  
  <p>Where the yyyymmdd is the date folder and files are the list of files added in the directory. I need a table in hive to pick up data from yyyymmdd/fixedname directory. This should also work when i added a new date. e.g. i add something on 5th March 2013 so all files added on that day would go to 20130305/fixedname folder. On 6th March 2013, all files would go to 20130306/fixedname folder.</p>
  
  <p>How do i alter a hive table to pickup data from the changing date but fixed folder within it?</p>