title: Hive: adding rows to existing table
body: <p>I plan to use hadoop and hive to solve the following problem:</p>
  
  <p>I have a stream of data, say of the form (timestamp, temperature) that represent measured temperature at the given timestamp. I need to compute some aggregates (e.g. max) on a daily basis. The aggregates need to be computed once each day (e.g. at midnight). </p>
  
  <p>I thought of loading the data somehow to hive, partitioning it by date. However, there is one problem - the data in the stream does not need to be ordered by timestamp, I receive delayed records: a record may arrive even couple of days later than it should. In this case, while generating the usual aggregates, I need to compute aggregates for the day containing that timestamp as well.</p>
  
  <p>Intuitively, I'd like to add the late record to the respective partition in the hive table. Is it possible to do this without reloading the whole partition? (and is it a costly operation to reload a partition?)</p>