title: Issue creating Hive External table using tblproperties
body: <p>I am trying to create an external table with tblproperties in Hive. The table gets created but it does not display the rows. Any ideas? Please find the scripts i am using below:</p>
  
  <p>Thanks for your time and suggestions in advance.</p>
  
  <h2>Data is in a recursive folder: /user/test/test1/test2/samplefile.csv</h2>
  
  <pre><code>use dw_raw;
  drop table if exists temp_external_tab1;
  
  create external table if not exists temp_external_tab1 (
  col1 int,
  col2 string,
  col3 string,
  col4 string
  )
  row format delimited fields terminated by ','
  lines terminated by '\n'
  stored as textfile
  location '/user/test/test1/'
  tblproperties ("hive.input.dir.recursive" = "TRUE", 
      "hive.mapred.supports.subdirectories" = "TRUE",
      "hive.supports.subdirectories" = "TRUE", 
      "mapred.input.dir.recursive" = "TRUE");
  </code></pre>