carbondata-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jack...@apache.org
Subject [29/38] incubator-carbondata git commit: reuse test case for integration module
Date Sat, 07 Jan 2017 16:37:03 GMT
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark-common-test/src/test/resources/join/employee.csv
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/join/employee.csv b/integration/spark-common-test/src/test/resources/join/employee.csv
new file mode 100644
index 0000000..c551653
--- /dev/null
+++ b/integration/spark-common-test/src/test/resources/join/employee.csv
@@ -0,0 +1,1000 @@
+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-common-test/src/test/resources/join/mgr.csv
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/join/mgr.csv b/integration/spark-common-test/src/test/resources/join/mgr.csv
new file mode 100644
index 0000000..5ab1d83
--- /dev/null
+++ b/integration/spark-common-test/src/test/resources/join/mgr.csv
@@ -0,0 +1 @@
+harry,h2399,v788232,99823230205

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark-common-test/src/test/resources/join/mobile.csv
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/join/mobile.csv b/integration/spark-common-test/src/test/resources/join/mobile.csv
new file mode 100644
index 0000000..dc45fa0
--- /dev/null
+++ b/integration/spark-common-test/src/test/resources/join/mobile.csv
@@ -0,0 +1,1000 @@
+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-common-test/src/test/resources/lessthandatacolumndata.csv
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/lessthandatacolumndata.csv b/integration/spark-common-test/src/test/resources/lessthandatacolumndata.csv
new file mode 100644
index 0000000..98f0daf
--- /dev/null
+++ b/integration/spark-common-test/src/test/resources/lessthandatacolumndata.csv
@@ -0,0 +1,11 @@
+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-common-test/src/test/resources/loadMultiFiles/.invisibilityfile
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/loadMultiFiles/.invisibilityfile b/integration/spark-common-test/src/test/resources/loadMultiFiles/.invisibilityfile
new file mode 100644
index 0000000..c16bc10
--- /dev/null
+++ b/integration/spark-common-test/src/test/resources/loadMultiFiles/.invisibilityfile
@@ -0,0 +1,3 @@
+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-common-test/src/test/resources/loadMultiFiles/_SUCCESS
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/loadMultiFiles/_SUCCESS b/integration/spark-common-test/src/test/resources/loadMultiFiles/_SUCCESS
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark-common-test/src/test/resources/loadMultiFiles/data.csv
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/loadMultiFiles/data.csv b/integration/spark-common-test/src/test/resources/loadMultiFiles/data.csv
new file mode 100644
index 0000000..a5c8c5e
--- /dev/null
+++ b/integration/spark-common-test/src/test/resources/loadMultiFiles/data.csv
@@ -0,0 +1,4 @@
+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-common-test/src/test/resources/loadMultiFiles/emptyfile.csv
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/loadMultiFiles/emptyfile.csv b/integration/spark-common-test/src/test/resources/loadMultiFiles/emptyfile.csv
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark-common-test/src/test/resources/loadMultiFiles/nestedfolder1/data.csv
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/loadMultiFiles/nestedfolder1/data.csv b/integration/spark-common-test/src/test/resources/loadMultiFiles/nestedfolder1/data.csv
new file mode 100644
index 0000000..289c0c2
--- /dev/null
+++ b/integration/spark-common-test/src/test/resources/loadMultiFiles/nestedfolder1/data.csv
@@ -0,0 +1,2 @@
+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-common-test/src/test/resources/loadMultiFiles/nestedfolder1/data1.csv
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/loadMultiFiles/nestedfolder1/data1.csv b/integration/spark-common-test/src/test/resources/loadMultiFiles/nestedfolder1/data1.csv
new file mode 100644
index 0000000..68a5054
--- /dev/null
+++ b/integration/spark-common-test/src/test/resources/loadMultiFiles/nestedfolder1/data1.csv
@@ -0,0 +1,3 @@
+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-common-test/src/test/resources/loadMultiFiles/nestedfolder1/nestedfolder2/data.csv
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/loadMultiFiles/nestedfolder1/nestedfolder2/data.csv b/integration/spark-common-test/src/test/resources/loadMultiFiles/nestedfolder1/nestedfolder2/data.csv
new file mode 100644
index 0000000..e70c970
--- /dev/null
+++ b/integration/spark-common-test/src/test/resources/loadMultiFiles/nestedfolder1/nestedfolder2/data.csv
@@ -0,0 +1,3 @@
+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-common-test/src/test/resources/loadMultiFiles/non-csv
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/loadMultiFiles/non-csv b/integration/spark-common-test/src/test/resources/loadMultiFiles/non-csv
new file mode 100644
index 0000000..c16bc10
--- /dev/null
+++ b/integration/spark-common-test/src/test/resources/loadMultiFiles/non-csv
@@ -0,0 +1,3 @@
+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-common-test/src/test/resources/locationInfoActiveCountry.csv
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/locationInfoActiveCountry.csv b/integration/spark-common-test/src/test/resources/locationInfoActiveCountry.csv
new file mode 100644
index 0000000..c5f6c25
--- /dev/null
+++ b/integration/spark-common-test/src/test/resources/locationInfoActiveCountry.csv
@@ -0,0 +1,9 @@
+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-common-test/src/test/resources/mac.csv
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/mac.csv b/integration/spark-common-test/src/test/resources/mac.csv
new file mode 100644
index 0000000..e96d5ca
--- /dev/null
+++ b/integration/spark-common-test/src/test/resources/mac.csv
@@ -0,0 +1,39 @@
+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-common-test/src/test/resources/mobileimei.csv
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/mobileimei.csv b/integration/spark-common-test/src/test/resources/mobileimei.csv
new file mode 100644
index 0000000..96fe34d
--- /dev/null
+++ b/integration/spark-common-test/src/test/resources/mobileimei.csv
@@ -0,0 +1,24 @@
+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-common-test/src/test/resources/noneCsvFormat.cs
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/noneCsvFormat.cs b/integration/spark-common-test/src/test/resources/noneCsvFormat.cs
new file mode 100644
index 0000000..95ba5f2
--- /dev/null
+++ b/integration/spark-common-test/src/test/resources/noneCsvFormat.cs
@@ -0,0 +1,4 @@
+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-common-test/src/test/resources/nullSample.csv
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/nullSample.csv b/integration/spark-common-test/src/test/resources/nullSample.csv
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/af2f204e/integration/spark-common-test/src/test/resources/nullandnonparsableValue.csv
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/nullandnonparsableValue.csv b/integration/spark-common-test/src/test/resources/nullandnonparsableValue.csv
new file mode 100644
index 0000000..6647200
--- /dev/null
+++ b/integration/spark-common-test/src/test/resources/nullandnonparsableValue.csv
@@ -0,0 +1,3 @@
+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-common-test/src/test/resources/nullmeasurevalue.csv
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/nullmeasurevalue.csv b/integration/spark-common-test/src/test/resources/nullmeasurevalue.csv
new file mode 100644
index 0000000..8815bce
--- /dev/null
+++ b/integration/spark-common-test/src/test/resources/nullmeasurevalue.csv
@@ -0,0 +1,11 @@
+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-common-test/src/test/resources/nullvalueserialization.csv
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/nullvalueserialization.csv b/integration/spark-common-test/src/test/resources/nullvalueserialization.csv
new file mode 100644
index 0000000..9d1dba8
--- /dev/null
+++ b/integration/spark-common-test/src/test/resources/nullvalueserialization.csv
@@ -0,0 +1,2 @@
+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-common-test/src/test/resources/numerictypecube.xml
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/numerictypecube.xml b/integration/spark-common-test/src/test/resources/numerictypecube.xml
new file mode 100644
index 0000000..58b5644
--- /dev/null
+++ b/integration/spark-common-test/src/test/resources/numerictypecube.xml
@@ -0,0 +1,41 @@
+<!--
+ ~ 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-common-test/src/test/resources/sample
----------------------------------------------------------------------
diff --git a/integration/spark-common-test/src/test/resources/sample b/integration/spark-common-test/src/test/resources/sample
new file mode 100644
index 0000000..7c57de7
--- /dev/null
+++ b/integration/spark-common-test/src/test/resources/sample
@@ -0,0 +1,5 @@
+id,name,city,age
+1,david,shenzhen,31
+2,eason,shenzhen,27
+3,jarry,wuhan,35
+3,jarry,Bangalore,35



Mime
View raw message