As reported in the case TS001233758, in AS 3.1.1 it takes about 50 minutes to load 21 mln rows from Oracle to Hadoop; in our test environment it took less time to load data from Hadoop to Oracle, but the process is still slow.
While working on this case, IBM informed that this behaviour is explained by the fact that AS is loading data in one thread, not in multiple threads, as could be expected with HDFS.
We suggest to implement data loading process which utilizes multiple threads (as opposed to single thread), so that the import and export operations from/to relational databases to/from Hadoop are performed faster.
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "firstname.lastname@example.org" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions