Hi, Bhanu Vasireddy [mailto:[EMAIL PROTECTED] wrote: > > I am having problem to load massive data into table . i have > around 750000 rows in the > source file in following format > > "asdf","1","this is my data" > "asdg","2","This is my data2" > > and here are my table definition and load command > > create table TERM_DETAILS( > term varchar(20) primary key, > ID integer not null, > details varchar(3000) default 'none') > > dataload table TERM_DETAILS IGNORE DUPLICATES infile 'terms.txt' > > > after executing above commands process is loading around > 400000 rows in 10 to 15 minutes and simply hanging. is anyone > successfully loaded millions of rows in MaxDB > table. > Yep, we did. I'm pretty sure your log is full. If the log is full (and DATALOAD is simply a mass insert where the kernel writes logs) the Loader waits until the log is backed up and then continues.
Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
