http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/join/employee.csv
----------------------------------------------------------------------
diff --git a/integration/spark/src/test/resources/join/employee.csv 
b/integration/spark/src/test/resources/join/employee.csv
deleted file mode 100644
index c551653..0000000
--- a/integration/spark/src/test/resources/join/employee.csv
+++ /dev/null
@@ -1,1000 +0,0 @@
-empid695,empname595,mobile15,color2,102868
-empid147,empname160,mobile99,color7,108485
-empid69,empname72,mobile87,color9,102202
-empid324,empname147,mobile87,color1,101000
-empid215,empname752,mobile47,color5,109786
-empid171,empname309,mobile34,color8,105698
-empid714,empname845,mobile21,color1,103623
-empid566,empname978,mobile88,color3,107882
-empid561,empname391,mobile79,color0,107908
-empid219,empname962,mobile80,color8,105802
-empid755,empname234,mobile41,color5,103068
-empid125,empname305,mobile10,color4,101992
-empid751,empname165,mobile26,color0,108878
-empid864,empname646,mobile88,color8,109367
-empid981,empname273,mobile88,color5,108040
-empid957,empname752,mobile63,color9,105241
-empid292,empname709,mobile88,color0,101106
-empid500,empname846,mobile67,color6,101204
-empid187,empname513,mobile1,color7,105432
-empid11,empname1,mobile26,color8,102510
-empid59,empname837,mobile76,color1,103627
-empid700,empname535,mobile77,color0,108892
-empid558,empname30,mobile36,color5,101414
-empid584,empname29,mobile18,color9,105615
-empid811,empname447,mobile80,color1,106837
-empid285,empname650,mobile66,color1,103265
-empid262,empname521,mobile42,color5,105449
-empid594,empname581,mobile2,color2,109862
-empid232,empname227,mobile3,color4,103680
-empid766,empname279,mobile13,color4,102405
-empid903,empname682,mobile22,color8,103338
-empid648,empname347,mobile47,color5,10600
-empid323,empname330,mobile55,color8,10163
-empid418,empname799,mobile16,color4,108136
-empid863,empname185,mobile26,color2,105223
-empid145,empname365,mobile95,color4,101611
-empid897,empname997,mobile10,color3,10814
-empid180,empname946,mobile69,color4,109870
-empid419,empname981,mobile46,color8,105424
-empid610,empname354,mobile79,color3,102553
-empid840,empname796,mobile98,color4,109111
-empid735,empname881,mobile2,color1,106732
-empid1,empname628,mobile30,color0,109646
-empid235,empname717,mobile88,color7,101120
-empid374,empname922,mobile58,color2,105478
-empid145,empname10,mobile77,color7,107407
-empid289,empname377,mobile95,color6,106291
-empid812,empname164,mobile86,color6,10515
-empid876,empname974,mobile61,color9,106524
-empid820,empname862,mobile34,color5,106506
-empid372,empname379,mobile47,color8,106829
-empid337,empname52,mobile65,color6,107040
-empid656,empname420,mobile34,color0,104734
-empid665,empname384,mobile21,color2,106826
-empid78,empname321,mobile38,color6,109877
-empid639,empname346,mobile85,color6,109262
-empid640,empname810,mobile29,color0,104336
-empid985,empname188,mobile83,color8,101831
-empid665,empname900,mobile50,color9,10468
-empid298,empname264,mobile29,color5,105059
-empid154,empname655,mobile76,color7,101820
-empid329,empname385,mobile61,color6,109113
-empid223,empname973,mobile63,color8,101940
-empid540,empname962,mobile76,color1,101008
-empid745,empname221,mobile90,color3,10625
-empid665,empname828,mobile77,color9,10820
-empid424,empname422,mobile52,color2,103268
-empid484,empname788,mobile97,color9,108554
-empid889,empname159,mobile63,color1,104392
-empid353,empname11,mobile38,color3,105506
-empid636,empname93,mobile70,color4,102070
-empid9,empname754,mobile50,color5,103958
-empid11,empname670,mobile22,color6,107570
-empid248,empname931,mobile47,color1,102316
-empid520,empname146,mobile70,color6,106306
-empid2,empname27,mobile32,color9,103648
-empid629,empname790,mobile91,color8,102926
-empid27,empname911,mobile84,color1,104885
-empid405,empname601,mobile59,color8,105150
-empid291,empname747,mobile22,color5,106151
-empid553,empname277,mobile40,color5,102535
-empid927,empname125,mobile46,color0,106930
-empid527,empname595,mobile54,color5,109349
-empid334,empname732,mobile63,color0,109304
-empid965,empname459,mobile18,color4,102777
-empid3,empname38,mobile20,color5,102073
-empid865,empname839,mobile6,color7,101427
-empid579,empname704,mobile1,color0,101830
-empid979,empname756,mobile42,color3,107620
-empid956,empname18,mobile74,color5,102454
-empid821,empname126,mobile92,color3,102659
-empid845,empname862,mobile76,color0,10771
-empid550,empname827,mobile34,color1,107161
-empid350,empname110,mobile94,color0,103892
-empid433,empname140,mobile79,color4,10175
-empid851,empname214,mobile16,color5,103486
-empid813,empname817,mobile2,color2,103601
-empid20,empname604,mobile33,color3,105038
-empid638,empname298,mobile97,color2,104103
-empid936,empname522,mobile73,color0,109897
-empid780,empname939,mobile27,color6,10109
-empid613,empname876,mobile97,color7,107794
-empid641,empname105,mobile2,color7,10798
-empid928,empname20,mobile1,color3,106581
-empid798,empname841,mobile24,color4,108008
-empid787,empname564,mobile77,color4,109390
-empid596,empname417,mobile43,color8,104685
-empid767,empname166,mobile96,color0,106140
-empid799,empname915,mobile45,color4,101529
-empid313,empname657,mobile7,color8,106123
-empid695,empname23,mobile44,color1,105434
-empid575,empname434,mobile83,color7,108587
-empid142,empname398,mobile93,color8,107941
-empid720,empname513,mobile99,color5,106210
-empid984,empname973,mobile86,color5,109876
-empid53,empname806,mobile33,color6,104938
-empid783,empname420,mobile12,color7,109857
-empid286,empname583,mobile36,color5,108367
-empid594,empname235,mobile99,color4,109109
-empid145,empname147,mobile76,color6,105850
-empid358,empname570,mobile97,color8,10789
-empid476,empname986,mobile76,color7,104641
-empid417,empname347,mobile56,color2,108874
-empid361,empname627,mobile97,color5,106122
-empid400,empname610,mobile79,color3,105819
-empid322,empname179,mobile7,color6,106026
-empid643,empname986,mobile73,color8,101135
-empid473,empname500,mobile92,color0,106213
-empid779,empname665,mobile10,color6,105591
-empid761,empname993,mobile93,color6,108554
-empid138,empname683,mobile38,color2,105219
-empid208,empname701,mobile94,color1,10539
-empid871,empname179,mobile45,color8,10785
-empid868,empname546,mobile46,color5,106466
-empid15,empname413,mobile50,color2,108891
-empid658,empname556,mobile16,color3,104442
-empid644,empname274,mobile10,color1,109645
-empid28,empname960,mobile16,color0,109895
-empid544,empname685,mobile92,color0,101955
-empid638,empname242,mobile26,color5,101034
-empid98,empname446,mobile90,color1,104780
-empid167,empname853,mobile37,color0,106534
-empid818,empname86,mobile97,color2,103886
-empid147,empname804,mobile97,color9,108178
-empid359,empname934,mobile77,color5,109627
-empid692,empname149,mobile6,color2,105662
-empid746,empname780,mobile4,color3,103438
-empid868,empname63,mobile83,color0,109850
-empid434,empname508,mobile1,color9,103929
-empid406,empname959,mobile23,color9,109694
-empid700,empname809,mobile78,color2,107839
-empid828,empname926,mobile77,color6,102654
-empid647,empname455,mobile43,color0,105463
-empid91,empname711,mobile48,color7,104460
-empid959,empname231,mobile3,color9,10702
-empid360,empname403,mobile1,color1,101499
-empid84,empname986,mobile27,color7,109032
-empid431,empname387,mobile34,color3,102095
-empid816,empname435,mobile55,color9,10472
-empid784,empname240,mobile46,color6,107785
-empid408,empname386,mobile74,color5,108071
-empid130,empname400,mobile12,color8,102618
-empid338,empname979,mobile22,color5,102237
-empid642,empname401,mobile86,color2,102469
-empid299,empname397,mobile75,color2,106199
-empid834,empname808,mobile5,color1,108678
-empid408,empname918,mobile45,color9,105171
-empid763,empname208,mobile76,color3,102458
-empid985,empname205,mobile42,color4,106165
-empid758,empname354,mobile71,color3,105690
-empid481,empname929,mobile89,color7,109782
-empid154,empname531,mobile94,color9,106844
-empid32,empname107,mobile39,color4,10666
-empid289,empname383,mobile5,color6,104522
-empid994,empname595,mobile31,color9,102269
-empid324,empname654,mobile49,color5,109376
-empid600,empname801,mobile42,color0,106462
-empid15,empname468,mobile22,color3,107625
-empid9,empname14,mobile27,color0,10712
-empid653,empname313,mobile8,color2,104859
-empid690,empname840,mobile25,color9,102822
-empid871,empname217,mobile19,color3,103915
-empid173,empname37,mobile27,color1,109301
-empid209,empname183,mobile88,color7,104454
-empid73,empname304,mobile25,color2,102862
-empid333,empname836,mobile59,color7,107212
-empid467,empname605,mobile84,color7,107682
-empid423,empname402,mobile95,color0,10907
-empid85,empname62,mobile87,color1,104433
-empid619,empname387,mobile85,color5,108327
-empid540,empname636,mobile75,color9,101357
-empid15,empname429,mobile64,color0,10206
-empid759,empname711,mobile82,color9,103877
-empid211,empname93,mobile54,color0,102724
-empid658,empname462,mobile81,color5,103800
-empid280,empname888,mobile38,color5,101067
-empid695,empname651,mobile37,color7,101348
-empid844,empname43,mobile18,color5,107938
-empid913,empname559,mobile93,color1,109288
-empid480,empname962,mobile3,color7,108280
-empid537,empname349,mobile46,color5,109012
-empid542,empname712,mobile66,color3,106236
-empid402,empname819,mobile11,color9,109836
-empid377,empname190,mobile2,color2,1070
-empid198,empname647,mobile54,color3,103912
-empid59,empname978,mobile36,color8,107786
-empid859,empname496,mobile86,color5,107290
-empid836,empname812,mobile54,color6,106522
-empid702,empname618,mobile70,color6,109968
-empid293,empname740,mobile44,color2,109863
-empid634,empname365,mobile83,color9,106709
-empid157,empname802,mobile53,color2,107426
-empid827,empname466,mobile23,color2,101244
-empid814,empname809,mobile70,color1,107803
-empid416,empname52,mobile94,color4,107579
-empid827,empname615,mobile85,color6,106742
-empid48,empname208,mobile86,color9,107166
-empid856,empname535,mobile36,color4,107396
-empid586,empname474,mobile99,color1,108795
-empid330,empname949,mobile93,color0,103405
-empid105,empname986,mobile62,color0,102828
-empid89,empname726,mobile65,color6,103286
-empid411,empname824,mobile25,color2,103747
-empid103,empname873,mobile25,color3,102185
-empid212,empname373,mobile54,color8,108565
-empid194,empname195,mobile80,color9,107580
-empid806,empname634,mobile23,color5,104920
-empid39,empname767,mobile5,color1,103184
-empid853,empname699,mobile60,color9,102811
-empid980,empname806,mobile41,color3,103481
-empid430,empname436,mobile16,color2,10911
-empid325,empname334,mobile43,color6,103480
-empid576,empname119,mobile48,color5,109102
-empid536,empname524,mobile98,color4,102720
-empid472,empname613,mobile73,color9,108728
-empid166,empname326,mobile99,color7,107917
-empid223,empname188,mobile55,color6,104490
-empid122,empname306,mobile23,color2,102636
-empid536,empname523,mobile98,color2,106554
-empid906,empname769,mobile28,color4,108146
-empid460,empname853,mobile43,color0,104535
-empid985,empname159,mobile27,color1,1045
-empid505,empname654,mobile25,color3,102345
-empid417,empname85,mobile26,color3,102419
-empid328,empname592,mobile44,color0,107502
-empid125,empname212,mobile93,color6,103568
-empid633,empname377,mobile90,color5,106276
-empid439,empname197,mobile84,color9,108242
-empid9,empname484,mobile1,color7,109403
-empid445,empname514,mobile24,color1,102393
-empid208,empname378,mobile64,color2,104299
-empid766,empname750,mobile76,color1,108854
-empid514,empname618,mobile21,color8,105789
-empid61,empname320,mobile15,color0,104991
-empid489,empname843,mobile87,color4,108014
-empid134,empname29,mobile25,color0,109020
-empid756,empname200,mobile26,color2,101275
-empid753,empname872,mobile73,color8,106373
-empid448,empname241,mobile65,color1,103169
-empid484,empname395,mobile1,color8,104105
-empid218,empname967,mobile40,color6,10593
-empid792,empname181,mobile17,color9,102993
-empid452,empname970,mobile75,color3,102124
-empid236,empname170,mobile75,color6,105901
-empid811,empname854,mobile6,color2,105511
-empid927,empname604,mobile50,color5,106810
-empid158,empname660,mobile99,color1,103838
-empid828,empname142,mobile8,color7,108933
-empid489,empname215,mobile97,color1,103411
-empid400,empname459,mobile4,color5,104995
-empid231,empname160,mobile54,color4,108849
-empid311,empname563,mobile39,color9,106206
-empid366,empname384,mobile66,color2,103573
-empid368,empname810,mobile3,color8,104830
-empid321,empname309,mobile8,color9,107192
-empid59,empname134,mobile71,color3,109841
-empid190,empname748,mobile67,color5,105792
-empid434,empname229,mobile52,color8,106815
-empid947,empname560,mobile97,color7,1021
-empid104,empname59,mobile74,color4,103071
-empid479,empname568,mobile60,color2,102617
-empid987,empname411,mobile93,color4,108158
-empid280,empname961,mobile76,color9,104904
-empid948,empname195,mobile87,color5,10858
-empid573,empname858,mobile40,color9,109559
-empid867,empname14,mobile33,color7,107432
-empid721,empname833,mobile35,color5,1050
-empid864,empname672,mobile88,color0,101981
-empid866,empname466,mobile66,color1,102459
-empid940,empname343,mobile22,color6,10611
-empid695,empname448,mobile90,color2,101560
-empid993,empname431,mobile90,color6,102633
-empid818,empname685,mobile96,color6,109833
-empid923,empname21,mobile28,color0,10364
-empid677,empname164,mobile53,color0,103362
-empid875,empname823,mobile63,color8,106078
-empid77,empname654,mobile66,color2,103524
-empid288,empname522,mobile63,color8,105855
-empid985,empname83,mobile77,color6,104115
-empid425,empname36,mobile79,color0,106354
-empid294,empname701,mobile9,color1,105735
-empid499,empname34,mobile12,color1,102658
-empid107,empname633,mobile99,color9,104115
-empid65,empname59,mobile11,color0,105585
-empid217,empname980,mobile64,color4,109552
-empid757,empname201,mobile13,color3,10927
-empid166,empname29,mobile12,color3,10519
-empid432,empname970,mobile35,color8,105377
-empid353,empname644,mobile85,color4,101159
-empid728,empname448,mobile15,color9,102332
-empid84,empname174,mobile13,color6,102866
-empid490,empname478,mobile41,color2,103968
-empid390,empname535,mobile37,color7,101084
-empid836,empname852,mobile82,color2,103912
-empid847,empname755,mobile86,color5,109397
-empid371,empname991,mobile11,color3,101308
-empid229,empname158,mobile38,color6,101807
-empid751,empname147,mobile60,color8,108676
-empid145,empname815,mobile66,color1,108851
-empid927,empname324,mobile38,color5,101567
-empid354,empname50,mobile18,color4,103689
-empid545,empname331,mobile82,color3,103435
-empid965,empname787,mobile50,color7,108736
-empid539,empname239,mobile10,color9,105061
-empid297,empname15,mobile84,color6,108120
-empid193,empname841,mobile84,color5,102207
-empid694,empname38,mobile40,color9,104455
-empid638,empname356,mobile31,color3,106572
-empid274,empname989,mobile50,color0,104119
-empid903,empname227,mobile96,color1,106354
-empid21,empname360,mobile20,color0,109993
-empid975,empname227,mobile57,color5,107607
-empid395,empname216,mobile42,color8,101803
-empid590,empname131,mobile91,color4,106415
-empid40,empname476,mobile73,color5,105043
-empid28,empname960,mobile8,color6,104751
-empid175,empname752,mobile23,color7,104698
-empid157,empname72,mobile16,color0,107107
-empid438,empname19,mobile61,color4,106217
-empid844,empname643,mobile58,color3,109654
-empid140,empname435,mobile21,color7,102599
-empid59,empname562,mobile54,color4,10362
-empid615,empname837,mobile3,color0,102015
-empid770,empname793,mobile95,color9,107865
-empid907,empname661,mobile26,color7,103640
-empid29,empname314,mobile68,color4,107082
-empid552,empname355,mobile23,color8,103383
-empid278,empname254,mobile96,color8,109425
-empid440,empname802,mobile99,color0,106313
-empid550,empname396,mobile12,color8,107686
-empid292,empname144,mobile52,color0,109348
-empid794,empname157,mobile24,color8,106614
-empid345,empname130,mobile54,color5,108105
-empid657,empname586,mobile34,color0,105264
-empid262,empname902,mobile50,color9,105853
-empid614,empname847,mobile7,color2,104433
-empid979,empname51,mobile77,color8,107137
-empid782,empname254,mobile82,color8,103055
-empid308,empname276,mobile90,color4,108125
-empid992,empname275,mobile88,color7,105388
-empid239,empname901,mobile28,color5,105653
-empid359,empname251,mobile30,color9,10232
-empid93,empname957,mobile47,color0,107223
-empid619,empname231,mobile46,color2,1041
-empid620,empname486,mobile73,color0,102851
-empid573,empname705,mobile9,color1,105244
-empid714,empname460,mobile64,color0,108358
-empid235,empname740,mobile15,color1,101404
-empid414,empname509,mobile41,color6,101929
-empid396,empname259,mobile41,color0,101710
-empid730,empname867,mobile84,color4,105203
-empid219,empname511,mobile50,color6,108437
-empid941,empname204,mobile48,color0,108835
-empid544,empname487,mobile52,color3,105311
-empid952,empname891,mobile62,color9,105744
-empid83,empname17,mobile7,color0,107934
-empid632,empname327,mobile46,color2,10113
-empid130,empname425,mobile90,color5,1072
-empid671,empname462,mobile25,color5,109057
-empid489,empname757,mobile41,color8,108749
-empid16,empname186,mobile60,color5,105095
-empid651,empname268,mobile64,color1,106131
-empid838,empname624,mobile29,color2,10426
-empid986,empname561,mobile48,color0,103638
-empid497,empname270,mobile82,color1,109295
-empid251,empname350,mobile32,color1,108679
-empid599,empname724,mobile61,color3,103603
-empid245,empname459,mobile41,color9,108817
-empid451,empname275,mobile23,color2,108025
-empid158,empname407,mobile18,color1,102958
-empid577,empname691,mobile36,color9,10617
-empid829,empname473,mobile16,color9,104067
-empid687,empname586,mobile27,color5,107794
-empid765,empname262,mobile23,color9,103028
-empid389,empname399,mobile26,color7,101822
-empid201,empname221,mobile25,color0,105644
-empid109,empname385,mobile82,color7,101330
-empid485,empname560,mobile1,color2,105790
-empid701,empname454,mobile72,color4,108672
-empid242,empname307,mobile95,color1,101980
-empid858,empname554,mobile17,color1,109023
-empid813,empname590,mobile51,color7,101237
-empid736,empname417,mobile88,color2,106167
-empid808,empname729,mobile89,color0,102610
-empid78,empname389,mobile34,color4,104128
-empid905,empname457,mobile47,color6,109518
-empid595,empname572,mobile96,color7,106520
-empid297,empname914,mobile49,color6,107027
-empid83,empname425,mobile12,color0,108220
-empid502,empname117,mobile77,color5,105271
-empid386,empname128,mobile70,color0,102567
-empid559,empname326,mobile15,color0,101331
-empid50,empname642,mobile37,color1,101312
-empid849,empname983,mobile90,color3,109023
-empid108,empname324,mobile25,color9,109001
-empid109,empname682,mobile36,color6,103780
-empid24,empname772,mobile2,color5,107039
-empid313,empname501,mobile95,color9,101523
-empid763,empname147,mobile27,color0,109447
-empid38,empname343,mobile58,color5,104872
-empid702,empname957,mobile85,color0,102147
-empid222,empname312,mobile13,color0,107425
-empid634,empname902,mobile26,color8,104654
-empid674,empname66,mobile57,color9,109028
-empid318,empname921,mobile23,color9,106834
-empid764,empname800,mobile30,color9,104890
-empid378,empname874,mobile42,color6,107876
-empid45,empname631,mobile7,color7,1099
-empid209,empname271,mobile75,color9,106429
-empid880,empname917,mobile21,color7,108617
-empid365,empname244,mobile8,color1,109189
-empid110,empname771,mobile11,color0,109667
-empid557,empname921,mobile94,color7,105986
-empid197,empname301,mobile2,color9,104427
-empid156,empname993,mobile97,color6,102043
-empid377,empname53,mobile71,color6,108017
-empid980,empname945,mobile49,color6,106753
-empid148,empname926,mobile62,color9,108394
-empid492,empname778,mobile47,color6,101276
-empid873,empname695,mobile90,color8,107596
-empid80,empname166,mobile90,color8,108155
-empid462,empname746,mobile95,color9,102954
-empid154,empname813,mobile9,color8,107821
-empid806,empname943,mobile6,color5,108120
-empid810,empname670,mobile53,color1,102166
-empid358,empname546,mobile33,color4,102238
-empid296,empname455,mobile7,color9,103877
-empid439,empname772,mobile23,color9,102818
-empid474,empname157,mobile14,color7,109853
-empid568,empname873,mobile32,color5,10184
-empid535,empname773,mobile96,color5,103228
-empid484,empname160,mobile84,color7,108539
-empid960,empname588,mobile20,color2,1036
-empid489,empname238,mobile25,color3,106924
-empid732,empname833,mobile11,color3,109522
-empid778,empname129,mobile82,color7,104899
-empid177,empname61,mobile3,color2,10426
-empid697,empname893,mobile84,color8,109839
-empid576,empname305,mobile10,color2,109292
-empid691,empname547,mobile3,color9,10835
-empid701,empname346,mobile87,color4,108887
-empid4,empname859,mobile60,color2,108737
-empid455,empname748,mobile5,color9,10520
-empid346,empname694,mobile9,color7,106406
-empid765,empname102,mobile38,color5,102693
-empid976,empname315,mobile75,color9,107300
-empid969,empname430,mobile44,color5,109282
-empid793,empname975,mobile6,color4,104277
-empid539,empname755,mobile48,color0,101034
-empid827,empname322,mobile52,color6,108056
-empid711,empname331,mobile24,color0,107568
-empid487,empname725,mobile80,color1,104894
-empid569,empname226,mobile55,color1,101171
-empid613,empname947,mobile7,color4,102837
-empid278,empname832,mobile55,color1,10584
-empid200,empname747,mobile57,color5,103712
-empid915,empname66,mobile65,color0,104477
-empid358,empname368,mobile8,color2,103204
-empid775,empname69,mobile68,color4,104849
-empid722,empname621,mobile81,color5,107846
-empid657,empname47,mobile30,color2,102509
-empid716,empname367,mobile81,color5,109211
-empid711,empname758,mobile97,color3,106646
-empid410,empname960,mobile79,color5,107373
-empid493,empname140,mobile27,color0,102912
-empid138,empname228,mobile2,color1,10739
-empid417,empname425,mobile49,color6,109015
-empid610,empname691,mobile87,color4,102724
-empid411,empname699,mobile33,color2,108284
-empid560,empname136,mobile15,color5,105127
-empid818,empname450,mobile42,color8,109802
-empid639,empname388,mobile82,color7,108591
-empid861,empname880,mobile24,color4,101957
-empid339,empname710,mobile57,color9,102106
-empid629,empname425,mobile79,color7,103647
-empid26,empname280,mobile17,color5,106920
-empid694,empname878,mobile43,color1,107147
-empid898,empname342,mobile73,color4,101109
-empid316,empname701,mobile84,color7,108385
-empid35,empname923,mobile32,color6,102515
-empid766,empname953,mobile53,color8,109473
-empid860,empname16,mobile74,color7,10669
-empid688,empname723,mobile71,color1,105128
-empid645,empname376,mobile85,color5,102059
-empid20,empname163,mobile39,color8,106921
-empid9,empname590,mobile30,color8,103933
-empid448,empname486,mobile75,color0,109963
-empid835,empname390,mobile5,color1,10126
-empid579,empname514,mobile32,color2,101210
-empid939,empname862,mobile37,color6,10485
-empid413,empname298,mobile40,color9,107810
-empid789,empname431,mobile18,color3,103362
-empid235,empname942,mobile34,color0,107523
-empid832,empname947,mobile10,color3,101103
-empid462,empname492,mobile89,color3,105578
-empid590,empname389,mobile73,color7,105539
-empid816,empname368,mobile22,color7,10746
-empid807,empname391,mobile14,color5,109321
-empid183,empname457,mobile78,color1,10978
-empid876,empname915,mobile76,color3,108523
-empid624,empname926,mobile44,color2,107853
-empid941,empname431,mobile87,color3,101572
-empid788,empname583,mobile26,color7,109634
-empid813,empname134,mobile32,color3,101500
-empid261,empname756,mobile34,color2,108826
-empid3,empname291,mobile14,color3,109912
-empid508,empname80,mobile46,color7,101804
-empid43,empname695,mobile65,color0,106861
-empid562,empname916,mobile43,color9,104026
-empid22,empname352,mobile33,color0,103010
-empid89,empname290,mobile29,color5,104538
-empid316,empname37,mobile77,color9,109358
-empid346,empname606,mobile80,color5,105591
-empid578,empname452,mobile65,color0,105803
-empid619,empname284,mobile11,color1,103431
-empid529,empname523,mobile63,color1,101193
-empid725,empname50,mobile78,color7,105599
-empid955,empname446,mobile15,color0,106294
-empid300,empname820,mobile33,color6,103834
-empid905,empname540,mobile26,color9,107655
-empid292,empname610,mobile99,color1,102417
-empid762,empname455,mobile26,color2,107349
-empid158,empname819,mobile46,color8,109692
-empid417,empname902,mobile95,color9,105788
-empid611,empname261,mobile99,color6,101748
-empid641,empname545,mobile78,color5,109736
-empid505,empname473,mobile56,color0,101787
-empid538,empname146,mobile48,color8,105857
-empid46,empname694,mobile15,color3,107366
-empid779,empname258,mobile4,color9,10996
-empid297,empname293,mobile39,color2,102951
-empid463,empname839,mobile33,color2,106732
-empid236,empname163,mobile92,color2,101218
-empid163,empname477,mobile99,color5,103052
-empid107,empname661,mobile31,color5,105961
-empid105,empname629,mobile25,color5,102686
-empid760,empname705,mobile34,color9,101723
-empid759,empname101,mobile77,color5,107071
-empid880,empname516,mobile29,color0,102052
-empid361,empname901,mobile54,color0,108393
-empid151,empname949,mobile97,color6,107349
-empid144,empname823,mobile66,color4,101406
-empid890,empname625,mobile71,color5,104787
-empid617,empname418,mobile34,color7,102555
-empid372,empname190,mobile10,color5,108771
-empid505,empname539,mobile55,color8,103287
-empid948,empname908,mobile1,color2,106290
-empid711,empname859,mobile88,color4,10907
-empid894,empname694,mobile95,color4,107914
-empid130,empname550,mobile31,color7,103762
-empid847,empname59,mobile45,color2,10713
-empid263,empname657,mobile11,color2,103791
-empid59,empname462,mobile61,color2,104437
-empid824,empname816,mobile69,color1,107880
-empid102,empname971,mobile24,color8,10355
-empid372,empname832,mobile86,color7,10232
-empid558,empname593,mobile47,color9,107874
-empid426,empname85,mobile37,color3,107611
-empid955,empname698,mobile34,color1,108429
-empid179,empname411,mobile20,color8,10859
-empid587,empname961,mobile28,color2,103865
-empid499,empname25,mobile88,color8,107287
-empid994,empname497,mobile79,color9,101161
-empid917,empname408,mobile75,color4,109276
-empid363,empname158,mobile25,color0,101693
-empid871,empname205,mobile75,color7,107091
-empid267,empname736,mobile68,color3,107186
-empid750,empname293,mobile20,color1,105097
-empid532,empname45,mobile96,color4,101131
-empid171,empname793,mobile27,color5,101219
-empid909,empname689,mobile90,color6,108474
-empid214,empname750,mobile21,color0,109760
-empid472,empname309,mobile77,color7,108976
-empid702,empname485,mobile81,color5,105901
-empid246,empname798,mobile55,color4,10976
-empid628,empname133,mobile31,color3,106510
-empid85,empname260,mobile39,color5,107911
-empid550,empname552,mobile89,color0,102885
-empid423,empname958,mobile37,color6,108941
-empid98,empname476,mobile27,color2,108917
-empid205,empname464,mobile4,color8,105391
-empid744,empname468,mobile13,color5,104968
-empid668,empname690,mobile68,color0,108269
-empid897,empname233,mobile25,color9,105577
-empid131,empname18,mobile87,color1,103514
-empid272,empname148,mobile76,color7,10722
-empid514,empname582,mobile88,color1,107963
-empid994,empname79,mobile13,color9,108376
-empid726,empname85,mobile75,color8,106322
-empid633,empname706,mobile68,color0,107676
-empid104,empname523,mobile64,color0,107524
-empid645,empname69,mobile50,color3,108196
-empid627,empname829,mobile93,color9,101879
-empid257,empname513,mobile29,color9,106117
-empid376,empname794,mobile52,color6,103870
-empid778,empname613,mobile24,color8,10590
-empid298,empname770,mobile15,color8,102484
-empid948,empname44,mobile64,color8,104476
-empid71,empname195,mobile73,color9,103842
-empid602,empname563,mobile26,color5,10544
-empid923,empname739,mobile35,color6,102095
-empid548,empname754,mobile40,color5,106855
-empid448,empname307,mobile39,color4,107764
-empid321,empname71,mobile21,color8,107958
-empid1,empname871,mobile87,color4,109470
-empid530,empname823,mobile93,color2,105571
-empid583,empname452,mobile84,color7,103683
-empid818,empname162,mobile68,color4,105786
-empid460,empname614,mobile82,color8,108023
-empid915,empname840,mobile71,color5,107353
-empid472,empname198,mobile7,color6,107564
-empid870,empname449,mobile48,color2,108412
-empid541,empname655,mobile72,color4,103904
-empid426,empname298,mobile13,color3,106265
-empid224,empname203,mobile16,color8,104761
-empid811,empname881,mobile60,color3,105578
-empid754,empname211,mobile36,color6,10373
-empid462,empname103,mobile76,color4,109014
-empid588,empname153,mobile67,color4,105767
-empid541,empname223,mobile87,color4,109441
-empid185,empname806,mobile67,color8,105816
-empid455,empname886,mobile10,color7,105198
-empid14,empname680,mobile89,color8,101349
-empid996,empname650,mobile18,color7,101408
-empid897,empname270,mobile27,color1,105987
-empid259,empname894,mobile53,color9,105524
-empid197,empname123,mobile84,color3,104408
-empid754,empname24,mobile94,color9,108277
-empid397,empname699,mobile82,color4,104073
-empid695,empname823,mobile21,color6,102683
-empid92,empname779,mobile7,color4,105083
-empid63,empname514,mobile6,color5,101511
-empid114,empname855,mobile36,color6,106986
-empid260,empname980,mobile48,color9,101745
-empid979,empname575,mobile57,color8,107380
-empid507,empname932,mobile30,color7,106208
-empid143,empname343,mobile26,color8,104661
-empid920,empname857,mobile42,color6,106309
-empid817,empname552,mobile98,color7,1050
-empid255,empname453,mobile48,color9,105828
-empid76,empname759,mobile24,color1,107544
-empid614,empname798,mobile85,color2,106791
-empid740,empname321,mobile35,color1,102242
-empid880,empname583,mobile0,color6,105810
-empid426,empname572,mobile15,color4,108499
-empid691,empname701,mobile80,color6,105627
-empid631,empname188,mobile68,color7,109697
-empid409,empname532,mobile19,color2,102086
-empid834,empname755,mobile29,color0,108394
-empid710,empname6,mobile1,color7,103370
-empid817,empname910,mobile85,color3,103324
-empid268,empname141,mobile64,color2,106040
-empid674,empname191,mobile68,color7,104345
-empid307,empname443,mobile47,color7,104341
-empid486,empname957,mobile86,color7,109443
-empid612,empname136,mobile68,color2,102341
-empid243,empname8,mobile81,color0,10578
-empid731,empname194,mobile74,color8,109702
-empid71,empname336,mobile12,color9,106684
-empid978,empname374,mobile80,color4,105943
-empid494,empname294,mobile90,color0,103809
-empid636,empname616,mobile46,color4,109397
-empid869,empname900,mobile16,color0,104499
-empid571,empname549,mobile97,color9,106356
-empid204,empname516,mobile6,color4,103601
-empid449,empname284,mobile91,color1,10355
-empid35,empname32,mobile27,color5,108799
-empid578,empname385,mobile64,color6,105344
-empid677,empname90,mobile36,color5,105512
-empid238,empname727,mobile13,color1,109319
-empid953,empname614,mobile77,color5,106368
-empid847,empname210,mobile24,color9,108000
-empid184,empname115,mobile96,color9,10205
-empid810,empname294,mobile70,color8,10963
-empid181,empname674,mobile96,color3,108709
-empid43,empname434,mobile5,color5,102301
-empid121,empname334,mobile53,color2,10490
-empid944,empname961,mobile65,color2,107538
-empid612,empname390,mobile21,color8,106602
-empid55,empname77,mobile87,color9,104832
-empid552,empname431,mobile14,color5,108028
-empid44,empname100,mobile87,color8,108336
-empid781,empname412,mobile57,color6,103710
-empid832,empname365,mobile48,color3,102976
-empid110,empname573,mobile4,color7,102327
-empid87,empname519,mobile52,color3,108437
-empid919,empname789,mobile17,color2,103058
-empid321,empname250,mobile59,color4,107973
-empid171,empname287,mobile44,color2,10423
-empid671,empname627,mobile81,color2,10160
-empid209,empname526,mobile28,color2,103214
-empid166,empname490,mobile54,color0,102728
-empid803,empname599,mobile95,color5,104097
-empid767,empname124,mobile28,color1,10653
-empid311,empname850,mobile58,color0,106110
-empid792,empname50,mobile51,color4,102553
-empid39,empname432,mobile25,color1,102424
-empid214,empname974,mobile41,color8,108610
-empid5,empname594,mobile19,color8,102393
-empid785,empname441,mobile51,color1,10140
-empid367,empname948,mobile40,color0,103819
-empid958,empname973,mobile65,color7,103148
-empid339,empname986,mobile2,color6,103490
-empid638,empname477,mobile56,color2,105489
-empid725,empname414,mobile62,color5,10587
-empid171,empname125,mobile32,color8,107504
-empid784,empname293,mobile68,color9,105287
-empid196,empname325,mobile77,color3,106767
-empid941,empname455,mobile42,color2,108555
-empid957,empname898,mobile85,color0,108016
-empid507,empname120,mobile61,color8,102295
-empid192,empname418,mobile52,color8,104941
-empid320,empname892,mobile78,color7,103184
-empid356,empname757,mobile57,color1,106493
-empid669,empname308,mobile32,color3,107873
-empid687,empname547,mobile31,color9,106477
-empid288,empname388,mobile61,color0,107240
-empid920,empname84,mobile17,color7,105780
-empid306,empname925,mobile96,color1,104407
-empid495,empname188,mobile12,color8,105253
-empid198,empname526,mobile31,color1,102887
-empid970,empname693,mobile34,color1,108390
-empid927,empname455,mobile72,color1,107377
-empid800,empname489,mobile76,color9,104890
-empid799,empname889,mobile1,color0,101964
-empid771,empname807,mobile66,color5,109895
-empid469,empname905,mobile5,color6,102382
-empid835,empname84,mobile4,color6,101707
-empid925,empname326,mobile19,color5,10978
-empid135,empname756,mobile34,color1,108387
-empid875,empname746,mobile35,color3,103878
-empid589,empname177,mobile36,color9,106839
-empid441,empname392,mobile74,color2,102850
-empid900,empname151,mobile14,color3,10520
-empid346,empname423,mobile12,color1,108074
-empid279,empname235,mobile95,color5,101645
-empid879,empname108,mobile36,color4,103158
-empid181,empname750,mobile18,color1,102564
-empid793,empname486,mobile81,color5,107805
-empid998,empname885,mobile19,color8,109790
-empid298,empname547,mobile82,color6,103992
-empid822,empname748,mobile47,color1,101468
-empid809,empname621,mobile31,color2,101804
-empid162,empname767,mobile33,color9,106609
-empid902,empname652,mobile13,color6,101017
-empid739,empname358,mobile81,color2,104149
-empid699,empname772,mobile54,color7,104040
-empid269,empname242,mobile62,color4,1019
-empid300,empname998,mobile57,color3,103022
-empid345,empname407,mobile72,color5,102755
-empid998,empname185,mobile7,color9,109701
-empid530,empname82,mobile47,color2,109528
-empid471,empname308,mobile59,color6,109381
-empid473,empname995,mobile9,color6,108924
-empid340,empname626,mobile75,color7,105498
-empid39,empname287,mobile11,color6,109634
-empid886,empname633,mobile24,color6,101701
-empid692,empname620,mobile57,color9,101784
-empid700,empname76,mobile91,color7,107033
-empid896,empname896,mobile27,color7,108829
-empid387,empname650,mobile73,color2,103827
-empid632,empname285,mobile74,color8,104264
-empid794,empname410,mobile92,color4,103209
-empid785,empname13,mobile25,color3,101845
-empid472,empname587,mobile50,color3,102993
-empid958,empname256,mobile5,color9,106943
-empid242,empname418,mobile52,color3,103822
-empid504,empname270,mobile62,color2,108357
-empid625,empname401,mobile95,color1,104993
-empid628,empname470,mobile51,color4,107329
-empid613,empname834,mobile19,color3,102411
-empid653,empname798,mobile27,color7,10797
-empid724,empname55,mobile81,color6,106327
-empid310,empname371,mobile19,color8,104951
-empid106,empname784,mobile99,color0,102621
-empid239,empname598,mobile39,color8,102335
-empid13,empname92,mobile32,color6,102748
-empid628,empname482,mobile58,color0,109260
-empid37,empname30,mobile67,color7,10616
-empid805,empname319,mobile52,color7,107750
-empid446,empname482,mobile25,color6,106479
-empid440,empname13,mobile59,color1,105336
-empid660,empname996,mobile68,color7,106992
-empid589,empname544,mobile47,color6,104499
-empid556,empname594,mobile44,color2,103862
-empid246,empname593,mobile6,color1,102150
-empid526,empname976,mobile66,color6,104910
-empid820,empname56,mobile1,color6,10981
-empid53,empname106,mobile20,color5,103474
-empid984,empname441,mobile72,color4,104211
-empid439,empname648,mobile50,color9,101602
-empid843,empname288,mobile84,color6,103380
-empid405,empname384,mobile50,color9,106832
-empid357,empname866,mobile40,color5,102726
-empid791,empname144,mobile14,color9,107751
-empid994,empname48,mobile36,color6,103515
-empid943,empname136,mobile20,color2,103292
-empid126,empname134,mobile22,color7,108582
-empid192,empname879,mobile76,color1,102194
-empid124,empname212,mobile4,color3,10528
-empid24,empname697,mobile90,color7,109408
-empid349,empname936,mobile9,color3,105229
-empid46,empname220,mobile40,color7,104468
-empid214,empname907,mobile29,color4,105472
-empid688,empname390,mobile4,color5,10250
-empid369,empname426,mobile50,color3,106167
-empid497,empname598,mobile86,color4,10943
-empid597,empname156,mobile65,color7,109756
-empid898,empname161,mobile23,color5,108956
-empid482,empname774,mobile23,color9,106358
-empid309,empname969,mobile83,color1,107909
-empid523,empname334,mobile80,color0,108282
-empid99,empname802,mobile34,color4,106701
-empid926,empname704,mobile34,color1,108726
-empid659,empname196,mobile49,color2,105916
-empid438,empname538,mobile49,color8,103066
-empid831,empname525,mobile29,color1,10573
-empid302,empname68,mobile61,color8,101288
-empid576,empname39,mobile41,color9,1078
-empid349,empname831,mobile0,color2,108694
-empid62,empname25,mobile57,color7,109589
-empid473,empname329,mobile92,color7,107645
-empid827,empname769,mobile6,color1,102221
-empid424,empname250,mobile85,color3,102004
-empid742,empname284,mobile59,color7,107997
-empid610,empname873,mobile18,color8,101857
-empid548,empname360,mobile84,color0,108836
-empid147,empname831,mobile12,color9,103339
-empid514,empname12,mobile16,color9,105159
-empid384,empname932,mobile7,color3,10145
-empid264,empname914,mobile46,color3,107704
-empid974,empname152,mobile18,color4,103152
-empid673,empname80,mobile34,color0,108552
-empid34,empname640,mobile90,color6,109610
-empid737,empname984,mobile6,color6,109949
-empid700,empname593,mobile85,color2,106188
-empid377,empname277,mobile29,color8,10327
-empid901,empname695,mobile43,color1,102384
-empid530,empname59,mobile95,color3,105365
-empid246,empname366,mobile69,color5,108379
-empid33,empname973,mobile61,color2,101182
-empid683,empname357,mobile42,color3,101943
-empid505,empname318,mobile13,color9,107683
-empid476,empname658,mobile12,color4,105956
-empid934,empname298,mobile31,color4,103118
-empid810,empname957,mobile56,color7,101714
-empid333,empname323,mobile41,color7,101422
-empid239,empname909,mobile44,color2,109824
-empid349,empname969,mobile47,color3,101663
-empid14,empname767,mobile26,color8,107110
-empid246,empname673,mobile52,color7,105665
-empid654,empname416,mobile23,color7,109385
-empid768,empname425,mobile15,color0,106612
-empid596,empname367,mobile64,color0,109161
-empid243,empname827,mobile21,color4,101231
-empid762,empname64,mobile88,color5,101952
-empid764,empname458,mobile43,color6,10813
-empid364,empname853,mobile86,color1,103356
-empid231,empname348,mobile39,color9,108132
-empid168,empname869,mobile97,color7,107403
-empid214,empname298,mobile34,color4,108454
-empid473,empname301,mobile74,color8,108387
-empid933,empname151,mobile73,color4,10822
-empid795,empname670,mobile80,color3,102857
-empid821,empname394,mobile58,color3,107853
-empid817,empname611,mobile31,color0,106429
-empid891,empname571,mobile59,color8,107498
-empid732,empname907,mobile16,color1,109171
-empid755,empname440,mobile41,color3,106097
-empid724,empname549,mobile91,color5,104964
-empid907,empname987,mobile90,color7,105395
-empid623,empname239,mobile53,color2,102514
-empid990,empname766,mobile22,color9,108949
-empid91,empname148,mobile13,color7,102291
-empid235,empname787,mobile91,color2,105318
-empid579,empname208,mobile67,color8,10711
-empid187,empname439,mobile63,color2,103988
-empid222,empname95,mobile93,color7,104719
-empid222,empname350,mobile84,color9,109401
-empid333,empname364,mobile93,color7,106090
-empid674,empname474,mobile65,color3,102031
-empid201,empname6,mobile85,color1,106003
-empid372,empname253,mobile34,color0,101161
-empid234,empname793,mobile38,color9,105138
-empid180,empname431,mobile70,color1,105266
-empid196,empname273,mobile96,color0,101100
-empid44,empname122,mobile33,color5,102507
-empid239,empname312,mobile13,color2,10797
-empid689,empname446,mobile32,color4,106772
-empid86,empname99,mobile21,color7,106125
-empid938,empname450,mobile3,color2,104570
-empid950,empname407,mobile91,color4,106414
-empid494,empname703,mobile18,color2,10557
-empid981,empname646,mobile55,color1,101984
-empid524,empname921,mobile54,color8,104623
-empid760,empname43,mobile22,color1,101937
-empid859,empname524,mobile72,color7,10498
-empid509,empname212,mobile20,color5,10378
-empid486,empname832,mobile64,color4,108399
-empid49,empname407,mobile96,color1,107403
-empid587,empname570,mobile20,color4,107516
-empid899,empname327,mobile37,color1,103082
-empid885,empname305,mobile27,color3,104590
-empid620,empname691,mobile9,color6,109506
-empid4,empname262,mobile31,color6,105926
-empid284,empname846,mobile13,color7,109966
-empid377,empname371,mobile59,color3,106145
-empid100,empname51,mobile78,color3,107318
-empid151,empname605,mobile80,color6,10821
-empid31,empname948,mobile38,color0,103361
-empid435,empname609,mobile27,color5,10769
-empid853,empname354,mobile76,color9,102108
-empid921,empname980,mobile43,color4,106066
-empid395,empname30,mobile45,color9,103077
-empid934,empname76,mobile93,color2,108940
-empid365,empname412,mobile85,color7,10661
-empid792,empname750,mobile67,color7,10643
-empid998,empname593,mobile9,color0,10633
-empid154,empname193,mobile85,color5,10693
-empid138,empname469,mobile34,color8,104127
-empid930,empname868,mobile98,color2,101448
-empid636,empname622,mobile8,color4,102039
-empid691,empname429,mobile24,color8,102843
-empid40,empname241,mobile2,color7,101415
-empid342,empname830,mobile64,color8,106048
-empid808,empname764,mobile49,color1,102429
-empid384,empname93,mobile20,color2,106216
-empid415,empname609,mobile75,color8,102362
-empid30,empname808,mobile16,color3,107164
-empid506,empname560,mobile45,color2,109541
-empid832,empname883,mobile20,color8,109920
-empid191,empname375,mobile27,color0,104711
-empid140,empname384,mobile34,color7,109163
-empid869,empname810,mobile77,color8,101955
-empid279,empname762,mobile55,color3,107689
-empid425,empname854,mobile70,color3,109714
-empid185,empname819,mobile24,color8,109621
-empid227,empname527,mobile54,color9,106267
-empid21,empname194,mobile17,color6,103449
-empid772,empname320,mobile75,color0,109447
-empid340,empname599,mobile44,color7,106756
-empid256,empname695,mobile98,color0,107613
-empid480,empname95,mobile53,color8,108395
-empid89,empname157,mobile33,color8,103673
-empid504,empname747,mobile94,color8,105131
-empid480,empname995,mobile84,color7,106718
-empid256,empname532,mobile95,color5,105644
-empid379,empname518,mobile40,color5,107143
-empid879,empname355,mobile12,color3,101146
-empid942,empname605,mobile14,color4,108676
-empid912,empname869,mobile37,color9,103330
-empid606,empname931,mobile85,color3,106825
-empid626,empname40,mobile82,color6,102442
-empid554,empname67,mobile77,color8,105181
-empid100,empname234,mobile86,color4,101771
-empid107,empname23,mobile75,color1,104429
-empid426,empname388,mobile80,color5,105731
-empid757,empname529,mobile40,color2,102365
-empid294,empname247,mobile59,color8,104755
-empid445,empname790,mobile16,color2,10408
-empid401,empname659,mobile59,color1,103198
-empid812,empname746,mobile2,color7,109842
-empid499,empname616,mobile10,color2,107504
-empid643,empname335,mobile72,color5,104779
-empid154,empname85,mobile24,color6,10196
-empid87,empname891,mobile36,color5,104053
-empid202,empname282,mobile89,color6,103192
-empid530,empname500,mobile84,color3,103540
-empid127,empname744,mobile96,color5,101973
-empid685,empname676,mobile80,color9,106160
-empid453,empname701,mobile71,color3,106994
-empid647,empname763,mobile0,color9,105918
-empid441,empname954,mobile1,color8,108164
-empid598,empname731,mobile34,color3,106470
-empid720,empname213,mobile18,color5,103418
-empid406,empname401,mobile3,color0,103110
-empid777,empname579,mobile10,color7,109647
-empid972,empname175,mobile96,color3,1084
-empid486,empname304,mobile25,color5,106045
-empid193,empname426,mobile96,color3,105450

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/join/mgr.csv
----------------------------------------------------------------------
diff --git a/integration/spark/src/test/resources/join/mgr.csv 
b/integration/spark/src/test/resources/join/mgr.csv
deleted file mode 100644
index 5ab1d83..0000000
--- a/integration/spark/src/test/resources/join/mgr.csv
+++ /dev/null
@@ -1 +0,0 @@
-harry,h2399,v788232,99823230205

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/join/mobile.csv
----------------------------------------------------------------------
diff --git a/integration/spark/src/test/resources/join/mobile.csv 
b/integration/spark/src/test/resources/join/mobile.csv
deleted file mode 100644
index dc45fa0..0000000
--- a/integration/spark/src/test/resources/join/mobile.csv
+++ /dev/null
@@ -1,1000 +0,0 @@
-mid77,mobile35,color4,1058
-mid83,mobile78,color6,10865
-mid32,mobile12,color5,10516
-mid93,mobile19,color9,10876
-mid31,mobile43,color3,10481
-mid46,mobile40,color8,10749
-mid51,mobile75,color6,10685
-mid41,mobile85,color8,1015
-mid1,mobile21,color0,10125
-mid37,mobile48,color3,10403
-mid17,mobile29,color6,10165
-mid89,mobile87,color6,10489
-mid50,mobile49,color1,10886
-mid31,mobile16,color6,10554
-mid56,mobile14,color4,10474
-mid82,mobile30,color5,10425
-mid16,mobile40,color1,10662
-mid32,mobile3,color6,10502
-mid58,mobile59,color8,1087
-mid29,mobile79,color6,10112
-mid94,mobile65,color6,10482
-mid46,mobile28,color9,10892
-mid89,mobile69,color0,1047
-mid55,mobile6,color6,10781
-mid46,mobile45,color9,10524
-mid78,mobile60,color1,10554
-mid67,mobile80,color2,10463
-mid8,mobile62,color2,10190
-mid10,mobile48,color4,10573
-mid95,mobile16,color7,10960
-mid43,mobile91,color7,10506
-mid29,mobile8,color1,10509
-mid2,mobile16,color5,10833
-mid71,mobile76,color4,10461
-mid3,mobile2,color0,10638
-mid23,mobile64,color2,10453
-mid26,mobile54,color7,10987
-mid70,mobile55,color0,10416
-mid5,mobile51,color6,10875
-mid84,mobile31,color1,10799
-mid37,mobile56,color9,10831
-mid58,mobile7,color0,1092
-mid37,mobile19,color1,10156
-mid81,mobile14,color4,10397
-mid84,mobile40,color3,10534
-mid49,mobile8,color4,10662
-mid41,mobile84,color3,10518
-mid30,mobile27,color9,10626
-mid67,mobile24,color1,10116
-mid98,mobile65,color7,10254
-mid28,mobile56,color0,10245
-mid10,mobile60,color3,10317
-mid58,mobile31,color7,10789
-mid19,mobile70,color2,10960
-mid92,mobile89,color4,10878
-mid66,mobile45,color2,10328
-mid81,mobile25,color8,10654
-mid31,mobile26,color0,10294
-mid27,mobile13,color0,10391
-mid86,mobile87,color3,10793
-mid42,mobile7,color2,1033
-mid0,mobile10,color8,10308
-mid74,mobile50,color4,10531
-mid6,mobile31,color6,10124
-mid39,mobile73,color9,10400
-mid15,mobile7,color4,10319
-mid17,mobile79,color1,10249
-mid0,mobile17,color3,10826
-mid13,mobile57,color3,10770
-mid33,mobile45,color7,10522
-mid95,mobile17,color3,10876
-mid20,mobile99,color1,10571
-mid70,mobile20,color1,10795
-mid67,mobile20,color4,10423
-mid73,mobile8,color4,10982
-mid64,mobile73,color0,10300
-mid88,mobile73,color1,10437
-mid6,mobile32,color6,10207
-mid38,mobile50,color1,1029
-mid62,mobile39,color9,10356
-mid59,mobile70,color5,1061
-mid98,mobile10,color5,10414
-mid7,mobile70,color1,10279
-mid31,mobile17,color6,10489
-mid37,mobile96,color2,10104
-mid32,mobile66,color2,1030
-mid90,mobile7,color5,10210
-mid91,mobile47,color8,10266
-mid90,mobile79,color8,10525
-mid77,mobile48,color6,10694
-mid1,mobile68,color5,10516
-mid59,mobile34,color6,10856
-mid98,mobile98,color8,10644
-mid22,mobile6,color1,1086
-mid27,mobile20,color8,10857
-mid15,mobile16,color5,10534
-mid35,mobile89,color8,10155
-mid75,mobile35,color8,10898
-mid62,mobile91,color3,10307
-mid14,mobile44,color5,10890
-mid28,mobile28,color1,10506
-mid65,mobile47,color3,10825
-mid33,mobile67,color1,1068
-mid91,mobile1,color9,1015
-mid64,mobile13,color3,1012
-mid69,mobile12,color4,1033
-mid42,mobile97,color5,10839
-mid62,mobile85,color9,10216
-mid38,mobile63,color5,10694
-mid26,mobile21,color4,10360
-mid25,mobile16,color0,10964
-mid48,mobile21,color9,10995
-mid69,mobile5,color7,10996
-mid2,mobile9,color7,10361
-mid55,mobile1,color7,10658
-mid11,mobile4,color9,1016
-mid15,mobile78,color0,10183
-mid17,mobile7,color4,10465
-mid93,mobile70,color5,10446
-mid26,mobile5,color9,10429
-mid2,mobile83,color3,10627
-mid7,mobile2,color1,10758
-mid69,mobile72,color8,10794
-mid26,mobile43,color4,10903
-mid46,mobile4,color3,10580
-mid93,mobile44,color8,10867
-mid71,mobile0,color7,10417
-mid27,mobile61,color6,10911
-mid68,mobile96,color9,10840
-mid42,mobile60,color7,10482
-mid87,mobile17,color5,10223
-mid54,mobile71,color8,1071
-mid45,mobile83,color5,10719
-mid40,mobile88,color6,10823
-mid87,mobile52,color2,10790
-mid67,mobile72,color0,10543
-mid76,mobile74,color7,10376
-mid34,mobile57,color6,10428
-mid71,mobile10,color5,10443
-mid70,mobile24,color7,10352
-mid57,mobile81,color3,10846
-mid1,mobile62,color5,1078
-mid60,mobile55,color3,10814
-mid75,mobile2,color8,10675
-mid89,mobile42,color1,10327
-mid41,mobile8,color3,10115
-mid1,mobile16,color9,10576
-mid28,mobile84,color6,10327
-mid23,mobile35,color8,10300
-mid21,mobile62,color8,10111
-mid18,mobile14,color2,1071
-mid11,mobile51,color7,10502
-mid42,mobile66,color5,1084
-mid2,mobile43,color1,10610
-mid72,mobile22,color5,10917
-mid17,mobile79,color5,10163
-mid13,mobile76,color1,10820
-mid97,mobile97,color3,10103
-mid15,mobile26,color6,10383
-mid66,mobile66,color7,10211
-mid41,mobile43,color3,10801
-mid64,mobile37,color8,10515
-mid2,mobile94,color4,10889
-mid15,mobile37,color4,10669
-mid13,mobile78,color0,10686
-mid88,mobile25,color9,10184
-mid60,mobile48,color6,10479
-mid59,mobile49,color4,10750
-mid96,mobile88,color6,10977
-mid9,mobile20,color2,10950
-mid0,mobile42,color4,1022
-mid13,mobile12,color6,10837
-mid61,mobile37,color1,10495
-mid3,mobile84,color7,10829
-mid12,mobile10,color8,10208
-mid62,mobile61,color2,10872
-mid39,mobile29,color4,10752
-mid20,mobile14,color4,10841
-mid12,mobile0,color2,10215
-mid27,mobile93,color5,10169
-mid93,mobile33,color1,10821
-mid78,mobile69,color5,1026
-mid5,mobile60,color2,10593
-mid79,mobile40,color0,10417
-mid0,mobile3,color1,10518
-mid32,mobile13,color7,10422
-mid9,mobile22,color5,10385
-mid69,mobile40,color5,10416
-mid52,mobile36,color4,10760
-mid93,mobile76,color5,10502
-mid20,mobile6,color2,10166
-mid88,mobile81,color0,10166
-mid25,mobile62,color9,10140
-mid54,mobile20,color8,10370
-mid53,mobile14,color8,1045
-mid78,mobile82,color5,10304
-mid87,mobile21,color5,1066
-mid70,mobile1,color8,10593
-mid49,mobile40,color9,10450
-mid55,mobile80,color7,10322
-mid49,mobile86,color1,10340
-mid24,mobile25,color4,10946
-mid2,mobile55,color2,1036
-mid35,mobile84,color8,1093
-mid75,mobile22,color1,10543
-mid19,mobile62,color4,10192
-mid33,mobile89,color3,10710
-mid56,mobile71,color2,10670
-mid36,mobile93,color3,10860
-mid5,mobile90,color5,10269
-mid64,mobile69,color9,10657
-mid83,mobile99,color8,10859
-mid78,mobile98,color4,10886
-mid91,mobile67,color5,10950
-mid66,mobile58,color3,1031
-mid24,mobile17,color7,10522
-mid97,mobile39,color6,10171
-mid81,mobile82,color0,10135
-mid88,mobile36,color4,10626
-mid73,mobile12,color8,10384
-mid79,mobile67,color7,10693
-mid63,mobile26,color6,10131
-mid85,mobile13,color9,10843
-mid17,mobile0,color2,1099
-mid58,mobile96,color3,10923
-mid55,mobile79,color9,10297
-mid88,mobile21,color4,10375
-mid55,mobile66,color1,10653
-mid61,mobile64,color0,10216
-mid62,mobile61,color1,10886
-mid42,mobile99,color3,10676
-mid51,mobile92,color4,10165
-mid88,mobile64,color8,10717
-mid47,mobile99,color1,10724
-mid67,mobile87,color8,1097
-mid7,mobile36,color1,10108
-mid55,mobile88,color5,10314
-mid7,mobile96,color2,10268
-mid26,mobile68,color6,1027
-mid22,mobile60,color3,10464
-mid30,mobile90,color7,10831
-mid87,mobile66,color2,10869
-mid21,mobile27,color6,10747
-mid22,mobile98,color0,10136
-mid6,mobile69,color2,1041
-mid55,mobile1,color6,10688
-mid40,mobile51,color3,10677
-mid60,mobile58,color3,10597
-mid98,mobile2,color7,10817
-mid52,mobile47,color2,10847
-mid93,mobile32,color7,1044
-mid62,mobile57,color2,1073
-mid28,mobile5,color0,10278
-mid18,mobile70,color1,102
-mid69,mobile50,color4,10529
-mid29,mobile91,color3,10392
-mid87,mobile6,color3,10114
-mid76,mobile96,color1,1094
-mid41,mobile55,color0,10171
-mid10,mobile18,color1,10463
-mid59,mobile24,color8,10946
-mid80,mobile52,color0,10427
-mid95,mobile89,color6,10208
-mid11,mobile82,color9,10757
-mid63,mobile52,color9,10127
-mid6,mobile48,color6,10368
-mid53,mobile27,color6,10897
-mid22,mobile17,color3,10756
-mid84,mobile15,color7,10402
-mid93,mobile19,color5,10252
-mid21,mobile8,color4,10899
-mid13,mobile60,color3,10636
-mid10,mobile41,color0,10525
-mid79,mobile64,color8,10228
-mid52,mobile1,color1,1018
-mid61,mobile47,color7,10565
-mid72,mobile34,color6,10756
-mid31,mobile61,color1,10940
-mid4,mobile36,color6,10640
-mid26,mobile58,color0,10526
-mid57,mobile67,color6,1050
-mid9,mobile16,color6,10764
-mid41,mobile77,color1,10595
-mid48,mobile17,color5,10815
-mid42,mobile70,color9,10167
-mid5,mobile57,color2,10273
-mid35,mobile22,color0,10661
-mid49,mobile36,color6,10935
-mid72,mobile91,color0,10167
-mid88,mobile33,color2,10780
-mid86,mobile71,color7,1037
-mid86,mobile48,color5,10395
-mid42,mobile31,color7,10782
-mid32,mobile62,color9,10435
-mid64,mobile67,color2,10779
-mid99,mobile69,color5,10772
-mid88,mobile24,color3,1056
-mid66,mobile31,color2,10738
-mid52,mobile59,color8,10408
-mid92,mobile1,color0,10100
-mid63,mobile15,color7,10309
-mid59,mobile14,color0,10414
-mid56,mobile32,color1,10803
-mid54,mobile62,color9,10140
-mid65,mobile46,color6,10369
-mid49,mobile81,color2,10958
-mid84,mobile53,color5,10144
-mid75,mobile40,color4,10965
-mid33,mobile52,color2,10170
-mid96,mobile3,color6,10982
-mid82,mobile83,color6,10772
-mid82,mobile70,color8,1041
-mid32,mobile14,color1,10770
-mid21,mobile85,color1,10457
-mid95,mobile36,color3,10108
-mid23,mobile3,color2,10205
-mid67,mobile98,color1,10509
-mid77,mobile82,color5,10682
-mid44,mobile7,color1,10802
-mid75,mobile57,color0,1070
-mid37,mobile4,color7,10548
-mid55,mobile31,color1,10583
-mid34,mobile6,color4,10849
-mid11,mobile58,color3,10844
-mid41,mobile2,color9,10423
-mid18,mobile59,color5,10835
-mid56,mobile96,color1,10216
-mid76,mobile35,color9,10463
-mid61,mobile44,color9,10130
-mid59,mobile91,color7,10870
-mid18,mobile50,color7,10202
-mid52,mobile34,color7,10237
-mid23,mobile56,color1,1030
-mid19,mobile70,color4,10940
-mid60,mobile48,color0,10391
-mid84,mobile71,color9,10590
-mid17,mobile32,color2,10648
-mid59,mobile45,color9,10151
-mid25,mobile93,color9,10235
-mid49,mobile83,color0,10628
-mid88,mobile77,color7,10671
-mid16,mobile82,color9,1089
-mid38,mobile98,color9,10804
-mid64,mobile62,color1,10306
-mid21,mobile16,color8,10463
-mid7,mobile26,color5,10218
-mid31,mobile21,color1,10721
-mid18,mobile71,color5,10935
-mid47,mobile73,color5,10194
-mid87,mobile53,color9,10145
-mid56,mobile71,color9,10357
-mid41,mobile30,color6,10511
-mid70,mobile65,color7,10822
-mid54,mobile86,color4,10459
-mid94,mobile44,color7,10531
-mid75,mobile59,color1,10943
-mid85,mobile90,color7,10298
-mid85,mobile65,color7,10590
-mid88,mobile28,color1,10924
-mid45,mobile42,color7,10787
-mid64,mobile29,color9,1034
-mid4,mobile98,color6,1025
-mid73,mobile73,color2,10748
-mid55,mobile75,color8,10861
-mid40,mobile25,color5,10418
-mid79,mobile42,color5,10946
-mid24,mobile29,color7,10746
-mid15,mobile6,color1,10900
-mid63,mobile11,color5,10406
-mid67,mobile72,color0,10835
-mid72,mobile22,color5,10534
-mid15,mobile83,color4,10311
-mid2,mobile52,color6,10472
-mid80,mobile38,color8,10994
-mid3,mobile76,color1,10205
-mid69,mobile21,color2,10812
-mid10,mobile77,color2,10787
-mid59,mobile99,color1,10843
-mid65,mobile80,color2,10127
-mid42,mobile22,color8,10922
-mid19,mobile35,color3,10452
-mid9,mobile91,color0,10588
-mid90,mobile9,color8,10234
-mid6,mobile9,color1,10815
-mid71,mobile12,color6,10905
-mid36,mobile94,color9,10805
-mid48,mobile1,color1,10735
-mid52,mobile79,color9,10135
-mid34,mobile9,color9,10154
-mid91,mobile9,color8,10913
-mid60,mobile31,color4,10938
-mid50,mobile26,color0,10162
-mid35,mobile2,color1,10827
-mid29,mobile86,color4,10782
-mid60,mobile24,color9,10712
-mid12,mobile68,color9,10240
-mid36,mobile36,color3,10163
-mid45,mobile63,color5,10893
-mid58,mobile33,color2,10857
-mid67,mobile4,color6,1019
-mid84,mobile36,color3,10751
-mid73,mobile98,color5,10926
-mid60,mobile51,color7,10660
-mid8,mobile68,color7,10321
-mid74,mobile57,color2,108
-mid16,mobile96,color6,10900
-mid63,mobile62,color7,10314
-mid55,mobile64,color6,1045
-mid9,mobile64,color4,10491
-mid62,mobile16,color4,10856
-mid22,mobile0,color3,10874
-mid2,mobile10,color7,10201
-mid99,mobile60,color1,10127
-mid52,mobile15,color8,10501
-mid31,mobile58,color8,10580
-mid94,mobile44,color3,10538
-mid76,mobile32,color2,10449
-mid38,mobile19,color1,10703
-mid38,mobile8,color0,10561
-mid22,mobile98,color2,10448
-mid79,mobile48,color2,10371
-mid82,mobile17,color4,10720
-mid84,mobile90,color5,10639
-mid7,mobile52,color2,10689
-mid48,mobile24,color6,10963
-mid46,mobile72,color3,1025
-mid32,mobile19,color2,103
-mid53,mobile49,color5,10841
-mid92,mobile44,color4,1015
-mid54,mobile39,color0,10217
-mid0,mobile66,color2,10535
-mid92,mobile69,color1,10927
-mid22,mobile83,color4,10663
-mid75,mobile19,color2,10757
-mid69,mobile66,color6,10323
-mid17,mobile50,color9,10679
-mid89,mobile48,color9,10819
-mid20,mobile43,color1,10420
-mid80,mobile46,color5,10663
-mid64,mobile54,color3,10583
-mid84,mobile34,color1,10931
-mid72,mobile61,color1,1054
-mid21,mobile10,color3,10415
-mid63,mobile41,color0,10137
-mid70,mobile64,color2,10597
-mid64,mobile2,color7,10113
-mid64,mobile96,color6,10231
-mid14,mobile31,color5,10228
-mid93,mobile47,color4,10121
-mid23,mobile61,color5,1071
-mid56,mobile7,color2,10254
-mid91,mobile4,color6,1063
-mid80,mobile88,color7,1089
-mid24,mobile28,color9,1087
-mid43,mobile8,color8,1039
-mid68,mobile76,color7,10107
-mid38,mobile94,color5,104
-mid8,mobile4,color5,10678
-mid43,mobile86,color2,10169
-mid8,mobile82,color5,10628
-mid79,mobile22,color6,1082
-mid22,mobile9,color0,10722
-mid27,mobile28,color1,10977
-mid54,mobile20,color8,10716
-mid7,mobile27,color5,10425
-mid24,mobile95,color6,1059
-mid75,mobile89,color3,10862
-mid6,mobile18,color1,10412
-mid86,mobile17,color9,10829
-mid48,mobile0,color7,10886
-mid42,mobile23,color4,10522
-mid18,mobile29,color3,10328
-mid86,mobile90,color1,10855
-mid19,mobile33,color7,10303
-mid43,mobile62,color2,1088
-mid5,mobile74,color2,10269
-mid76,mobile67,color0,10740
-mid53,mobile95,color9,10691
-mid31,mobile17,color3,1064
-mid44,mobile15,color6,10353
-mid34,mobile41,color9,10774
-mid72,mobile64,color8,10280
-mid84,mobile40,color0,10104
-mid25,mobile30,color7,10799
-mid18,mobile67,color8,10817
-mid27,mobile11,color1,10473
-mid42,mobile65,color4,10485
-mid57,mobile54,color6,10342
-mid96,mobile49,color4,10691
-mid43,mobile82,color9,10849
-mid55,mobile32,color1,10479
-mid57,mobile83,color7,10518
-mid7,mobile52,color7,10438
-mid33,mobile39,color2,10835
-mid39,mobile9,color8,10826
-mid74,mobile3,color2,10294
-mid65,mobile5,color9,10634
-mid41,mobile18,color6,10620
-mid99,mobile89,color1,10856
-mid70,mobile98,color1,10940
-mid26,mobile16,color6,10699
-mid40,mobile53,color9,10766
-mid27,mobile73,color6,10916
-mid39,mobile70,color5,10978
-mid30,mobile93,color6,10146
-mid61,mobile66,color6,10905
-mid78,mobile48,color0,10626
-mid99,mobile1,color3,10769
-mid2,mobile89,color0,10287
-mid51,mobile50,color1,10920
-mid88,mobile33,color5,1059
-mid10,mobile96,color4,10173
-mid55,mobile99,color9,10380
-mid63,mobile31,color9,1086
-mid76,mobile16,color1,10980
-mid29,mobile74,color3,10845
-mid53,mobile15,color3,10205
-mid52,mobile77,color0,10595
-mid41,mobile1,color3,10125
-mid63,mobile33,color2,10957
-mid80,mobile73,color0,10764
-mid38,mobile90,color5,10686
-mid24,mobile70,color3,10543
-mid81,mobile29,color2,10634
-mid8,mobile51,color0,10993
-mid26,mobile21,color8,10273
-mid59,mobile67,color1,1047
-mid39,mobile19,color4,10113
-mid86,mobile8,color4,10590
-mid80,mobile91,color9,1060
-mid40,mobile73,color0,1087
-mid66,mobile56,color7,10948
-mid8,mobile45,color8,10464
-mid59,mobile81,color3,10863
-mid53,mobile25,color2,10756
-mid74,mobile52,color5,10410
-mid58,mobile66,color4,10889
-mid98,mobile46,color6,10151
-mid60,mobile84,color8,1058
-mid38,mobile54,color9,10426
-mid12,mobile54,color9,10411
-mid26,mobile48,color8,10356
-mid29,mobile6,color3,1083
-mid19,mobile70,color4,10604
-mid84,mobile77,color0,10279
-mid51,mobile0,color8,10333
-mid63,mobile62,color6,10950
-mid58,mobile30,color4,1052
-mid84,mobile62,color0,10196
-mid59,mobile79,color4,10600
-mid80,mobile89,color0,10604
-mid45,mobile98,color3,1083
-mid5,mobile61,color4,1075
-mid81,mobile20,color9,10274
-mid84,mobile8,color7,1014
-mid96,mobile43,color6,10948
-mid23,mobile43,color4,10710
-mid63,mobile23,color8,10567
-mid61,mobile10,color8,1019
-mid80,mobile51,color5,10576
-mid97,mobile13,color7,10433
-mid57,mobile28,color2,1039
-mid30,mobile83,color1,10686
-mid90,mobile55,color4,10159
-mid69,mobile4,color6,10712
-mid95,mobile94,color7,10269
-mid94,mobile26,color6,1091
-mid24,mobile17,color4,10124
-mid5,mobile74,color7,10632
-mid89,mobile75,color0,10909
-mid56,mobile13,color6,1074
-mid38,mobile25,color4,10107
-mid33,mobile86,color8,10115
-mid53,mobile64,color2,10842
-mid88,mobile54,color4,10924
-mid94,mobile56,color0,10857
-mid29,mobile42,color3,10491
-mid9,mobile93,color2,10665
-mid85,mobile52,color4,10995
-mid77,mobile21,color3,10416
-mid60,mobile78,color6,10143
-mid60,mobile4,color3,1061
-mid87,mobile84,color3,10758
-mid34,mobile52,color6,10726
-mid23,mobile22,color2,10515
-mid49,mobile72,color9,10592
-mid13,mobile46,color5,10841
-mid54,mobile72,color0,10793
-mid99,mobile88,color3,10217
-mid35,mobile78,color3,1058
-mid95,mobile40,color5,10611
-mid67,mobile81,color0,10473
-mid57,mobile60,color3,10438
-mid7,mobile55,color9,10105
-mid14,mobile77,color4,10697
-mid61,mobile31,color4,10138
-mid28,mobile17,color0,10344
-mid46,mobile24,color2,10398
-mid80,mobile0,color9,10464
-mid99,mobile74,color9,10996
-mid67,mobile72,color3,10731
-mid2,mobile43,color1,10704
-mid59,mobile56,color8,10504
-mid38,mobile11,color6,10233
-mid86,mobile89,color0,10907
-mid82,mobile63,color7,1063
-mid86,mobile92,color4,1043
-mid78,mobile7,color1,10482
-mid98,mobile86,color3,10267
-mid59,mobile55,color9,10902
-mid91,mobile64,color8,10109
-mid69,mobile39,color3,10534
-mid56,mobile85,color3,10852
-mid95,mobile0,color6,10454
-mid33,mobile22,color3,10894
-mid12,mobile41,color4,10720
-mid89,mobile19,color5,10121
-mid73,mobile38,color7,10532
-mid46,mobile48,color2,10242
-mid78,mobile51,color4,10276
-mid97,mobile30,color9,10295
-mid5,mobile25,color5,1046
-mid22,mobile39,color9,10530
-mid12,mobile65,color2,10734
-mid24,mobile35,color4,10466
-mid78,mobile89,color9,10991
-mid38,mobile20,color8,10292
-mid12,mobile24,color8,10696
-mid34,mobile0,color7,10163
-mid17,mobile23,color2,10932
-mid15,mobile16,color0,10869
-mid45,mobile15,color4,10470
-mid47,mobile69,color9,10838
-mid50,mobile7,color4,1058
-mid92,mobile5,color6,10894
-mid87,mobile78,color8,10782
-mid66,mobile99,color6,10167
-mid3,mobile72,color3,10518
-mid3,mobile49,color8,10332
-mid96,mobile11,color1,10233
-mid15,mobile15,color2,10836
-mid57,mobile55,color4,10129
-mid76,mobile31,color7,10737
-mid28,mobile69,color2,101
-mid97,mobile1,color9,10702
-mid44,mobile12,color9,10862
-mid15,mobile76,color7,1073
-mid27,mobile74,color2,10127
-mid1,mobile80,color5,10809
-mid89,mobile21,color8,10370
-mid32,mobile53,color4,10471
-mid65,mobile25,color3,10274
-mid21,mobile41,color0,10339
-mid7,mobile1,color8,1054
-mid14,mobile34,color6,10837
-mid77,mobile61,color5,10517
-mid9,mobile93,color0,10569
-mid15,mobile66,color6,10419
-mid80,mobile48,color9,10930
-mid39,mobile47,color1,10789
-mid31,mobile17,color9,10757
-mid29,mobile4,color1,10580
-mid29,mobile76,color9,10158
-mid44,mobile95,color6,10389
-mid15,mobile9,color4,10764
-mid8,mobile19,color0,10449
-mid99,mobile28,color2,10498
-mid9,mobile4,color4,1073
-mid74,mobile45,color9,10148
-mid70,mobile7,color4,10525
-mid82,mobile3,color6,10946
-mid85,mobile83,color0,10588
-mid93,mobile10,color9,1090
-mid22,mobile15,color6,10965
-mid44,mobile13,color2,10116
-mid44,mobile41,color8,10510
-mid30,mobile56,color0,10921
-mid15,mobile87,color4,10282
-mid33,mobile41,color5,10674
-mid41,mobile94,color3,10389
-mid82,mobile90,color8,10583
-mid50,mobile35,color2,10366
-mid69,mobile42,color0,10474
-mid66,mobile55,color0,10454
-mid86,mobile78,color3,10353
-mid51,mobile25,color3,10552
-mid22,mobile57,color7,10440
-mid43,mobile43,color8,1016
-mid83,mobile52,color0,10455
-mid37,mobile51,color5,10363
-mid84,mobile41,color6,10529
-mid89,mobile38,color4,10742
-mid46,mobile80,color6,10266
-mid68,mobile55,color0,10969
-mid40,mobile94,color8,10232
-mid78,mobile74,color6,10103
-mid50,mobile22,color6,1010
-mid17,mobile95,color9,10519
-mid12,mobile64,color1,10774
-mid55,mobile24,color2,10604
-mid93,mobile45,color6,10132
-mid69,mobile17,color7,10878
-mid5,mobile20,color4,10866
-mid14,mobile84,color1,10549
-mid50,mobile13,color1,10817
-mid86,mobile32,color3,1030
-mid84,mobile93,color4,10424
-mid93,mobile21,color9,10816
-mid76,mobile36,color0,1010
-mid27,mobile38,color8,10518
-mid95,mobile49,color7,10614
-mid67,mobile71,color8,10703
-mid84,mobile17,color4,10910
-mid7,mobile78,color7,10876
-mid51,mobile7,color6,10993
-mid34,mobile46,color7,10692
-mid24,mobile99,color7,10974
-mid50,mobile86,color1,10949
-mid27,mobile5,color9,10566
-mid75,mobile19,color2,10492
-mid68,mobile28,color9,10112
-mid28,mobile82,color7,10402
-mid72,mobile38,color1,10572
-mid91,mobile15,color2,10830
-mid43,mobile89,color5,10623
-mid31,mobile30,color3,10936
-mid61,mobile78,color3,1031
-mid74,mobile62,color7,10799
-mid88,mobile87,color1,1036
-mid20,mobile23,color1,10442
-mid52,mobile23,color9,10592
-mid62,mobile22,color0,10731
-mid68,mobile8,color2,10118
-mid89,mobile25,color3,1061
-mid74,mobile40,color3,10567
-mid45,mobile81,color0,10577
-mid91,mobile84,color4,10580
-mid46,mobile46,color2,10128
-mid87,mobile89,color4,10611
-mid13,mobile47,color8,10699
-mid98,mobile12,color9,10603
-mid58,mobile96,color9,10957
-mid80,mobile21,color9,1088
-mid34,mobile14,color7,10729
-mid87,mobile8,color5,1036
-mid29,mobile12,color6,10705
-mid77,mobile96,color9,1023
-mid65,mobile16,color2,10873
-mid84,mobile33,color4,10909
-mid60,mobile23,color1,10892
-mid93,mobile73,color0,10347
-mid64,mobile67,color8,10197
-mid51,mobile74,color7,10879
-mid97,mobile63,color8,10828
-mid42,mobile89,color8,10287
-mid45,mobile97,color5,10954
-mid40,mobile48,color4,10383
-mid58,mobile80,color8,10309
-mid60,mobile82,color0,10246
-mid9,mobile9,color8,10392
-mid1,mobile22,color6,1070
-mid93,mobile23,color3,10653
-mid85,mobile83,color2,10298
-mid70,mobile30,color8,1058
-mid26,mobile75,color1,10187
-mid2,mobile96,color1,10655
-mid94,mobile13,color5,10606
-mid80,mobile3,color2,10980
-mid76,mobile42,color8,1089
-mid37,mobile65,color6,1015
-mid89,mobile91,color3,1079
-mid9,mobile89,color5,10276
-mid65,mobile72,color4,10195
-mid94,mobile45,color7,10180
-mid62,mobile3,color9,10781
-mid81,mobile54,color3,10991
-mid27,mobile84,color9,10755
-mid83,mobile39,color4,10447
-mid80,mobile68,color0,10895
-mid83,mobile3,color0,10321
-mid46,mobile65,color8,10338
-mid77,mobile56,color7,10471
-mid48,mobile49,color6,10380
-mid38,mobile37,color1,10104
-mid16,mobile66,color5,10385
-mid11,mobile96,color0,1022
-mid14,mobile4,color6,106
-mid6,mobile0,color2,10981
-mid2,mobile38,color4,10254
-mid81,mobile46,color7,1027
-mid21,mobile8,color3,10425
-mid5,mobile24,color5,10960
-mid45,mobile75,color8,10419
-mid57,mobile50,color9,10789
-mid98,mobile44,color1,1082
-mid42,mobile97,color9,1063
-mid4,mobile4,color0,1097
-mid76,mobile1,color3,10344
-mid61,mobile9,color3,10146
-mid74,mobile66,color1,10314
-mid6,mobile4,color6,10858
-mid39,mobile88,color8,10255
-mid70,mobile92,color5,10882
-mid92,mobile90,color9,10174
-mid88,mobile67,color5,10939
-mid41,mobile6,color3,10447
-mid91,mobile93,color1,10192
-mid48,mobile84,color9,10325
-mid0,mobile44,color1,10536
-mid37,mobile0,color3,10244
-mid31,mobile96,color6,10783
-mid83,mobile90,color3,10614
-mid93,mobile73,color4,10689
-mid9,mobile66,color6,10602
-mid32,mobile25,color7,10325
-mid85,mobile77,color7,10366
-mid35,mobile79,color2,10930
-mid7,mobile28,color1,10458
-mid14,mobile3,color4,10349
-mid51,mobile88,color7,10867
-mid91,mobile65,color4,10289
-mid28,mobile2,color9,10463
-mid3,mobile91,color0,10981
-mid67,mobile14,color7,10945
-mid24,mobile4,color2,10688
-mid67,mobile98,color3,10532
-mid60,mobile24,color2,10611
-mid75,mobile25,color9,10323
-mid73,mobile4,color9,10219
-mid59,mobile53,color2,10532
-mid70,mobile95,color5,10384
-mid80,mobile58,color7,107
-mid35,mobile34,color1,10771
-mid61,mobile29,color4,10605
-mid59,mobile91,color9,10238
-mid0,mobile70,color6,10358
-mid32,mobile95,color4,10321
-mid89,mobile18,color5,10905
-mid55,mobile47,color7,10782
-mid95,mobile40,color0,10830
-mid58,mobile9,color8,10286
-mid44,mobile67,color6,10763
-mid26,mobile16,color4,10874
-mid17,mobile93,color8,10559
-mid62,mobile22,color0,10303
-mid40,mobile72,color4,10459
-mid64,mobile30,color5,10961
-mid33,mobile5,color3,10222
-mid84,mobile37,color2,10142
-mid96,mobile79,color9,10286
-mid32,mobile52,color9,10888
-mid15,mobile97,color6,10281
-mid39,mobile58,color0,1067
-mid74,mobile4,color4,10541
-mid96,mobile40,color5,10870
-mid24,mobile32,color2,10912
-mid78,mobile2,color6,10313
-mid48,mobile25,color5,10311
-mid37,mobile65,color2,10960
-mid85,mobile52,color4,1044
-mid6,mobile24,color2,10157
-mid95,mobile39,color9,10982
-mid10,mobile55,color5,10283
-mid72,mobile78,color9,10935
-mid77,mobile34,color1,10882
-mid95,mobile51,color3,10820
-mid47,mobile38,color1,10561
-mid78,mobile86,color4,10351
-mid25,mobile91,color8,10608
-mid35,mobile45,color7,10255
-mid92,mobile7,color0,10530
-mid46,mobile18,color1,10648
-mid85,mobile47,color0,10875
-mid44,mobile44,color4,10592
-mid93,mobile44,color1,10267
-mid87,mobile92,color2,10253
-mid28,mobile77,color0,10415
-mid42,mobile99,color2,10764
-mid25,mobile23,color0,10468
-mid54,mobile75,color7,10395
-mid2,mobile65,color9,10320
-mid27,mobile12,color9,10533
-mid35,mobile41,color8,10580
-mid19,mobile7,color1,102
-mid41,mobile6,color0,10880
-mid33,mobile90,color0,1072
-mid90,mobile25,color8,10655
-mid59,mobile10,color6,10961
-mid39,mobile59,color4,10170
-mid7,mobile57,color4,10427
-mid84,mobile25,color5,10823
-mid91,mobile21,color0,10589
-mid47,mobile6,color8,10780
-mid60,mobile35,color2,10291
-mid30,mobile42,color3,10432
-mid91,mobile54,color7,10165
-mid10,mobile79,color5,10513
-mid79,mobile73,color0,10359
-mid70,mobile43,color7,10749
-mid46,mobile80,color6,10685
-mid14,mobile23,color5,10348
-mid19,mobile40,color0,10965
-mid52,mobile51,color9,10313
-mid81,mobile89,color0,10998
-mid5,mobile25,color5,101
-mid31,mobile91,color1,10271
-mid5,mobile52,color2,10488
-mid75,mobile88,color2,10486
-mid76,mobile52,color8,10381
-mid11,mobile6,color2,10962
-mid19,mobile44,color6,10740
-mid85,mobile87,color7,10993
-mid43,mobile11,color8,10702
-mid51,mobile29,color8,10699
-mid71,mobile67,color1,1083
-mid67,mobile11,color0,10291
-mid58,mobile11,color8,10220
-mid43,mobile43,color8,10469
-mid25,mobile8,color6,10189
-mid96,mobile19,color6,10800
-mid67,mobile31,color7,10279
-mid44,mobile12,color1,10859
-mid53,mobile81,color4,10947
-mid22,mobile48,color3,10379
-mid35,mobile32,color8,10162
-mid37,mobile2,color3,10438
-mid99,mobile75,color1,10803
-mid78,mobile60,color2,10175
-mid35,mobile59,color0,10789
-mid83,mobile25,color5,10572
-mid36,mobile35,color8,10344
-mid51,mobile54,color9,10765
-mid43,mobile87,color7,10881
-mid5,mobile95,color6,10534
-mid1,mobile22,color8,10806
-mid5,mobile65,color8,10563
-mid22,mobile91,color5,10821
-mid63,mobile83,color4,10677
-mid57,mobile59,color8,10716
-mid86,mobile3,color7,10229
-mid61,mobile45,color4,10461
-mid54,mobile5,color6,10672
-mid42,mobile54,color9,10618
-mid49,mobile19,color1,10731
-mid66,mobile66,color8,10818
-mid92,mobile80,color5,10924
-mid93,mobile94,color2,10554
-mid39,mobile8,color0,10103
-mid97,mobile22,color3,1084
-mid58,mobile44,color0,10728
-mid63,mobile33,color0,10843
-mid19,mobile37,color7,10369
-mid86,mobile21,color6,10875
-mid80,mobile75,color3,10859
-mid89,mobile32,color3,10856
-mid77,mobile89,color5,10193
-mid14,mobile60,color8,10302
-mid44,mobile71,color1,10837
-mid44,mobile10,color5,10167
-mid24,mobile46,color0,10304
-mid41,mobile10,color2,10578
-mid55,mobile53,color9,10183
-mid34,mobile50,color8,10949
-mid30,mobile15,color9,10179
-mid77,mobile99,color0,10132
-mid77,mobile73,color9,10239
-mid65,mobile53,color6,1038
-mid93,mobile92,color0,10100
-mid52,mobile38,color8,10810
-mid72,mobile46,color4,10988
-mid73,mobile38,color0,10859
-mid79,mobile67,color3,10751
-mid0,mobile58,color8,10900
-mid49,mobile77,color9,10243
-mid22,mobile16,color5,10836
-mid66,mobile77,color5,10663
-mid95,mobile63,color1,10128
-mid71,mobile26,color8,10964
-mid84,mobile34,color0,10213
-mid98,mobile98,color3,10555
-mid99,mobile72,color3,10635
-mid52,mobile91,color5,10268
-mid30,mobile82,color6,10950
-mid4,mobile89,color5,10528
-mid68,mobile94,color3,10803
-mid34,mobile22,color2,10335
-mid51,mobile1,color3,10617
-mid14,mobile4,color8,10555
-mid9,mobile68,color6,1089
-mid55,mobile14,color8,10793
-mid67,mobile12,color8,10584
-mid53,mobile81,color2,10259
-mid58,mobile65,color5,10268
-mid94,mobile62,color1,10258
-mid67,mobile75,color7,10511
-mid98,mobile55,color9,10481
-mid72,mobile94,color8,10600
-mid3,mobile98,color4,10644
-mid96,mobile74,color6,10229
-mid89,mobile52,color1,10614

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/lessthandatacolumndata.csv
----------------------------------------------------------------------
diff --git a/integration/spark/src/test/resources/lessthandatacolumndata.csv 
b/integration/spark/src/test/resources/lessthandatacolumndata.csv
deleted file mode 100644
index 98f0daf..0000000
--- a/integration/spark/src/test/resources/lessthandatacolumndata.csv
+++ /dev/null
@@ -1,11 +0,0 @@
-ID,date,country,name,phonetype,serialname,salary
-1,2015/7/23,china,aaa1,phone197,ASD69643,15000
-2,2015/7/24,china,aaa2,phone756,ASD42892,15001
-3,2015/7/25,china
-4,2015/7/26,china,aaa4,phone2435,ASD66902,15003
-5,2015/7/27,china,aaa5,phone2441,ASD90633,15004
-6,2015/7/28,china,aaa6,phone294,ASD59961,15005
-7,2015/7/29,china,aaa7,phone610,
-8,2015/7/30,china,aaa8,phone1848,ASD57308,15007
-9,2015/7/18,china,aaa9,phone706,ASD86717,15008
-10,2015/7/19,usa,aaa10,phone685,ASD30505,15009
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/loadMultiFiles/.invisibilityfile
----------------------------------------------------------------------
diff --git 
a/integration/spark/src/test/resources/loadMultiFiles/.invisibilityfile 
b/integration/spark/src/test/resources/loadMultiFiles/.invisibilityfile
deleted file mode 100644
index c16bc10..0000000
--- a/integration/spark/src/test/resources/loadMultiFiles/.invisibilityfile
+++ /dev/null
@@ -1,3 +0,0 @@
-empno,empname,designation,doj,workgroupcategory,workgroupcategoryname,deptno,deptname,projectcode,projectjoindate,projectenddate,attendance,utilization,salary
-19,shivani,PL,12-05-2015,1,developer,10,network,928977,12-06-2015,12-11-2016,88,91.678,11254.24
-20,bill,PM,01-12-2015,3,manager,14,Learning,928479,01-01-2016,30-11-2016,75,94.22,13547.25

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/loadMultiFiles/_SUCCESS
----------------------------------------------------------------------
diff --git a/integration/spark/src/test/resources/loadMultiFiles/_SUCCESS 
b/integration/spark/src/test/resources/loadMultiFiles/_SUCCESS
deleted file mode 100644
index e69de29..0000000

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/loadMultiFiles/data.csv
----------------------------------------------------------------------
diff --git a/integration/spark/src/test/resources/loadMultiFiles/data.csv 
b/integration/spark/src/test/resources/loadMultiFiles/data.csv
deleted file mode 100644
index a5c8c5e..0000000
--- a/integration/spark/src/test/resources/loadMultiFiles/data.csv
+++ /dev/null
@@ -1,4 +0,0 @@
-empno,empname,designation,doj,workgroupcategory,workgroupcategoryname,deptno,deptname,projectcode,projectjoindate,projectenddate,attendance,utilization,salary
-11,arvind,SE,17-01-2007,1,developer,10,network,928478,17-02-2007,29-11-2016,96,96.2,5040.56
-12,krithin,SSE,29-05-2008,1,developer,11,protocol,928378,29-06-2008,30-12-2016,85,95.1,7124.21
-13,madhan,TPL,07-07-2009,2,tester,10,network,928478,07-08-2009,30-12-2016,88,99,9054.235

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/loadMultiFiles/emptyfile.csv
----------------------------------------------------------------------
diff --git a/integration/spark/src/test/resources/loadMultiFiles/emptyfile.csv 
b/integration/spark/src/test/resources/loadMultiFiles/emptyfile.csv
deleted file mode 100644
index e69de29..0000000

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/loadMultiFiles/nestedfolder1/data.csv
----------------------------------------------------------------------
diff --git 
a/integration/spark/src/test/resources/loadMultiFiles/nestedfolder1/data.csv 
b/integration/spark/src/test/resources/loadMultiFiles/nestedfolder1/data.csv
deleted file mode 100644
index 289c0c2..0000000
--- a/integration/spark/src/test/resources/loadMultiFiles/nestedfolder1/data.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-empno,empname,designation,doj,workgroupcategory,workgroupcategoryname,deptno,deptname,projectcode,projectjoindate,projectenddate,attendance,utilization,salary
-16,pramod,SE,14-10-2012,1,developer,13,configManagement,928478,14-11-2012,29-12-2016,86,93,5040.56

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/loadMultiFiles/nestedfolder1/data1.csv
----------------------------------------------------------------------
diff --git 
a/integration/spark/src/test/resources/loadMultiFiles/nestedfolder1/data1.csv 
b/integration/spark/src/test/resources/loadMultiFiles/nestedfolder1/data1.csv
deleted file mode 100644
index 68a5054..0000000
--- 
a/integration/spark/src/test/resources/loadMultiFiles/nestedfolder1/data1.csv
+++ /dev/null
@@ -1,3 +0,0 @@
-empno,empname,designation,doj,workgroupcategory,workgroupcategoryname,deptno,deptname,projectcode,projectjoindate,projectenddate,attendance,utilization,salary
-14,anandh,SA,29-12-2010,3,manager,11,protocol,928278,29-01-2011,29-06-2016,77,92.2,11248.25
-15,ayushi,SSA,09-11-2011,1,developer,12,security,928375,09-12-2011,29-05-2016,99,91.5,13245.48

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/loadMultiFiles/nestedfolder1/nestedfolder2/data.csv
----------------------------------------------------------------------
diff --git 
a/integration/spark/src/test/resources/loadMultiFiles/nestedfolder1/nestedfolder2/data.csv
 
