title: External Table in Hive - Location
body: <p>The below table returns no data while running a select statement</p>
  
  <pre><code>CREATE EXTERNAL TABLE foo (
  )
  ROW FORMAT DELIMITED
  FIELDS TERMINATED BY '\073'
  LINES TERMINATED BY '\n'
  LOCATION '/user/data/CSV/2016/1/27/*/part-*';
  </code></pre>
  
  <p>I need my hive to point to a dynamic folder so as a mapreduce job puts a part file in a folder and hive loads into the table.</p>
  
  <p>Is there any way the location be made dynamic like </p>
  
  <pre><code>/user/data/CSV/*/*/*/*/part-*
  </code></pre>
  
  <p>or just <code>/user/data/CSV/*</code> would do fine ? </p>
  
  <p>(The same code works fine when created as internal table and loaded with the file path - hence there is no issues due to formatting)</p>