title: Creating Impala external table from a partitioned file structure
body: <p>Provided a partitioned fs structure like the following:</p>
  
  <pre><code>logs
  └── log_type
      └── 2013
          ├── 07
          │   ├── 28
          │   │   ├── host1
          │   │   │   └── log_file_1.csv
          │   │   └── host2
          │   │       ├── log_file_1.csv
          │   │       └── log_file_2.csv
          │   └── 29
          │       ├── host1
          │       │   └── log_file_1.csv
          │       └── host2
          │           └── log_file_1.csv
          └── 08
  </code></pre>
  
  <p>I've been trying to create an external table in Impala:</p>
  
  <pre><code>create external table log_type (
      field1    string,
      field2    string,
      ...
  )
  row format delimited fields terminated by '|' location '/logs/log_type/2013/08';
  </code></pre>
  
  <p>I wish Impala would recurse into the subdirs and load all the csv files; but no cigar.
  No errors are thrown but no data is loaded into the table.</p>
  
  <p>Different globs like <code>/logs/log_type/2013/08/*/*</code>  or <code>/logs/log_type/2013/08/*/*/*</code> did not work either.</p>
  
  <p>Is there a way to do this?  Or should I restructure the fs - any advice on that?</p>