Why not INSERT INTO for appending new records? a)load the new records into a staging table b)INSERT INTO final table from the staging table On 10-Feb-2014 8:16 am, "Raj Hadoop" <hadoop...@yahoo.com> wrote:
> > > Hi, > > My requirement is a typical Datawarehouse and ETL requirement. I need to > accomplish > > 1) Daily Insert transaction records to a Hive table or a HDFS file. This > table or file is not a big table ( approximately 10 records per day). I > don't want to Partition the table / file. > > > I am reading a few articles on this. It was being mentioned that we need > to load to a staging table in Hive. And then insert like the below : > > insert overwrite table finaltable select * from staging; > > I am not getting this logic. How should I populate the staging table daily. > > Thanks, > Raj > > >