Hi Edward, All, Thanks for the quick reply!
We are using dynamic partitions - so unable to say to which partition each record goes. We dont have much control here. Is there any properties that can be set ? I'm a bit doubtful here - is it because of the lock acquired on the table ? Regards, Krishnan On Thu, Jan 24, 2013 at 8:22 PM, Edward Capriolo <edlinuxg...@gmail.com>wrote: > Partition the table and load the data into different partitions. That or > build the data outside he table and then use scripting to move the data in > using LOAD DATA INPATH or copying. > > > On Thu, Jan 24, 2013 at 9:44 AM, Krishnan K <kkrishna...@gmail.com> wrote: > >> Hi All, >> >> Could you please let me know what would happen if we try to load a table >> from 2 different sources at the same time ? >> >> I had tried this earlier and got an error for 1 load job and while the >> other job loaded the data successfully into the table.. >> >> I guess it was because of lock acquired on the table by the first load >> process. >> >> Is there anyway to handle this ? >> >> Please give your insights. >> >> Regards, >> Krishnan >> >> >> >
