title: Hive: Table creation with multi-files with multiple directories
body: <p>I want to create a Hive table where the input textfiles are traversed onto multiple sub-directories in hdfs.  So example I have in hdfs: </p>
  
  <pre><code>    /testdata/user/Jan/part-0001
      /testdata/user/Feb/part-0001
      /testdata/user/Mar/part-0001
  and so on...
  </code></pre>
  
  <p>If i want to create a table user in hive, but have it be able to traverse the sub-directories of user, can that be done?  I tried something like this, but doesn't work;</p>
  
  <pre><code>CREATE EXTERNAL TABLE users (id int, name string) 
  STORED AS TEXTFILE LOCATION '/testdata/user/*'  
  </code></pre>
  
  <p>I thought adding the wildcard would work but doesn't.  When I tried not using wildcard still does not work.  However, if I copy the files into the root directory of user, then it works.  Is there no way for Hive to traverse to the child-directories, and grab those files?</p>