b/integration/spark/src/test/resources/loadMultiFiles/nestedfolder1/nestedfolder2/data.csv
deleted file mode 100644
index e70c970..0000000
--- 
a/integration/spark/src/test/resources/loadMultiFiles/nestedfolder1/nestedfolder2/data.csv
+++ /dev/null
@@ -1,3 +0,0 @@
-empno,empname,designation,doj,workgroupcategory,workgroupcategoryname,deptno,deptname,projectcode,projectjoindate,projectenddate,attendance,utilization,salary
-17,gawrav,PL,22-09-2013,2,tester,12,security,928778,22-10-2013,15-11-2016,78,97.45,9574.24
-18,sibi,TL,15-08-2014,2,tester,14,Learning,928176,15-09-2014,29-05-2016,84,98.23,7245.25

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/loadMultiFiles/non-csv
----------------------------------------------------------------------
diff --git a/integration/spark/src/test/resources/loadMultiFiles/non-csv 
b/integration/spark/src/test/resources/loadMultiFiles/non-csv
deleted file mode 100644
index c16bc10..0000000
--- a/integration/spark/src/test/resources/loadMultiFiles/non-csv
+++ /dev/null
@@ -1,3 +0,0 @@
-empno,empname,designation,doj,workgroupcategory,workgroupcategoryname,deptno,deptname,projectcode,projectjoindate,projectenddate,attendance,utilization,salary
-19,shivani,PL,12-05-2015,1,developer,10,network,928977,12-06-2015,12-11-2016,88,91.678,11254.24
-20,bill,PM,01-12-2015,3,manager,14,Learning,928479,01-01-2016,30-11-2016,75,94.22,13547.25

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/locationInfoActiveCountry.csv
----------------------------------------------------------------------
diff --git a/integration/spark/src/test/resources/locationInfoActiveCountry.csv 
b/integration/spark/src/test/resources/locationInfoActiveCountry.csv
deleted file mode 100644
index c5f6c25..0000000
--- a/integration/spark/src/test/resources/locationInfoActiveCountry.csv
+++ /dev/null
@@ -1,9 +0,0 @@
-Chinese
-Chinese
-Chinese
-Chinese
-Chinese
-USA
-UK
-France
-Italy
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/mac.csv
----------------------------------------------------------------------
diff --git a/integration/spark/src/test/resources/mac.csv 
b/integration/spark/src/test/resources/mac.csv
deleted file mode 100644
index e96d5ca..0000000
--- a/integration/spark/src/test/resources/mac.csv
+++ /dev/null
@@ -1,39 +0,0 @@
-MAC165
-MAC168
-MAC171
-MAC174
-MAC177
-MAC180
-MAC183
-MAC186
-MAC189
-MAC262
-MAC263
-MAC265
-MAC266
-MAC268
-MAC269
-MAC271
-MAC272
-MAC274
-MAC275
-MAC277
-MAC278
-MAC280
-MAC281
-MAC283
-MAC284
-MAC285
-MAC286
-MAC287
-MAC288
-MAC289
-MAC290
-MAC291
-MAC292
-MAC292
-MAC293
-MAC294
-MAC295
-MAC296
-MAC400
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/mobileimei.csv
----------------------------------------------------------------------
diff --git a/integration/spark/src/test/resources/mobileimei.csv 
b/integration/spark/src/test/resources/mobileimei.csv
deleted file mode 100644
index 96fe34d..0000000
--- a/integration/spark/src/test/resources/mobileimei.csv
+++ /dev/null
@@ -1,24 +0,0 @@
-1AA100064
-1AA100065
-1AA100066
-1AA100067
-1AA100068
-1AA100069
-1AA10007
-1AA100070
-1AA100071
-1AA100072
-1AA100073
-1AA100074
-1AA100075
-1AA100076
-1AA100077
-1AA100078
-1AA100079
-1AA10008
-1AA100080
-1AA100081
-1AA100082
-1AA100083
-1AA100084
-1AA100000
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/noneCsvFormat.cs
----------------------------------------------------------------------
diff --git a/integration/spark/src/test/resources/noneCsvFormat.cs 
b/integration/spark/src/test/resources/noneCsvFormat.cs
deleted file mode 100644
index 95ba5f2..0000000
--- a/integration/spark/src/test/resources/noneCsvFormat.cs
+++ /dev/null
@@ -1,4 +0,0 @@
-Id,number,name,gamePoint,mac
-1,1.5,Mark,1.2$2,3
-2,2,Twin,2.0$3,1.5
-3,3.0,Betty,5$2.0,2
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/nullSample.csv
----------------------------------------------------------------------
diff --git a/integration/spark/src/test/resources/nullSample.csv 
b/integration/spark/src/test/resources/nullSample.csv
deleted file mode 100644
index e69de29..0000000

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/nullandnonparsableValue.csv
----------------------------------------------------------------------
diff --git a/integration/spark/src/test/resources/nullandnonparsableValue.csv 
b/integration/spark/src/test/resources/nullandnonparsableValue.csv
deleted file mode 100644
index 6647200..0000000
--- a/integration/spark/src/test/resources/nullandnonparsableValue.csv
+++ /dev/null
@@ -1,3 +0,0 @@
-1,2015-17-23 00:00:00,china,aaa1,phone197,ASD69643,15000.43525
-2,2015-7-23 00:00:00,china,aaa1,phone197,ASD69643,15000.43525fd
-3,

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/nullmeasurevalue.csv
----------------------------------------------------------------------
diff --git a/integration/spark/src/test/resources/nullmeasurevalue.csv 
b/integration/spark/src/test/resources/nullmeasurevalue.csv
deleted file mode 100644
index 8815bce..0000000
--- a/integration/spark/src/test/resources/nullmeasurevalue.csv
+++ /dev/null
@@ -1,11 +0,0 @@
-ID,date,country,name,phonetype,serialname,salary
-1,2015/7/23,china,aaa1,phone197,ASD69643, 
-2,2015/7/24,china,aaa2,phone756,ASD42892,
-3,2015/7/25,china,aaa3,phone1904,ASD37014,
-4,2015/7/26,china,aaa4,phone2435,ASD66902,
-5,2015/7/27,china,aaa5,phone2441,ASD90633,
-6,2015/7/28,china,aaa6,phone294,ASD59961,
-7,2015/7/29,china,aaa7,phone610,ASD14875,
-8,2015/7/30,china,aaa8,phone1848,ASD57308,
-9,2015/7/18,china,aaa9,phone706,ASD86717,
-10,2015/7/19,usa,aaa10,phone685,ASD30505,
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/nullvalueserialization.csv
----------------------------------------------------------------------
diff --git a/integration/spark/src/test/resources/nullvalueserialization.csv 
b/integration/spark/src/test/resources/nullvalueserialization.csv
deleted file mode 100644
index 9d1dba8..0000000
--- a/integration/spark/src/test/resources/nullvalueserialization.csv
+++ /dev/null
@@ -1,2 +0,0 @@
-1,2015-17-23 00:00:00,china,aaa1,phone197,ASD69643,15000.43525
-2,\N,\N,\N,\N,\N,\N

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/numerictypecube.xml
----------------------------------------------------------------------
diff --git a/integration/spark/src/test/resources/numerictypecube.xml 
b/integration/spark/src/test/resources/numerictypecube.xml
deleted file mode 100644
index 58b5644..0000000
--- a/integration/spark/src/test/resources/numerictypecube.xml
+++ /dev/null
@@ -1,41 +0,0 @@
-<!--
- ~ Licensed to the Apache Software Foundation (ASF) under one
- ~ or more contributor license agreements.  See the NOTICE file
- ~ distributed with this work for additional information
- ~ regarding copyright ownership.  The ASF licenses this file
- ~ to you under the Apache License, Version 2.0 (the
- ~ "License"); you may not use this file except in compliance
- ~ with the License.  You may obtain a copy of the License at
- ~
- ~    http://www.apache.org/licenses/LICENSE-2.0
- ~
- ~ Unless required by applicable law or agreed to in writing,
- ~ software distributed under the License is distributed on an
- ~ "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
- ~ KIND, either express or implied.  See the License for the
- ~ specific language governing permissions and limitations
- ~ under the License.
- -->
-
-<Schema name="default">
-    <Cube name="numerictypecube" visible="true" cache="true" enabled="true">
-        <Table name="numerictypecube" alias="">
-        </Table>
-        <Dimension type="StandardDimension" visible="true" 
highCardinality="false"
-                   name="utilization">
-            <Hierarchy name="utilization" hasAll="true" normalized="false">
-                <Level name="utilization" column="utilization" type="Numeric" 
levelType="Regular">
-                </Level>
-            </Hierarchy>
-        </Dimension>
-        <Dimension type="StandardDimension" visible="true" 
highCardinality="false" name="salary">
-            <Hierarchy name="salary" hasAll="true" normalized="false">
-                <Level name="salary" column="salary" type="Numeric" 
levelType="Regular">
-                </Level>
-            </Hierarchy>
-        </Dimension>
-        <Measure name="default_dummy_measure" column="default_dummy_measure" 
datatype="Numeric"
-                 aggregator="sum" visible="false">
-        </Measure>
-    </Cube>
-</Schema>
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/sample
----------------------------------------------------------------------
diff --git a/integration/spark/src/test/resources/sample 
b/integration/spark/src/test/resources/sample
deleted file mode 100644
index 7c57de7..0000000
--- a/integration/spark/src/test/resources/sample
+++ /dev/null
@@ -1,5 +0,0 @@
-id,name,city,age
-1,david,shenzhen,31
-2,eason,shenzhen,27
-3,jarry,wuhan,35
-3,jarry,Bangalore,35

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/sample.csv
----------------------------------------------------------------------
diff --git a/integration/spark/src/test/resources/sample.csv 
b/integration/spark/src/test/resources/sample.csv
deleted file mode 100644
index 7c57de7..0000000
--- a/integration/spark/src/test/resources/sample.csv
+++ /dev/null
@@ -1,5 +0,0 @@
-id,name,city,age
-1,david,shenzhen,31
-2,eason,shenzhen,27
-3,jarry,wuhan,35
-3,jarry,Bangalore,35

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark/src/test/resources/sample.csv.bz2
----------------------------------------------------------------------
diff --git a/integration/spark/src/test/resources/sample.csv.bz2 
b/integration/spark/src/test/resources/sample.csv.bz2
deleted file mode 100644
index 0c2417d..0000000
Binary files a/integration/spark/src/test/resources/sample.csv.bz2 and 
/dev/null differ


Reply via email to