tree 2d2d91d6c98d0a43b549f44d4fb27c3db1a95d26
parent 1ccfb9be3fab8dfc2556541872632471d733518a
author akashrn5 <akashnilugal@gmail.com> 1590691105 +0530
committer QiangCai <qiangcai@qq.com> 1598425977 +0800

[CARBONDATA-3929] Improve CDC performance

Why is this PR needed?
This PR is to improve the CDC merge performance. CDC is currently very slow in the case of full outer joins and slow in normal cases. Identified pain points are as below:
1. currently we are writing the intermediate delete data to carbon format, which is the columnar format, and we do a full scan which is slow. Here since intermediate, we do full scan, compression, columnar format, its all-time taking.
2. Full outer join case is very slow.
3. when we insert new data into new segments, we follow the old insert flow with the converter step.
4. since we write the intermediate data carbon format, we use coalesce to limit the partition to number of active executors.

What changes were proposed in this PR?
Some improvements points are identified as below
1. Write the intermediate data to a faster row format like Avro.
2. use bucketing on join column and do the repartition of the Dataframe before performing the join operation, which avoids the shuffle on one side as shuffle is major time consuming part in join.
3. make the insert flow to the new flow without the converter step.
4. remove coalesce and can use resource to write the intermediate Avro data in a faster way.

Performance results
DataSize -> 2GB target table data
230MB source table data
InnerJoin case - around 17000+ deleted rows, 70400 odd updated rows
Full outer Join case - 2million target data, 0.2million src data, 70400 odd rows updated and some deleted
                Old Time(sec)		        New Time(sec)
Join Type	1st time query	2nd time query	1st time query	2nd time query
Inner Join	20      	9.6     	14      	4.6
Full Outer Join	43      	17.8    	26      	7.7

Does this PR introduce any user interface change?
No

Is any new testcase added?
Yes

This closes #3856