title: Hive Table add partition to load all subdirectories
body: <p>I'm using hive (with external tables) to process data stored on amazon S3.</p>
  
  <p>My data is partitioned as follows:
  <code>group/team/dt/</code> (e.g., a data file may be stored in a path <code>group=myGroup/team=myTeam/dt=20120603</code>)</p>
  
  <p>I would like to process data for several teams (in different groups).
  Since RCOVER PARTITIONS takes a long time, I want to add multiple partitions based on group and team values to the hive table (i.e., given a group and team load data for all dates available in that team).</p>
  
  <p>The functionality I'm looking for is:</p>
  
  <pre class="lang-sql prettyprint-override"><code>CREATE EXTERNAL TABLE myData(
  attr1 string, attr2 string, attr3 string)
  PARTITIONED BY (group string, team string, dt string )
  ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
  LOCATION 's3://myBucket/${DATA_ROOT_DIR}'; 
  
  -- Add paritions without specifying values for dt
  ALTER TABLE myData ADD PARTITION (group='group1',team='team1') ; 
  ALTER TABLE myData ADD PARTITION (group='group2',team='team2') ;
  </code></pre>
  
  <p>Thanks!</p>