title: Refresh hive tables in Hive
body: <p>I have few tables in Hive, every day new csv file will be adding to the hive table location. When a new data is available i need to refresh the tables so that i can see new data in the tables.</p>
  
  <p>steps we follow to load the data: </p>
  
  <ul>
  <li>first create a table with csv serde properties </li>
  <li>create another table with parquet table to do in production</li>
  <li>insert the data from first table to second table.</li>
  </ul>
  
  <p>Initial:</p>
  
  <p>1,a </p>
  
  <p>2,b</p>
  
  <p>3,c</p>
  
  <p>New file:</p>
  
  <p>4,d</p>
  
  <p>I searched in google and found this can be done via:</p>
  
  <p>1) incremental table, loading the new file in to incremental table and do insert statement. In my case we have more than 100 tables and so not want to create these many incremental tables</p>
  
  <p>2) Using refresh command via Impala shell.
  Our initial tables are stored as csv serde format. so when i do refresh on the initial tables i get an error impala does't support  serde propertied.</p>
  
  <p>Can you please provide a solution in my case.</p>