On Wed, Mar 17, 2010 at 3:30 PM, Ryan LeCompte <[email protected]> wrote:
> Hello all, > > Is it possible in Hive 0.5 to run multiple inserts into the same Hive > table/partition? Or is this not supported due to the fact that Hadoop > doesn't support appends properly? > > For example, it would be nice to periodically add new data every 5 minutes > to a table that has a partition column for "date" via multiple periodic > INSERT statements. > > Thanks! > > Ryan > > Ryan, Every file inside the partition makes up the partiion. So with 'LOAD DATA INFILE (X)', if X is a unique name it will be "appended". This works for us since our 5 minute log files all have unique names . Edward
