carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "SWATI RAO (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CARBONDATA-711) Inconsistent data load when single_pass='true'
Date Wed, 22 Feb 2017 10:19:53 GMT

     [ https://issues.apache.org/jira/browse/CARBONDATA-711?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

SWATI RAO updated CARBONDATA-711:
---------------------------------
    Description: 
 When we perform dataload with Single_pass='true' , it repeats some of the values in the table whereas the csv contains empty value for that column. PFA csv which is used for dataloading. And below is the create , load . and select query.


CREATE TABLE uniq_shared_dictionary (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB timestamp, DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('DICTIONARY_INCLUDE'='CUST_ID,Double_COLUMN2,DECIMAL_COLUMN2')



 LOAD DATA INPATH 'hdfs://192.168.2.145:54310/BabuStore/Data/uniqdata/2000_UniqData.csv' into table uniq_shared_dictionary OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"','BAD_RECORDS_LOGGER_ENABLE'='TRUE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1','SINGLE_Pass'='true') ;

Output: 
0: jdbc:hive2://hadoop-master:10000> select CUST_ID from uniq_shared_dictionary ;
+----------+--+
| Cust_Id  |
+----------+--+
| 8999     |
| 8999     |
| 8999     |
| 8999     |
| 8999     |
| 8999     |
| 8999     |
| 8999     |
| 8999     |
| 8999     |
| 8999     |
| 8999     |
| 9000     |
| 9001     |
| 9002     |
| 9003     |
| 9004     |
| 9005     |
| 9006     |
| 9007     |
| 9008     |
| 9009     |
| 9010     |
| 9011     |
| 9012     |
| 9013     |
| 9014     |
| 9015     |
| 9016     |
| 9017     |
| 9018     |
| 9019     |
| 9020     |
| 9021     |
| 9022     |
| 9023     |
| 9024     |
| 9025     |
| 9026     |
| 9027     |
| 9028     |
| 9029     |
| 9030     |
| 9031     |
| 9032     |
| 9033     |
| 9034     |
| 9035     |
| 9036     |
| 9037     |
| 9038     |
| 9039     |
| 9040     |
| 9041     |
| 9042     |
| 9043     |
| 9044     |
| 9045     |
| 9046     |
| 9047     |
| 9048     |
| 9049     |
| 9050     |
| 9051     |
| 9052     |
| 9053     |
| 9054     |
| 9055     |
| 9056     |
| 9057     |
| 9058     |
| 9059     |
| 9060     |
| 9061     |
| 9062     |
| 9063     |
| 9064     |
| 9065     |
| 9066     |
| 9067     |
| 9068     |
| 9069     |
| 9070     |
| 9071     |
| 9072     |
| 9073     |
| 9074     |
| 9075     |
| 9076     |
| 9077     |
| 9078     |
| 9079     |
| 9080     |
| 9081     |
| 9082     |
| 9083     |
| 9084     |
| 9085     |
| 9086     |
| 9087     |
+----------+--+
| Cust_Id  |
+----------+--+
| 9088     |
| 9089     |
| 9090     |
| 9091     |
| 9092     |
| 9093     |
| 9094     |
| 9095     |
| 9096     |
| 9097     |
| 9098     |
| 9099     |
| 9100     |
| 9101     |
| 9102     |
| 9103     |
| 9104     |
| 9105     |
| 9106     |
| 9107     |
| 9108     |
| 9109     |
| 9110     |
| 9111     |
| 9112     |
| 9113     |
| 9114     |
| 9115     |
| 9116     |
| 9117     |
| 9118     |
| 9119     |
| 9120     |
| 9121     |
| 9122     |
| 9123     |
| 9124     |
| 9125     |
| 9126     |
| 9127     |
| 9128     |
| 9129     |
| 9130     |
| 9131     |
| 9132     |
| 9133     |
| 9134     |
| 9135     |
| 9136     |
| 9137     |
| 9138     |
| 9139     |
| 9140     |
| 9141     |
| 9142     |
| 9143     |
| 9144     |
| 9145     |
| 9146     |
| 9147     |
| 9148     |
| 9149     |
| 9150     |
| 9151     |
| 9152     |
| 9153     |
| 9154     |
| 9155     |
| 9156     |
| 9157     |
| 9158     |
| 9159     |
| 9160     |
| 9161     |
| 9162     |
| 9163     |
| 9164     |
| 9165     |
| 9166     |
| 9167     |
| 9168     |
| 9169     |
| 9170     |
| 9171     |
| 9172     |
| 9173     |
| 9174     |
| 9175     |
| 9176     |
| 9177     |
| 9178     |
| 9179     |
| 9180     |
| 9181     |
| 9182     |
| 9183     |
| 9184     |
| 9185     |
| 9186     |
| 9187     |
+----------+--+
| Cust_Id  |
+----------+--+
| 9188     |
| 9189     |
| 9190     |
| 9191     |
| 9192     |
| 9193     |
| 9194     |
| 9195     |
| 9196     |
| 9197     |
| 9198     |
| 9199     |
| 9200     |
| 9201     |
| 9202     |
| 9203     |
| 9204     |
| 9205     |
| 9206     |
| 9207     |
| 9208     |
| 9209     |
| 9210     |
| 9211     |
| 9212     |
| 9213     |
| 9214     |
| 9215     |
| 9216     |
| 9217     |
| 9218     |
| 9219     |
| 9220     |
| 9221     |
| 9222     |
| 9223     |
| 9224     |
| 9225     |
| 9226     |
| 9227     |
| 9228     |
| 9229     |
| 9230     |
| 9231     |
| 9232     |
| 9233     |
| 9234     |
| 9235     |
| 9236     |
| 9237     |
| 9238     |
| 9239     |
| 9240     |
| 9241     |
| 9242     |
| 9243     |
| 9244     |
| 9245     |
| 9246     |
| 9247     |
| 9248     |
| 9249     |
| 9250     |
| 9251     |
| 9252     |
| 9253     |
| 9254     |
| 9255     |
| 9256     |
| 9257     |
| 9258     |
| 9259     |
| 9260     |
| 9261     |
| 9262     |
| 9263     |
| 9264     |
| 9265     |
| 9266     |
| 9267     |
| 9268     |
| 9269     |
| 9270     |
| 9271     |
| 9272     |
| 9273     |
| 9274     |
| 9275     |
| 9276     |
| 9277     |
| 9278     |
| 9279     |
| 9280     |
| 9281     |
| 9282     |
| 9283     |
| 9284     |
| 9285     |
| 9286     |
| 9287     |
+----------+--+
| Cust_Id  |
+----------+--+
| 9288     |
| 9289     |
| 9290     |
| 9291     |
| 9292     |
| 9293     |
| 9294     |
| 9295     |
| 9296     |
| 9297     |
| 9298     |
| 9299     |
| 9300     |
| 9301     |
| 9302     |
| 9303     |
| 9304     |
| 9305     |
| 9306     |
| 9307     |
| 9308     |
| 9309     |
| 9310     |
| 9311     |
| 9312     |
| 9313     |
| 9314     |
| 9315     |
| 9316     |
| 9317     |
| 9318     |
| 9319     |
| 9320     |
| 9321     |
| 9322     |
| 9323     |
| 9324     |
| 9325     |
| 9326     |
| 9327     |
| 9328     |
| 9329     |
| 9330     |
| 9331     |
| 9332     |
| 9333     |
| 9334     |
| 9335     |
| 9336     |
| 9337     |
| 9338     |
| 9339     |
| 9340     |
| 9341     |
| 9342     |
| 9343     |
| 9344     |
| 9345     |
| 9346     |
| 9347     |
| 9348     |
| 9349     |
| 9350     |
| 9351     |
| 9352     |
| 9353     |
| 9354     |
| 9355     |
| 9356     |
| 9357     |
| 9358     |
| 9359     |
| 9360     |
| 9361     |
| 9362     |
| 9363     |
| 9364     |
| 9365     |
| 9366     |
| 9367     |
| 9368     |
| 9369     |
| 9370     |
| 9371     |
| 9372     |
| 9373     |
| 9374     |
| 9375     |
| 9376     |
| 9377     |
| 9378     |
| 9379     |
| 9380     |
| 9381     |
| 9382     |
| 9383     |
| 9384     |
| 9385     |
| 9386     |
| 9387     |
+----------+--+
| Cust_Id  |
+----------+--+
| 9388     |
| 9389     |
| 9390     |
| 9391     |
| 9392     |
| 9393     |
| 9394     |
| 9395     |
| 9396     |
| 9397     |
| 9398     |
| 9399     |
| 9400     |
| 9401     |
| 9402     |
| 9403     |
| 9404     |
| 9405     |
| 9406     |
| 9407     |
| 9408     |
| 9409     |
| 9410     |
| 9411     |
| 9412     |
| 9413     |
| 9414     |
| 9415     |
| 9416     |
| 9417     |
| 9418     |
| 9419     |
| 9420     |
| 9421     |
| 9422     |
| 9423     |
| 9424     |
| 9425     |
| 9426     |
| 9427     |
| 9428     |
| 9429     |
| 9430     |
| 9431     |
| 9432     |
| 9433     |
| 9434     |
| 9435     |
| 9436     |
| 9437     |
| 9438     |
| 9439     |
| 9440     |
| 9441     |
| 9442     |
| 9443     |
| 9444     |
| 9445     |
| 9446     |
| 9447     |
| 9448     |
| 9449     |
| 9450     |
| 9451     |
| 9452     |
| 9453     |
| 9454     |
| 9455     |
| 9456     |
| 9457     |
| 9458     |
| 9459     |
| 9460     |
| 9461     |
| 9462     |
| 9463     |
| 9464     |
| 9465     |
| 9466     |
| 9467     |
| 9468     |
| 9469     |
| 9470     |
| 9471     |
| 9472     |
| 9473     |
| 9474     |
| 9475     |
| 9476     |
| 9477     |
| 9478     |
| 9479     |
| 9480     |
| 9481     |
| 9482     |
| 9483     |
| 9484     |
| 9485     |
| 9486     |
| 9487     |
+----------+--+
| Cust_Id  |
+----------+--+
| 9488     |
| 9489     |
| 9490     |
| 9491     |
| 9492     |
| 9493     |
| 9494     |
| 9495     |
| 9496     |
| 9497     |
| 9498     |
| 9499     |
| 9500     |
| 9501     |
| 9502     |
| 9503     |
| 9504     |
| 9505     |
| 9506     |
| 9507     |
| 9508     |
| 9509     |
| 9510     |
| 9511     |
| 9512     |
| 9513     |
| 9514     |
| 9515     |
| 9516     |
| 9517     |
| 9518     |
| 9519     |
| 9520     |
| 9521     |
| 9522     |
| 9523     |
| 9524     |
| 9525     |
| 9526     |
| 9527     |
| 9528     |
| 9529     |
| 9530     |
| 9531     |
| 9532     |
| 9533     |
| 9534     |
| 9535     |
| 9536     |
| 9537     |
| 9538     |
| 9539     |
| 9540     |
| 9541     |
| 9542     |
| 9543     |
| 9544     |
| 9545     |
| 9546     |
| 9547     |
| 9548     |
| 9549     |
| 9550     |
| 9551     |
| 9552     |
| 9553     |
| 9554     |
| 9555     |
| 9556     |
| 9557     |
| 9558     |
| 9559     |
| 9560     |
| 9561     |
| 9562     |
| 9563     |
| 9564     |
| 9565     |
| 9566     |
| 9567     |
| 9568     |
| 9569     |
| 9570     |
| 9571     |
| 9572     |
| 9573     |
| 9574     |
| 9575     |
| 9576     |
| 9577     |
| 9578     |
| 9579     |
| 9580     |
| 9581     |
| 9582     |
| 9583     |
| 9584     |
| 9585     |
| 9586     |
| 9587     |
+----------+--+
| Cust_Id  |
+----------+--+
| 9588     |
| 9589     |
| 9590     |
| 9591     |
| 9592     |
| 9593     |
| 9594     |
| 9595     |
| 9596     |
| 9597     |
| 9598     |
| 9599     |
| 9600     |
| 9601     |
| 9602     |
| 9603     |
| 9604     |
| 9605     |
| 9606     |
| 9607     |
| 9608     |
| 9609     |
| 9610     |
| 9611     |
| 9612     |
| 9613     |
| 9614     |
| 9615     |
| 9616     |
| 9617     |
| 9618     |
| 9619     |
| 9620     |
| 9621     |
| 9622     |
| 9623     |
| 9624     |
| 9625     |
| 9626     |
| 9627     |
| 9628     |
| 9629     |
| 9630     |
| 9631     |
| 9632     |
| 9633     |
| 9634     |
| 9635     |
| 9636     |
| 9637     |
| 9638     |
| 9639     |
| 9640     |
| 9641     |
| 9642     |
| 9643     |
| 9644     |
| 9645     |
| 9646     |
| 9647     |
| 9648     |
| 9649     |
| 9650     |
| 9651     |
| 9652     |
| 9653     |
| 9654     |
| 9655     |
| 9656     |
| 9657     |
| 9658     |
| 9659     |
| 9660     |
| 9661     |
| 9662     |
| 9663     |
| 9664     |
| 9665     |
| 9666     |
| 9667     |
| 9668     |
| 9669     |
| 9670     |
| 9671     |
| 9672     |
| 9673     |
| 9674     |
| 9675     |
| 9676     |
| 9677     |
| 9678     |
| 9679     |
| 9680     |
| 9681     |
| 9682     |
| 9683     |
| 9684     |
| 9685     |
| 9686     |
| 9687     |
+----------+--+
| Cust_Id  |
+----------+--+
| 9688     |
| 9689     |
| 9690     |
| 9691     |
| 9692     |
| 9693     |
| 9694     |
| 9695     |
| 9696     |
| 9697     |
| 9698     |
| 9699     |
| 9700     |
| 9701     |
| 9702     |
| 9703     |
| 9704     |
| 9705     |
| 9706     |
| 9707     |
| 9708     |
| 9709     |
| 9710     |
| 9711     |
| 9712     |
| 9713     |
| 9714     |
| 9715     |
| 9716     |
| 9717     |
| 9718     |
| 9719     |
| 9720     |
| 9721     |
| 9722     |
| 9723     |
| 9724     |
| 9725     |
| 9726     |
| 9727     |
| 9728     |
| 9729     |
| 9730     |
| 9731     |
| 9732     |
| 9733     |
| 9734     |
| 9735     |
| 9736     |
| 9737     |
| 9738     |
| 9739     |
| 9740     |
| 9741     |
| 9742     |
| 9743     |
| 9744     |
| 9745     |
| 9746     |
| 9747     |
| 9748     |
| 9749     |
| 9750     |
| 9751     |
| 9752     |
| 9753     |
| 9754     |
| 9755     |
| 9756     |
| 9757     |
| 9758     |
| 9759     |
| 9760     |
| 9761     |
| 9762     |
| 9763     |
| 9764     |
| 9765     |
| 9766     |
| 9767     |
| 9768     |
| 9769     |
| 9770     |
| 9771     |
| 9772     |
| 9773     |
| 9774     |
| 9775     |
| 9776     |
| 9777     |
| 9778     |
| 9779     |
| 9780     |
| 9781     |
| 9782     |
| 9783     |
| 9784     |
| 9785     |
| 9786     |
| 9787     |
+----------+--+
| Cust_Id  |
+----------+--+
| 9788     |
| 9789     |
| 9790     |
| 9791     |
| 9792     |
| 9793     |
| 9794     |
| 9795     |
| 9796     |
| 9797     |
| 9798     |
| 9799     |
| 9800     |
| 9801     |
| 9802     |
| 9803     |
| 9804     |
| 9805     |
| 9806     |
| 9807     |
| 9808     |
| 9809     |
| 9810     |
| 9811     |
| 9812     |
| 9813     |
| 9814     |
| 9815     |
| 9816     |
| 9817     |
| 9818     |
| 9819     |
| 9820     |
| 9821     |
| 9822     |
| 9823     |
| 9824     |
| 9825     |
| 9826     |
| 9827     |
| 9828     |
| 9829     |
| 9830     |
| 9831     |
| 9832     |
| 9833     |
| 9834     |
| 9835     |
| 9836     |
| 9837     |
| 9838     |
| 9839     |
| 9840     |
| 9841     |
| 9842     |
| 9843     |
| 9844     |
| 9845     |
| 9846     |
| 9847     |
| 9848     |
| 9849     |
| 9850     |
| 9851     |
| 9852     |
| 9853     |
| 9854     |
| 9855     |
| 9856     |
| 9857     |
| 9858     |
| 9859     |
| 9860     |
| 9861     |
| 9862     |
| 9863     |
| 9864     |
| 9865     |
| 9866     |
| 9867     |
| 9868     |
| 9869     |
| 9870     |
| 9871     |
| 9872     |
| 9873     |
| 9874     |
| 9875     |
| 9876     |
| 9877     |
| 9878     |
| 9879     |
| 9880     |
| 9881     |
| 9882     |
| 9883     |
| 9884     |
| 9885     |
| 9886     |
| 9887     |
+----------+--+
| Cust_Id  |
+----------+--+
| 9888     |
| 9889     |
| 9890     |
| 9891     |
| 9892     |
| 9893     |
| 9894     |
| 9895     |
| 9896     |
| 9897     |
| 9898     |
| 9899     |
| 9900     |
| 9901     |
| 9902     |
| 9903     |
| 9904     |
| 9905     |
| 9906     |
| 9907     |
| 9908     |
| 9909     |
| 9910     |
| 9911     |
| 9912     |
| 9913     |
| 9914     |
| 9915     |
| 9916     |
| 9917     |
| 9918     |
| 9919     |
| 9920     |
| 9921     |
| 9922     |
| 9923     |
| 9924     |
| 9925     |
| 9926     |
| 9927     |
| 9928     |
| 9929     |
| 9930     |
| 9931     |
| 9932     |
| 9933     |
| 9934     |
| 9935     |
| 9936     |
| 9937     |
| 9938     |
| 9939     |
| 9940     |
| 9941     |
| 9942     |
| 9943     |
| 9944     |
| 9945     |
| 9946     |
| 9947     |
| 9948     |
| 9949     |
| 9950     |
| 9951     |
| 9952     |
| 9953     |
| 9954     |
| 9955     |
| 9956     |
| 9957     |
| 9958     |
| 9959     |
| 9960     |
| 9961     |
| 9962     |
| 9963     |
| 9964     |
| 9965     |
| 9966     |
| 9967     |
| 9968     |
| 9969     |
| 9970     |
| 9971     |
| 9972     |
| 9973     |
| 9974     |
| 9975     |
| 9976     |
| 9977     |
| 9978     |
| 9979     |
| 9980     |
| 9981     |
| 9982     |
| 9983     |
| 9984     |
| 9985     |
| 9986     |
| 9987     |
+----------+--+
| Cust_Id  |
+----------+--+
| 9988     |
| 9989     |
| 9990     |
| 9991     |
| 9992     |
| 9993     |
| 9994     |
| 9995     |
| 9996     |
| 9997     |
| 9998     |
| 9999     |
| 10000    |
| 10001    |
| 10002    |
| 10003    |
| 10004    |
| 10005    |
| 10006    |
| 10007    |
| 10008    |
| 10009    |
| 10010    |
| 10011    |
| 10012    |
| 10013    |
| 10014    |
| 10015    |
| 10016    |
| 10017    |
| 10018    |
| 10019    |
| 10020    |
| 10021    |
| 10022    |
| 10023    |
| 10024    |
| 10025    |
| 10026    |
| 10027    |
| 10028    |
| 10029    |
| 10030    |
| 10031    |
| 10032    |
| 10033    |
| 10034    |
| 10035    |
| 10036    |
| 10037    |
| 10038    |
| 10039    |
| 10040    |
| 10041    |
| 10042    |
| 10043    |
| 10044    |
| 10045    |
| 10046    |
| 10047    |
| 10048    |
| 10049    |
| 10050    |
| 10051    |
| 10052    |
| 10053    |
| 10054    |
| 10055    |
| 10056    |
| 10057    |
| 10058    |
| 10059    |
| 10060    |
| 10061    |
| 10062    |
| 10063    |
| 10064    |
| 10065    |
| 10066    |
| 10067    |
| 10068    |
| 10069    |
| 10070    |
| 10071    |
| 10072    |
| 10073    |
| 10074    |
| 10075    |
| 10076    |
| 10077    |
| 10078    |
| 10079    |
| 10080    |
| 10081    |
| 10082    |
| 10083    |
| 10084    |
| 10085    |
| 10086    |
| 10087    |
+----------+--+
| Cust_Id  |
+----------+--+
| 10088    |
| 10089    |
| 10090    |
| 10091    |
| 10092    |
| 10093    |
| 10094    |
| 10095    |
| 10096    |
| 10097    |
| 10098    |
| 10099    |
| 10100    |
| 10101    |
| 10102    |
| 10103    |
| 10104    |
| 10105    |
| 10106    |
| 10107    |
| 10108    |
| 10109    |
| 10110    |
| 10111    |
| 10112    |
| 10113    |
| 10114    |
| 10115    |
| 10116    |
| 10117    |
| 10118    |
| 10119    |
| 10120    |
| 10121    |
| 10122    |
| 10123    |
| 10124    |
| 10125    |
| 10126    |
| 10127    |
| 10128    |
| 10129    |
| 10130    |
| 10131    |
| 10132    |
| 10133    |
| 10134    |
| 10135    |
| 10136    |
| 10137    |
| 10138    |
| 10139    |
| 10140    |
| 10141    |
| 10142    |
| 10143    |
| 10144    |
| 10145    |
| 10146    |
| 10147    |
| 10148    |
| 10149    |
| 10150    |
| 10151    |
| 10152    |
| 10153    |
| 10154    |
| 10155    |
| 10156    |
| 10157    |
| 10158    |
| 10159    |
| 10160    |
| 10161    |
| 10162    |
| 10163    |
| 10164    |
| 10165    |
| 10166    |
| 10167    |
| 10168    |
| 10169    |
| 10170    |
| 10171    |
| 10172    |
| 10173    |
| 10174    |
| 10175    |
| 10176    |
| 10177    |
| 10178    |
| 10179    |
| 10180    |
| 10181    |
| 10182    |
| 10183    |
| 10184    |
| 10185    |
| 10186    |
| 10187    |
+----------+--+
| Cust_Id  |
+----------+--+
| 10188    |
| 10189    |
| 10190    |
| 10191    |
| 10192    |
| 10193    |
| 10194    |
| 10195    |
| 10196    |
| 10197    |
| 10198    |
| 10199    |
| 10200    |
| 10201    |
| 10202    |
| 10203    |
| 10204    |
| 10205    |
| 10206    |
| 10207    |
| 10208    |
| 10209    |
| 10210    |
| 10211    |
| 10212    |
| 10213    |
| 10214    |
| 10215    |
| 10216    |
| 10217    |
| 10218    |
| 10219    |
| 10220    |
| 10221    |
| 10222    |
| 10223    |
| 10224    |
| 10225    |
| 10226    |
| 10227    |
| 10228    |
| 10229    |
| 10230    |
| 10231    |
| 10232    |
| 10233    |
| 10234    |
| 10235    |
| 10236    |
| 10237    |
| 10238    |
| 10239    |
| 10240    |
| 10241    |
| 10242    |
| 10243    |
| 10244    |
| 10245    |
| 10246    |
| 10247    |
| 10248    |
| 10249    |
| 10250    |
| 10251    |
| 10252    |
| 10253    |
| 10254    |
| 10255    |
| 10256    |
| 10257    |
| 10258    |
| 10259    |
| 10260    |
| 10261    |
| 10262    |
| 10263    |
| 10264    |
| 10265    |
| 10266    |
| 10267    |
| 10268    |
| 10269    |
| 10270    |
| 10271    |
| 10272    |
| 10273    |
| 10274    |
| 10275    |
| 10276    |
| 10277    |
| 10278    |
| 10279    |
| 10280    |
| 10281    |
| 10282    |
| 10283    |
| 10284    |
| 10285    |
| 10286    |
| 10287    |
+----------+--+
| Cust_Id  |
+----------+--+
| 10288    |
| 10289    |
| 10290    |
| 10291    |
| 10292    |
| 10293    |
| 10294    |
| 10295    |
| 10296    |
| 10297    |
| 10298    |
| 10299    |
| 10300    |
| 10301    |
| 10302    |
| 10303    |
| 10304    |
| 10305    |
| 10306    |
| 10307    |
| 10308    |
| 10309    |
| 10310    |
| 10311    |
| 10312    |
| 10313    |
| 10314    |
| 10315    |
| 10316    |
| 10317    |
| 10318    |
| 10319    |
| 10320    |
| 10321    |
| 10322    |
| 10323    |
| 10324    |
| 10325    |
| 10326    |
| 10327    |
| 10328    |
| 10329    |
| 10330    |
| 10331    |
| 10332    |
| 10333    |
| 10334    |
| 10335    |
| 10336    |
| 10337    |
| 10338    |
| 10339    |
| 10340    |
| 10341    |
| 10342    |
| 10343    |
| 10344    |
| 10345    |
| 10346    |
| 10347    |
| 10348    |
| 10349    |
| 10350    |
| 10351    |
| 10352    |
| 10353    |
| 10354    |
| 10355    |
| 10356    |
| 10357    |
| 10358    |
| 10359    |
| 10360    |
| 10361    |
| 10362    |
| 10363    |
| 10364    |
| 10365    |
| 10366    |
| 10367    |
| 10368    |
| 10369    |
| 10370    |
| 10371    |
| 10372    |
| 10373    |
| 10374    |
| 10375    |
| 10376    |
| 10377    |
| 10378    |
| 10379    |
| 10380    |
| 10381    |
| 10382    |
| 10383    |
| 10384    |
| 10385    |
| 10386    |
| 10387    |
+----------+--+
| Cust_Id  |
+----------+--+
| 10388    |
| 10389    |
| 10390    |
| 10391    |
| 10392    |
| 10393    |
| 10394    |
| 10395    |
| 10396    |
| 10397    |
| 10398    |
| 10399    |
| 10400    |
| 10401    |
| 10402    |
| 10403    |
| 10404    |
| 10405    |
| 10406    |
| 10407    |
| 10408    |
| 10409    |
| 10410    |
| 10411    |
| 10412    |
| 10413    |
| 10414    |
| 10415    |
| 10416    |
| 10417    |
| 10418    |
| 10419    |
| 10420    |
| 10421    |
| 10422    |
| 10423    |
| 10424    |
| 10425    |
| 10426    |
| 10427    |
| 10428    |
| 10429    |
| 10430    |
| 10431    |
| 10432    |
| 10433    |
| 10434    |
| 10435    |
| 10436    |
| 10437    |
| 10438    |
| 10439    |
| 10440    |
| 10441    |
| 10442    |
| 10443    |
| 10444    |
| 10445    |
| 10446    |
| 10447    |
| 10448    |
| 10449    |
| 10450    |
| 10451    |
| 10452    |
| 10453    |
| 10454    |
| 10455    |
| 10456    |
| 10457    |
| 10458    |
| 10459    |
| 10460    |
| 10461    |
| 10462    |
| 10463    |
| 10464    |
| 10465    |
| 10466    |
| 10467    |
| 10468    |
| 10469    |
| 10470    |
| 10471    |
| 10472    |
| 10473    |
| 10474    |
| 10475    |
| 10476    |
| 10477    |
| 10478    |
| 10479    |
| 10480    |
| 10481    |
| 10482    |
| 10483    |
| 10484    |
| 10485    |
| 10486    |
| 10487    |
+----------+--+
| Cust_Id  |
+----------+--+
| 10488    |
| 10489    |
| 10490    |
| 10491    |
| 10492    |
| 10493    |
| 10494    |
| 10495    |
| 10496    |
| 10497    |
| 10498    |
| 10499    |
| 10500    |
| 10501    |
| 10502    |
| 10503    |
| 10504    |
| 10505    |
| 10506    |
| 10507    |
| 10508    |
| 10509    |
| 10510    |
| 10511    |
| 10512    |
| 10513    |
| 10514    |
| 10515    |
| 10516    |
| 10517    |
| 10518    |
| 10519    |
| 10520    |
| 10521    |
| 10522    |
| 10523    |
| 10524    |
| 10525    |
| 10526    |
| 10527    |
| 10528    |
| 10529    |
| 10530    |
| 10531    |
| 10532    |
| 10533    |
| 10534    |
| 10535    |
| 10536    |
| 10537    |
| 10538    |
| 10539    |
| 10540    |
| 10541    |
| 10542    |
| 10543    |
| 10544    |
| 10545    |
| 10546    |
| 10547    |
| 10548    |
| 10549    |
| 10550    |
| 10551    |
| 10552    |
| 10553    |
| 10554    |
| 10555    |
| 10556    |
| 10557    |
| 10558    |
| 10559    |
| 10560    |
| 10561    |
| 10562    |
| 10563    |
| 10564    |
| 10565    |
| 10566    |
| 10567    |
| 10568    |
| 10569    |
| 10570    |
| 10571    |
| 10572    |
| 10573    |
| 10574    |
| 10575    |
| 10576    |
| 10577    |
| 10578    |
| 10579    |
| 10580    |
| 10581    |
| 10582    |
| 10583    |
| 10584    |
| 10585    |
| 10586    |
| 10587    |
+----------+--+
| Cust_Id  |
+----------+--+
| 10588    |
| 10589    |
| 10590    |
| 10591    |
| 10592    |
| 10593    |
| 10594    |
| 10595    |
| 10596    |
| 10597    |
| 10598    |
| 10599    |
| 10600    |
| 10601    |
| 10602    |
| 10603    |
| 10604    |
| 10605    |
| 10606    |
| 10607    |
| 10608    |
| 10609    |
| 10610    |
| 10611    |
| 10612    |
| 10613    |
| 10614    |
| 10615    |
| 10616    |
| 10617    |
| 10618    |
| 10619    |
| 10620    |
| 10621    |
| 10622    |
| 10623    |
| 10624    |
| 10625    |
| 10626    |
| 10627    |
| 10628    |
| 10629    |
| 10630    |
| 10631    |
| 10632    |
| 10633    |
| 10634    |
| 10635    |
| 10636    |
| 10637    |
| 10638    |
| 10639    |
| 10640    |
| 10641    |
| 10642    |
| 10643    |
| 10644    |
| 10645    |
| 10646    |
| 10647    |
| 10648    |
| 10649    |
| 10650    |
| 10651    |
| 10652    |
| 10653    |
| 10654    |
| 10655    |
| 10656    |
| 10657    |
| 10658    |
| 10659    |
| 10660    |
| 10661    |
| 10662    |
| 10663    |
| 10664    |
| 10665    |
| 10666    |
| 10667    |
| 10668    |
| 10669    |
| 10670    |
| 10671    |
| 10672    |
| 10673    |
| 10674    |
| 10675    |
| 10676    |
| 10677    |
| 10678    |
| 10679    |
| 10680    |
| 10681    |
| 10682    |
| 10683    |
| 10684    |
| 10685    |
| 10686    |
| 10687    |
+----------+--+
| Cust_Id  |
+----------+--+
| 10688    |
| 10689    |
| 10690    |
| 10691    |
| 10692    |
| 10693    |
| 10694    |
| 10695    |
| 10696    |
| 10697    |
| 10698    |
| 10699    |
| 10700    |
| 10701    |
| 10702    |
| 10703    |
| 10704    |
| 10705    |
| 10706    |
| 10707    |
| 10708    |
| 10709    |
| 10710    |
| 10711    |
| 10712    |
| 10713    |
| 10714    |
| 10715    |
| 10716    |
| 10717    |
| 10718    |
| 10719    |
| 10720    |
| 10721    |
| 10722    |
| 10723    |
| 10724    |
| 10725    |
| 10726    |
| 10727    |
| 10728    |
| 10729    |
| 10730    |
| 10731    |
| 10732    |
| 10733    |
| 10734    |
| 10735    |
| 10736    |
| 10737    |
| 10738    |
| 10739    |
| 10740    |
| 10741    |
| 10742    |
| 10743    |
| 10744    |
| 10745    |
| 10746    |
| 10747    |
| 10748    |
| 10749    |
| 10750    |
| 10751    |
| 10752    |
| 10753    |
| 10754    |
| 10755    |
| 10756    |
| 10757    |
| 10758    |
| 10759    |
| 10760    |
| 10761    |
| 10762    |
| 10763    |
| 10764    |
| 10765    |
| 10766    |
| 10767    |
| 10768    |
| 10769    |
| 10770    |
| 10771    |
| 10772    |
| 10773    |
| 10774    |
| 10775    |
| 10776    |
| 10777    |
| 10778    |
| 10779    |
| 10780    |
| 10781    |
| 10782    |
| 10783    |
| 10784    |
| 10785    |
| 10786    |
| 10787    |
+----------+--+
| Cust_Id  |
+----------+--+
| 10788    |
| 10789    |
| 10790    |
| 10791    |
| 10792    |
| 10793    |
| 10794    |
| 10795    |
| 10796    |
| 10797    |
| 10798    |
| 10799    |
| 10800    |
| 10801    |
| 10802    |
| 10803    |
| 10804    |
| 10805    |
| 10806    |
| 10807    |
| 10808    |
| 10809    |
| 10810    |
| 10811    |
| 10812    |
| 10813    |
| 10814    |
| 10815    |
| 10816    |
| 10817    |
| 10818    |
| 10819    |
| 10820    |
| 10821    |
| 10822    |
| 10823    |
| 10824    |
| 10825    |
| 10826    |
| 10827    |
| 10828    |
| 10829    |
| 10830    |
| 10831    |
| 10832    |
| 10833    |
| 10834    |
| 10835    |
| 10836    |
| 10837    |
| 10838    |
| 10839    |
| 10840    |
| 10841    |
| 10842    |
| 10843    |
| 10844    |
| 10845    |
| 10846    |
| 10847    |
| 10848    |
| 10849    |
| 10850    |
| 10851    |
| 10852    |
| 10853    |
| 10854    |
| 10855    |
| 10856    |
| 10857    |
| 10858    |
| 10859    |
| 10860    |
| 10861    |
| 10862    |
| 10863    |
| 10864    |
| 10865    |
| 10866    |
| 10867    |
| 10868    |
| 10869    |
| 10870    |
| 10871    |
| 10872    |
| 10873    |
| 10874    |
| 10875    |
| 10876    |
| 10877    |
| 10878    |
| 10879    |
| 10880    |
| 10881    |
| 10882    |
| 10883    |
| 10884    |
| 10885    |
| 10886    |
| 10887    |
+----------+--+
| Cust_Id  |
+----------+--+
| 10888    |
| 10889    |
| 10890    |
| 10891    |
| 10892    |
| 10893    |
| 10894    |
| 10895    |
| 10896    |
| 10897    |
| 10898    |
| 10899    |
| 10900    |
| 10901    |
| 10902    |
| 10903    |
| 10904    |
| 10905    |
| 10906    |
| 10907    |
| 10908    |
| 10909    |
| 10910    |
| 10911    |
| 10912    |
| 10913    |
| 10914    |
| 10915    |
| 10916    |
| 10917    |
| 10918    |
| 10919    |
| 10920    |
| 10921    |
| 10922    |
| 10923    |
| 10924    |
| 10925    |
| 10926    |
| 10927    |
| 10928    |
| 10929    |
| 10930    |
| 10931    |
| 10932    |
| 10933    |
| 10934    |
| 10935    |
| 10936    |
| 10937    |
| 10938    |
| 10939    |
| 10940    |
| 10941    |
| 10942    |
| 10943    |
| 10944    |
| 10945    |
| 10946    |
| 10947    |
| 10948    |
| 10949    |
| 10950    |
| 10951    |
| 10952    |
| 10953    |
| 10954    |
| 10955    |
| 10956    |
| 10957    |
| 10958    |
| 10959    |
| 10960    |
| 10961    |
| 10962    |
| 10963    |
| 10964    |
| 10965    |
| 10966    |
| 10967    |
| 10968    |
| 10969    |
| 10970    |
| 10971    |
| 10972    |
| 10973    |
| 10974    |
| 10975    |
| 10976    |
| 10977    |
| 10978    |
| 10979    |
| 10980    |
| 10981    |
| 10982    |
| 10983    |
| 10984    |
| 10985    |
| 10986    |
| 10987    |
+----------+--+
| Cust_Id  |
+----------+--+
| 10988    |
| 10989    |
| 10990    |
| 10991    |
| 10992    |
| 10993    |
| 10994    |
| 10995    |
| 10996    |
| 10997    |
| 10998    |
| 10999    |
| NULL     |
+----------+--+
2,013 rows selected (0.231 seconds)

  was:
 When we perform dataload with Single_pass='true' , it repeats some of the values in the table whereas the csv contains empty value for that column. PFA csv which is used for dataloading. And below is the create , load . and select query.


CREATE TABLE uniq_shared_dictionary (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB timestamp, DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('DICTIONARY_INCLUDE'='CUST_ID,Double_COLUMN2,DECIMAL_COLUMN2','columnproperties.CUST_ID.shared_column'='shared.CUST_ID','columnproperties.decimal_column2.shared_column'='shared.decimal_column2') ;



 LOAD DATA INPATH 'hdfs://192.168.2.145:54310/BabuStore/Data/uniqdata/2000_UniqData.csv' into table uniq_shared_dictionary OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"','BAD_RECORDS_LOGGER_ENABLE'='TRUE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1','SINGLE_Pass'='true') ;

Output: 
0: jdbc:hive2://hadoop-master:10000> select CUST_ID from uniq_shared_dictionary ;
+----------+--+
| Cust_Id  |
+----------+--+
| 8999     |
| 8999     |
| 8999     |
| 8999     |
| 8999     |
| 8999     |
| 8999     |
| 8999     |
| 8999     |
| 8999     |
| 8999     |
| 8999     |
| 9000     |
| 9001     |
| 9002     |
| 9003     |
| 9004     |
| 9005     |
| 9006     |
| 9007     |
| 9008     |
| 9009     |
| 9010     |
| 9011     |
| 9012     |
| 9013     |
| 9014     |
| 9015     |
| 9016     |
| 9017     |
| 9018     |
| 9019     |
| 9020     |
| 9021     |
| 9022     |
| 9023     |
| 9024     |
| 9025     |
| 9026     |
| 9027     |
| 9028     |
| 9029     |
| 9030     |
| 9031     |
| 9032     |
| 9033     |
| 9034     |
| 9035     |
| 9036     |
| 9037     |
| 9038     |
| 9039     |
| 9040     |
| 9041     |
| 9042     |
| 9043     |
| 9044     |
| 9045     |
| 9046     |
| 9047     |
| 9048     |
| 9049     |
| 9050     |
| 9051     |
| 9052     |
| 9053     |
| 9054     |
| 9055     |
| 9056     |
| 9057     |
| 9058     |
| 9059     |
| 9060     |
| 9061     |
| 9062     |
| 9063     |
| 9064     |
| 9065     |
| 9066     |
| 9067     |
| 9068     |
| 9069     |
| 9070     |
| 9071     |
| 9072     |
| 9073     |
| 9074     |
| 9075     |
| 9076     |
| 9077     |
| 9078     |
| 9079     |
| 9080     |
| 9081     |
| 9082     |
| 9083     |
| 9084     |
| 9085     |
| 9086     |
| 9087     |
+----------+--+
| Cust_Id  |
+----------+--+
| 9088     |
| 9089     |
| 9090     |
| 9091     |
| 9092     |
| 9093     |
| 9094     |
| 9095     |
| 9096     |
| 9097     |
| 9098     |
| 9099     |
| 9100     |
| 9101     |
| 9102     |
| 9103     |
| 9104     |
| 9105     |
| 9106     |
| 9107     |
| 9108     |
| 9109     |
| 9110     |
| 9111     |
| 9112     |
| 9113     |
| 9114     |
| 9115     |
| 9116     |
| 9117     |
| 9118     |
| 9119     |
| 9120     |
| 9121     |
| 9122     |
| 9123     |
| 9124     |
| 9125     |
| 9126     |
| 9127     |
| 9128     |
| 9129     |
| 9130     |
| 9131     |
| 9132     |
| 9133     |
| 9134     |
| 9135     |
| 9136     |
| 9137     |
| 9138     |
| 9139     |
| 9140     |
| 9141     |
| 9142     |
| 9143     |
| 9144     |
| 9145     |
| 9146     |
| 9147     |
| 9148     |
| 9149     |
| 9150     |
| 9151     |
| 9152     |
| 9153     |
| 9154     |
| 9155     |
| 9156     |
| 9157     |
| 9158     |
| 9159     |
| 9160     |
| 9161     |
| 9162     |
| 9163     |
| 9164     |
| 9165     |
| 9166     |
| 9167     |
| 9168     |
| 9169     |
| 9170     |
| 9171     |
| 9172     |
| 9173     |
| 9174     |
| 9175     |
| 9176     |
| 9177     |
| 9178     |
| 9179     |
| 9180     |
| 9181     |
| 9182     |
| 9183     |
| 9184     |
| 9185     |
| 9186     |
| 9187     |
+----------+--+
| Cust_Id  |
+----------+--+
| 9188     |
| 9189     |
| 9190     |
| 9191     |
| 9192     |
| 9193     |
| 9194     |
| 9195     |
| 9196     |
| 9197     |
| 9198     |
| 9199     |
| 9200     |
| 9201     |
| 9202     |
| 9203     |
| 9204     |
| 9205     |
| 9206     |
| 9207     |
| 9208     |
| 9209     |
| 9210     |
| 9211     |
| 9212     |
| 9213     |
| 9214     |
| 9215     |
| 9216     |
| 9217     |
| 9218     |
| 9219     |
| 9220     |
| 9221     |
| 9222     |
| 9223     |
| 9224     |
| 9225     |
| 9226     |
| 9227     |
| 9228     |
| 9229     |
| 9230     |
| 9231     |
| 9232     |
| 9233     |
| 9234     |
| 9235     |
| 9236     |
| 9237     |
| 9238     |
| 9239     |
| 9240     |
| 9241     |
| 9242     |
| 9243     |
| 9244     |
| 9245     |
| 9246     |
| 9247     |
| 9248     |
| 9249     |
| 9250     |
| 9251     |
| 9252     |
| 9253     |
| 9254     |
| 9255     |
| 9256     |
| 9257     |
| 9258     |
| 9259     |
| 9260     |
| 9261     |
| 9262     |
| 9263     |
| 9264     |
| 9265     |
| 9266     |
| 9267     |
| 9268     |
| 9269     |
| 9270     |
| 9271     |
| 9272     |
| 9273     |
| 9274     |
| 9275     |
| 9276     |
| 9277     |
| 9278     |
| 9279     |
| 9280     |
| 9281     |
| 9282     |
| 9283     |
| 9284     |
| 9285     |
| 9286     |
| 9287     |
+----------+--+
| Cust_Id  |
+----------+--+
| 9288     |
| 9289     |
| 9290     |
| 9291     |
| 9292     |
| 9293     |
| 9294     |
| 9295     |
| 9296     |
| 9297     |
| 9298     |
| 9299     |
| 9300     |
| 9301     |
| 9302     |
| 9303     |
| 9304     |
| 9305     |
| 9306     |
| 9307     |
| 9308     |
| 9309     |
| 9310     |
| 9311     |
| 9312     |
| 9313     |
| 9314     |
| 9315     |
| 9316     |
| 9317     |
| 9318     |
| 9319     |
| 9320     |
| 9321     |
| 9322     |
| 9323     |
| 9324     |
| 9325     |
| 9326     |
| 9327     |
| 9328     |
| 9329     |
| 9330     |
| 9331     |
| 9332     |
| 9333     |
| 9334     |
| 9335     |
| 9336     |
| 9337     |
| 9338     |
| 9339     |
| 9340     |
| 9341     |
| 9342     |
| 9343     |
| 9344     |
| 9345     |
| 9346     |
| 9347     |
| 9348     |
| 9349     |
| 9350     |
| 9351     |
| 9352     |
| 9353     |
| 9354     |
| 9355     |
| 9356     |
| 9357     |
| 9358     |
| 9359     |
| 9360     |
| 9361     |
| 9362     |
| 9363     |
| 9364     |
| 9365     |
| 9366     |
| 9367     |
| 9368     |
| 9369     |
| 9370     |
| 9371     |
| 9372     |
| 9373     |
| 9374     |
| 9375     |
| 9376     |
| 9377     |
| 9378     |
| 9379     |
| 9380     |
| 9381     |
| 9382     |
| 9383     |
| 9384     |
| 9385     |
| 9386     |
| 9387     |
+----------+--+
| Cust_Id  |
+----------+--+
| 9388     |
| 9389     |
| 9390     |
| 9391     |
| 9392     |
| 9393     |
| 9394     |
| 9395     |
| 9396     |
| 9397     |
| 9398     |
| 9399     |
| 9400     |
| 9401     |
| 9402     |
| 9403     |
| 9404     |
| 9405     |
| 9406     |
| 9407     |
| 9408     |
| 9409     |
| 9410     |
| 9411     |
| 9412     |
| 9413     |
| 9414     |
| 9415     |
| 9416     |
| 9417     |
| 9418     |
| 9419     |
| 9420     |
| 9421     |
| 9422     |
| 9423     |
| 9424     |
| 9425     |
| 9426     |
| 9427     |
| 9428     |
| 9429     |
| 9430     |
| 9431     |
| 9432     |
| 9433     |
| 9434     |
| 9435     |
| 9436     |
| 9437     |
| 9438     |
| 9439     |
| 9440     |
| 9441     |
| 9442     |
| 9443     |
| 9444     |
| 9445     |
| 9446     |
| 9447     |
| 9448     |
| 9449     |
| 9450     |
| 9451     |
| 9452     |
| 9453     |
| 9454     |
| 9455     |
| 9456     |
| 9457     |
| 9458     |
| 9459     |
| 9460     |
| 9461     |
| 9462     |
| 9463     |
| 9464     |
| 9465     |
| 9466     |
| 9467     |
| 9468     |
| 9469     |
| 9470     |
| 9471     |
| 9472     |
| 9473     |
| 9474     |
| 9475     |
| 9476     |
| 9477     |
| 9478     |
| 9479     |
| 9480     |
| 9481     |
| 9482     |
| 9483     |
| 9484     |
| 9485     |
| 9486     |
| 9487     |
+----------+--+
| Cust_Id  |
+----------+--+
| 9488     |
| 9489     |
| 9490     |
| 9491     |
| 9492     |
| 9493     |
| 9494     |
| 9495     |
| 9496     |
| 9497     |
| 9498     |
| 9499     |
| 9500     |
| 9501     |
| 9502     |
| 9503     |
| 9504     |
| 9505     |
| 9506     |
| 9507     |
| 9508     |
| 9509     |
| 9510     |
| 9511     |
| 9512     |
| 9513     |
| 9514     |
| 9515     |
| 9516     |
| 9517     |
| 9518     |
| 9519     |
| 9520     |
| 9521     |
| 9522     |
| 9523     |
| 9524     |
| 9525     |
| 9526     |
| 9527     |
| 9528     |
| 9529     |
| 9530     |
| 9531     |
| 9532     |
| 9533     |
| 9534     |
| 9535     |
| 9536     |
| 9537     |
| 9538     |
| 9539     |
| 9540     |
| 9541     |
| 9542     |
| 9543     |
| 9544     |
| 9545     |
| 9546     |
| 9547     |
| 9548     |
| 9549     |
| 9550     |
| 9551     |
| 9552     |
| 9553     |
| 9554     |
| 9555     |
| 9556     |
| 9557     |
| 9558     |
| 9559     |
| 9560     |
| 9561     |
| 9562     |
| 9563     |
| 9564     |
| 9565     |
| 9566     |
| 9567     |
| 9568     |
| 9569     |
| 9570     |
| 9571     |
| 9572     |
| 9573     |
| 9574     |
| 9575     |
| 9576     |
| 9577     |
| 9578     |
| 9579     |
| 9580     |
| 9581     |
| 9582     |
| 9583     |
| 9584     |
| 9585     |
| 9586     |
| 9587     |
+----------+--+
| Cust_Id  |
+----------+--+
| 9588     |
| 9589     |
| 9590     |
| 9591     |
| 9592     |
| 9593     |
| 9594     |
| 9595     |
| 9596     |
| 9597     |
| 9598     |
| 9599     |
| 9600     |
| 9601     |
| 9602     |
| 9603     |
| 9604     |
| 9605     |
| 9606     |
| 9607     |
| 9608     |
| 9609     |
| 9610     |
| 9611     |
| 9612     |
| 9613     |
| 9614     |
| 9615     |
| 9616     |
| 9617     |
| 9618     |
| 9619     |
| 9620     |
| 9621     |
| 9622     |
| 9623     |
| 9624     |
| 9625     |
| 9626     |
| 9627     |
| 9628     |
| 9629     |
| 9630     |
| 9631     |
| 9632     |
| 9633     |
| 9634     |
| 9635     |
| 9636     |
| 9637     |
| 9638     |
| 9639     |
| 9640     |
| 9641     |
| 9642     |
| 9643     |
| 9644     |
| 9645     |
| 9646     |
| 9647     |
| 9648     |
| 9649     |
| 9650     |
| 9651     |
| 9652     |
| 9653     |
| 9654     |
| 9655     |
| 9656     |
| 9657     |
| 9658     |
| 9659     |
| 9660     |
| 9661     |
| 9662     |
| 9663     |
| 9664     |
| 9665     |
| 9666     |
| 9667     |
| 9668     |
| 9669     |
| 9670     |
| 9671     |
| 9672     |
| 9673     |
| 9674     |
| 9675     |
| 9676     |
| 9677     |
| 9678     |
| 9679     |
| 9680     |
| 9681     |
| 9682     |
| 9683     |
| 9684     |
| 9685     |
| 9686     |
| 9687     |
+----------+--+
| Cust_Id  |
+----------+--+
| 9688     |
| 9689     |
| 9690     |
| 9691     |
| 9692     |
| 9693     |
| 9694     |
| 9695     |
| 9696     |
| 9697     |
| 9698     |
| 9699     |
| 9700     |
| 9701     |
| 9702     |
| 9703     |
| 9704     |
| 9705     |
| 9706     |
| 9707     |
| 9708     |
| 9709     |
| 9710     |
| 9711     |
| 9712     |
| 9713     |
| 9714     |
| 9715     |
| 9716     |
| 9717     |
| 9718     |
| 9719     |
| 9720     |
| 9721     |
| 9722     |
| 9723     |
| 9724     |
| 9725     |
| 9726     |
| 9727     |
| 9728     |
| 9729     |
| 9730     |
| 9731     |
| 9732     |
| 9733     |
| 9734     |
| 9735     |
| 9736     |
| 9737     |
| 9738     |
| 9739     |
| 9740     |
| 9741     |
| 9742     |
| 9743     |
| 9744     |
| 9745     |
| 9746     |
| 9747     |
| 9748     |
| 9749     |
| 9750     |
| 9751     |
| 9752     |
| 9753     |
| 9754     |
| 9755     |
| 9756     |
| 9757     |
| 9758     |
| 9759     |
| 9760     |
| 9761     |
| 9762     |
| 9763     |
| 9764     |
| 9765     |
| 9766     |
| 9767     |
| 9768     |
| 9769     |
| 9770     |
| 9771     |
| 9772     |
| 9773     |
| 9774     |
| 9775     |
| 9776     |
| 9777     |
| 9778     |
| 9779     |
| 9780     |
| 9781     |
| 9782     |
| 9783     |
| 9784     |
| 9785     |
| 9786     |
| 9787     |
+----------+--+
| Cust_Id  |
+----------+--+
| 9788     |
| 9789     |
| 9790     |
| 9791     |
| 9792     |
| 9793     |
| 9794     |
| 9795     |
| 9796     |
| 9797     |
| 9798     |
| 9799     |
| 9800     |
| 9801     |
| 9802     |
| 9803     |
| 9804     |
| 9805     |
| 9806     |
| 9807     |
| 9808     |
| 9809     |
| 9810     |
| 9811     |
| 9812     |
| 9813     |
| 9814     |
| 9815     |
| 9816     |
| 9817     |
| 9818     |
| 9819     |
| 9820     |
| 9821     |
| 9822     |
| 9823     |
| 9824     |
| 9825     |
| 9826     |
| 9827     |
| 9828     |
| 9829     |
| 9830     |
| 9831     |
| 9832     |
| 9833     |
| 9834     |
| 9835     |
| 9836     |
| 9837     |
| 9838     |
| 9839     |
| 9840     |
| 9841     |
| 9842     |
| 9843     |
| 9844     |
| 9845     |
| 9846     |
| 9847     |
| 9848     |
| 9849     |
| 9850     |
| 9851     |
| 9852     |
| 9853     |
| 9854     |
| 9855     |
| 9856     |
| 9857     |
| 9858     |
| 9859     |
| 9860     |
| 9861     |
| 9862     |
| 9863     |
| 9864     |
| 9865     |
| 9866     |
| 9867     |
| 9868     |
| 9869     |
| 9870     |
| 9871     |
| 9872     |
| 9873     |
| 9874     |
| 9875     |
| 9876     |
| 9877     |
| 9878     |
| 9879     |
| 9880     |
| 9881     |
| 9882     |
| 9883     |
| 9884     |
| 9885     |
| 9886     |
| 9887     |
+----------+--+
| Cust_Id  |
+----------+--+
| 9888     |
| 9889     |
| 9890     |
| 9891     |
| 9892     |
| 9893     |
| 9894     |
| 9895     |
| 9896     |
| 9897     |
| 9898     |
| 9899     |
| 9900     |
| 9901     |
| 9902     |
| 9903     |
| 9904     |
| 9905     |
| 9906     |
| 9907     |
| 9908     |
| 9909     |
| 9910     |
| 9911     |
| 9912     |
| 9913     |
| 9914     |
| 9915     |
| 9916     |
| 9917     |
| 9918     |
| 9919     |
| 9920     |
| 9921     |
| 9922     |
| 9923     |
| 9924     |
| 9925     |
| 9926     |
| 9927     |
| 9928     |
| 9929     |
| 9930     |
| 9931     |
| 9932     |
| 9933     |
| 9934     |
| 9935     |
| 9936     |
| 9937     |
| 9938     |
| 9939     |
| 9940     |
| 9941     |
| 9942     |
| 9943     |
| 9944     |
| 9945     |
| 9946     |
| 9947     |
| 9948     |
| 9949     |
| 9950     |
| 9951     |
| 9952     |
| 9953     |
| 9954     |
| 9955     |
| 9956     |
| 9957     |
| 9958     |
| 9959     |
| 9960     |
| 9961     |
| 9962     |
| 9963     |
| 9964     |
| 9965     |
| 9966     |
| 9967     |
| 9968     |
| 9969     |
| 9970     |
| 9971     |
| 9972     |
| 9973     |
| 9974     |
| 9975     |
| 9976     |
| 9977     |
| 9978     |
| 9979     |
| 9980     |
| 9981     |
| 9982     |
| 9983     |
| 9984     |
| 9985     |
| 9986     |
| 9987     |
+----------+--+
| Cust_Id  |
+----------+--+
| 9988     |
| 9989     |
| 9990     |
| 9991     |
| 9992     |
| 9993     |
| 9994     |
| 9995     |
| 9996     |
| 9997     |
| 9998     |
| 9999     |
| 10000    |
| 10001    |
| 10002    |
| 10003    |
| 10004    |
| 10005    |
| 10006    |
| 10007    |
| 10008    |
| 10009    |
| 10010    |
| 10011    |
| 10012    |
| 10013    |
| 10014    |
| 10015    |
| 10016    |
| 10017    |
| 10018    |
| 10019    |
| 10020    |
| 10021    |
| 10022    |
| 10023    |
| 10024    |
| 10025    |
| 10026    |
| 10027    |
| 10028    |
| 10029    |
| 10030    |
| 10031    |
| 10032    |
| 10033    |
| 10034    |
| 10035    |
| 10036    |
| 10037    |
| 10038    |
| 10039    |
| 10040    |
| 10041    |
| 10042    |
| 10043    |
| 10044    |
| 10045    |
| 10046    |
| 10047    |
| 10048    |
| 10049    |
| 10050    |
| 10051    |
| 10052    |
| 10053    |
| 10054    |
| 10055    |
| 10056    |
| 10057    |
| 10058    |
| 10059    |
| 10060    |
| 10061    |
| 10062    |
| 10063    |
| 10064    |
| 10065    |
| 10066    |
| 10067    |
| 10068    |
| 10069    |
| 10070    |
| 10071    |
| 10072    |
| 10073    |
| 10074    |
| 10075    |
| 10076    |
| 10077    |
| 10078    |
| 10079    |
| 10080    |
| 10081    |
| 10082    |
| 10083    |
| 10084    |
| 10085    |
| 10086    |
| 10087    |
+----------+--+
| Cust_Id  |
+----------+--+
| 10088    |
| 10089    |
| 10090    |
| 10091    |
| 10092    |
| 10093    |
| 10094    |
| 10095    |
| 10096    |
| 10097    |
| 10098    |
| 10099    |
| 10100    |
| 10101    |
| 10102    |
| 10103    |
| 10104    |
| 10105    |
| 10106    |
| 10107    |
| 10108    |
| 10109    |
| 10110    |
| 10111    |
| 10112    |
| 10113    |
| 10114    |
| 10115    |
| 10116    |
| 10117    |
| 10118    |
| 10119    |
| 10120    |
| 10121    |
| 10122    |
| 10123    |
| 10124    |
| 10125    |
| 10126    |
| 10127    |
| 10128    |
| 10129    |
| 10130    |
| 10131    |
| 10132    |
| 10133    |
| 10134    |
| 10135    |
| 10136    |
| 10137    |
| 10138    |
| 10139    |
| 10140    |
| 10141    |
| 10142    |
| 10143    |
| 10144    |
| 10145    |
| 10146    |
| 10147    |
| 10148    |
| 10149    |
| 10150    |
| 10151    |
| 10152    |
| 10153    |
| 10154    |
| 10155    |
| 10156    |
| 10157    |
| 10158    |
| 10159    |
| 10160    |
| 10161    |
| 10162    |
| 10163    |
| 10164    |
| 10165    |
| 10166    |
| 10167    |
| 10168    |
| 10169    |
| 10170    |
| 10171    |
| 10172    |
| 10173    |
| 10174    |
| 10175    |
| 10176    |
| 10177    |
| 10178    |
| 10179    |
| 10180    |
| 10181    |
| 10182    |
| 10183    |
| 10184    |
| 10185    |
| 10186    |
| 10187    |
+----------+--+
| Cust_Id  |
+----------+--+
| 10188    |
| 10189    |
| 10190    |
| 10191    |
| 10192    |
| 10193    |
| 10194    |
| 10195    |
| 10196    |
| 10197    |
| 10198    |
| 10199    |
| 10200    |
| 10201    |
| 10202    |
| 10203    |
| 10204    |
| 10205    |
| 10206    |
| 10207    |
| 10208    |
| 10209    |
| 10210    |
| 10211    |
| 10212    |
| 10213    |
| 10214    |
| 10215    |
| 10216    |
| 10217    |
| 10218    |
| 10219    |
| 10220    |
| 10221    |
| 10222    |
| 10223    |
| 10224    |
| 10225    |
| 10226    |
| 10227    |
| 10228    |
| 10229    |
| 10230    |
| 10231    |
| 10232    |
| 10233    |
| 10234    |
| 10235    |
| 10236    |
| 10237    |
| 10238    |
| 10239    |
| 10240    |
| 10241    |
| 10242    |
| 10243    |
| 10244    |
| 10245    |
| 10246    |
| 10247    |
| 10248    |
| 10249    |
| 10250    |
| 10251    |
| 10252    |
| 10253    |
| 10254    |
| 10255    |
| 10256    |
| 10257    |
| 10258    |
| 10259    |
| 10260    |
| 10261    |
| 10262    |
| 10263    |
| 10264    |
| 10265    |
| 10266    |
| 10267    |
| 10268    |
| 10269    |
| 10270    |
| 10271    |
| 10272    |
| 10273    |
| 10274    |
| 10275    |
| 10276    |
| 10277    |
| 10278    |
| 10279    |
| 10280    |
| 10281    |
| 10282    |
| 10283    |
| 10284    |
| 10285    |
| 10286    |
| 10287    |
+----------+--+
| Cust_Id  |
+----------+--+
| 10288    |
| 10289    |
| 10290    |
| 10291    |
| 10292    |
| 10293    |
| 10294    |
| 10295    |
| 10296    |
| 10297    |
| 10298    |
| 10299    |
| 10300    |
| 10301    |
| 10302    |
| 10303    |
| 10304    |
| 10305    |
| 10306    |
| 10307    |
| 10308    |
| 10309    |
| 10310    |
| 10311    |
| 10312    |
| 10313    |
| 10314    |
| 10315    |
| 10316    |
| 10317    |
| 10318    |
| 10319    |
| 10320    |
| 10321    |
| 10322    |
| 10323    |
| 10324    |
| 10325    |
| 10326    |
| 10327    |
| 10328    |
| 10329    |
| 10330    |
| 10331    |
| 10332    |
| 10333    |
| 10334    |
| 10335    |
| 10336    |
| 10337    |
| 10338    |
| 10339    |
| 10340    |
| 10341    |
| 10342    |
| 10343    |
| 10344    |
| 10345    |
| 10346    |
| 10347    |
| 10348    |
| 10349    |
| 10350    |
| 10351    |
| 10352    |
| 10353    |
| 10354    |
| 10355    |
| 10356    |
| 10357    |
| 10358    |
| 10359    |
| 10360    |
| 10361    |
| 10362    |
| 10363    |
| 10364    |
| 10365    |
| 10366    |
| 10367    |
| 10368    |
| 10369    |
| 10370    |
| 10371    |
| 10372    |
| 10373    |
| 10374    |
| 10375    |
| 10376    |
| 10377    |
| 10378    |
| 10379    |
| 10380    |
| 10381    |
| 10382    |
| 10383    |
| 10384    |
| 10385    |
| 10386    |
| 10387    |
+----------+--+
| Cust_Id  |
+----------+--+
| 10388    |
| 10389    |
| 10390    |
| 10391    |
| 10392    |
| 10393    |
| 10394    |
| 10395    |
| 10396    |
| 10397    |
| 10398    |
| 10399    |
| 10400    |
| 10401    |
| 10402    |
| 10403    |
| 10404    |
| 10405    |
| 10406    |
| 10407    |
| 10408    |
| 10409    |
| 10410    |
| 10411    |
| 10412    |
| 10413    |
| 10414    |
| 10415    |
| 10416    |
| 10417    |
| 10418    |
| 10419    |
| 10420    |
| 10421    |
| 10422    |
| 10423    |
| 10424    |
| 10425    |
| 10426    |
| 10427    |
| 10428    |
| 10429    |
| 10430    |
| 10431    |
| 10432    |
| 10433    |
| 10434    |
| 10435    |
| 10436    |
| 10437    |
| 10438    |
| 10439    |
| 10440    |
| 10441    |
| 10442    |
| 10443    |
| 10444    |
| 10445    |
| 10446    |
| 10447    |
| 10448    |
| 10449    |
| 10450    |
| 10451    |
| 10452    |
| 10453    |
| 10454    |
| 10455    |
| 10456    |
| 10457    |
| 10458    |
| 10459    |
| 10460    |
| 10461    |
| 10462    |
| 10463    |
| 10464    |
| 10465    |
| 10466    |
| 10467    |
| 10468    |
| 10469    |
| 10470    |
| 10471    |
| 10472    |
| 10473    |
| 10474    |
| 10475    |
| 10476    |
| 10477    |
| 10478    |
| 10479    |
| 10480    |
| 10481    |
| 10482    |
| 10483    |
| 10484    |
| 10485    |
| 10486    |
| 10487    |
+----------+--+
| Cust_Id  |
+----------+--+
| 10488    |
| 10489    |
| 10490    |
| 10491    |
| 10492    |
| 10493    |
| 10494    |
| 10495    |
| 10496    |
| 10497    |
| 10498    |
| 10499    |
| 10500    |
| 10501    |
| 10502    |
| 10503    |
| 10504    |
| 10505    |
| 10506    |
| 10507    |
| 10508    |
| 10509    |
| 10510    |
| 10511    |
| 10512    |
| 10513    |
| 10514    |
| 10515    |
| 10516    |
| 10517    |
| 10518    |
| 10519    |
| 10520    |
| 10521    |
| 10522    |
| 10523    |
| 10524    |
| 10525    |
| 10526    |
| 10527    |
| 10528    |
| 10529    |
| 10530    |
| 10531    |
| 10532    |
| 10533    |
| 10534    |
| 10535    |
| 10536    |
| 10537    |
| 10538    |
| 10539    |
| 10540    |
| 10541    |
| 10542    |
| 10543    |
| 10544    |
| 10545    |
| 10546    |
| 10547    |
| 10548    |
| 10549    |
| 10550    |
| 10551    |
| 10552    |
| 10553    |
| 10554    |
| 10555    |
| 10556    |
| 10557    |
| 10558    |
| 10559    |
| 10560    |
| 10561    |
| 10562    |
| 10563    |
| 10564    |
| 10565    |
| 10566    |
| 10567    |
| 10568    |
| 10569    |
| 10570    |
| 10571    |
| 10572    |
| 10573    |
| 10574    |
| 10575    |
| 10576    |
| 10577    |
| 10578    |
| 10579    |
| 10580    |
| 10581    |
| 10582    |
| 10583    |
| 10584    |
| 10585    |
| 10586    |
| 10587    |
+----------+--+
| Cust_Id  |
+----------+--+
| 10588    |
| 10589    |
| 10590    |
| 10591    |
| 10592    |
| 10593    |
| 10594    |
| 10595    |
| 10596    |
| 10597    |
| 10598    |
| 10599    |
| 10600    |
| 10601    |
| 10602    |
| 10603    |
| 10604    |
| 10605    |
| 10606    |
| 10607    |
| 10608    |
| 10609    |
| 10610    |
| 10611    |
| 10612    |
| 10613    |
| 10614    |
| 10615    |
| 10616    |
| 10617    |
| 10618    |
| 10619    |
| 10620    |
| 10621    |
| 10622    |
| 10623    |
| 10624    |
| 10625    |
| 10626    |
| 10627    |
| 10628    |
| 10629    |
| 10630    |
| 10631    |
| 10632    |
| 10633    |
| 10634    |
| 10635    |
| 10636    |
| 10637    |
| 10638    |
| 10639    |
| 10640    |
| 10641    |
| 10642    |
| 10643    |
| 10644    |
| 10645    |
| 10646    |
| 10647    |
| 10648    |
| 10649    |
| 10650    |
| 10651    |
| 10652    |
| 10653    |
| 10654    |
| 10655    |
| 10656    |
| 10657    |
| 10658    |
| 10659    |
| 10660    |
| 10661    |
| 10662    |
| 10663    |
| 10664    |
| 10665    |
| 10666    |
| 10667    |
| 10668    |
| 10669    |
| 10670    |
| 10671    |
| 10672    |
| 10673    |
| 10674    |
| 10675    |
| 10676    |
| 10677    |
| 10678    |
| 10679    |
| 10680    |
| 10681    |
| 10682    |
| 10683    |
| 10684    |
| 10685    |
| 10686    |
| 10687    |
+----------+--+
| Cust_Id  |
+----------+--+
| 10688    |
| 10689    |
| 10690    |
| 10691    |
| 10692    |
| 10693    |
| 10694    |
| 10695    |
| 10696    |
| 10697    |
| 10698    |
| 10699    |
| 10700    |
| 10701    |
| 10702    |
| 10703    |
| 10704    |
| 10705    |
| 10706    |
| 10707    |
| 10708    |
| 10709    |
| 10710    |
| 10711    |
| 10712    |
| 10713    |
| 10714    |
| 10715    |
| 10716    |
| 10717    |
| 10718    |
| 10719    |
| 10720    |
| 10721    |
| 10722    |
| 10723    |
| 10724    |
| 10725    |
| 10726    |
| 10727    |
| 10728    |
| 10729    |
| 10730    |
| 10731    |
| 10732    |
| 10733    |
| 10734    |
| 10735    |
| 10736    |
| 10737    |
| 10738    |
| 10739    |
| 10740    |
| 10741    |
| 10742    |
| 10743    |
| 10744    |
| 10745    |
| 10746    |
| 10747    |
| 10748    |
| 10749    |
| 10750    |
| 10751    |
| 10752    |
| 10753    |
| 10754    |
| 10755    |
| 10756    |
| 10757    |
| 10758    |
| 10759    |
| 10760    |
| 10761    |
| 10762    |
| 10763    |
| 10764    |
| 10765    |
| 10766    |
| 10767    |
| 10768    |
| 10769    |
| 10770    |
| 10771    |
| 10772    |
| 10773    |
| 10774    |
| 10775    |
| 10776    |
| 10777    |
| 10778    |
| 10779    |
| 10780    |
| 10781    |
| 10782    |
| 10783    |
| 10784    |
| 10785    |
| 10786    |
| 10787    |
+----------+--+
| Cust_Id  |
+----------+--+
| 10788    |
| 10789    |
| 10790    |
| 10791    |
| 10792    |
| 10793    |
| 10794    |
| 10795    |
| 10796    |
| 10797    |
| 10798    |
| 10799    |
| 10800    |
| 10801    |
| 10802    |
| 10803    |
| 10804    |
| 10805    |
| 10806    |
| 10807    |
| 10808    |
| 10809    |
| 10810    |
| 10811    |
| 10812    |
| 10813    |
| 10814    |
| 10815    |
| 10816    |
| 10817    |
| 10818    |
| 10819    |
| 10820    |
| 10821    |
| 10822    |
| 10823    |
| 10824    |
| 10825    |
| 10826    |
| 10827    |
| 10828    |
| 10829    |
| 10830    |
| 10831    |
| 10832    |
| 10833    |
| 10834    |
| 10835    |
| 10836    |
| 10837    |
| 10838    |
| 10839    |
| 10840    |
| 10841    |
| 10842    |
| 10843    |
| 10844    |
| 10845    |
| 10846    |
| 10847    |
| 10848    |
| 10849    |
| 10850    |
| 10851    |
| 10852    |
| 10853    |
| 10854    |
| 10855    |
| 10856    |
| 10857    |
| 10858    |
| 10859    |
| 10860    |
| 10861    |
| 10862    |
| 10863    |
| 10864    |
| 10865    |
| 10866    |
| 10867    |
| 10868    |
| 10869    |
| 10870    |
| 10871    |
| 10872    |
| 10873    |
| 10874    |
| 10875    |
| 10876    |
| 10877    |
| 10878    |
| 10879    |
| 10880    |
| 10881    |
| 10882    |
| 10883    |
| 10884    |
| 10885    |
| 10886    |
| 10887    |
+----------+--+
| Cust_Id  |
+----------+--+
| 10888    |
| 10889    |
| 10890    |
| 10891    |
| 10892    |
| 10893    |
| 10894    |
| 10895    |
| 10896    |
| 10897    |
| 10898    |
| 10899    |
| 10900    |
| 10901    |
| 10902    |
| 10903    |
| 10904    |
| 10905    |
| 10906    |
| 10907    |
| 10908    |
| 10909    |
| 10910    |
| 10911    |
| 10912    |
| 10913    |
| 10914    |
| 10915    |
| 10916    |
| 10917    |
| 10918    |
| 10919    |
| 10920    |
| 10921    |
| 10922    |
| 10923    |
| 10924    |
| 10925    |
| 10926    |
| 10927    |
| 10928    |
| 10929    |
| 10930    |
| 10931    |
| 10932    |
| 10933    |
| 10934    |
| 10935    |
| 10936    |
| 10937    |
| 10938    |
| 10939    |
| 10940    |
| 10941    |
| 10942    |
| 10943    |
| 10944    |
| 10945    |
| 10946    |
| 10947    |
| 10948    |
| 10949    |
| 10950    |
| 10951    |
| 10952    |
| 10953    |
| 10954    |
| 10955    |
| 10956    |
| 10957    |
| 10958    |
| 10959    |
| 10960    |
| 10961    |
| 10962    |
| 10963    |
| 10964    |
| 10965    |
| 10966    |
| 10967    |
| 10968    |
| 10969    |
| 10970    |
| 10971    |
| 10972    |
| 10973    |
| 10974    |
| 10975    |
| 10976    |
| 10977    |
| 10978    |
| 10979    |
| 10980    |
| 10981    |
| 10982    |
| 10983    |
| 10984    |
| 10985    |
| 10986    |
| 10987    |
+----------+--+
| Cust_Id  |
+----------+--+
| 10988    |
| 10989    |
| 10990    |
| 10991    |
| 10992    |
| 10993    |
| 10994    |
| 10995    |
| 10996    |
| 10997    |
| 10998    |
| 10999    |
| NULL     |
+----------+--+
2,013 rows selected (0.231 seconds)


> Inconsistent data load when single_pass='true'
> ----------------------------------------------
>
>                 Key: CARBONDATA-711
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-711
>             Project: CarbonData
>          Issue Type: Bug
>          Components: data-load
>    Affects Versions: 1.1.0-incubating
>         Environment: Spark 1.6
>            Reporter: SWATI RAO
>            Priority: Minor
>         Attachments: 2000_UniqData.csv
>
>
>  When we perform dataload with Single_pass='true' , it repeats some of the values in the table whereas the csv contains empty value for that column. PFA csv which is used for dataloading. And below is the create , load . and select query.
> CREATE TABLE uniq_shared_dictionary (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB timestamp, DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('DICTIONARY_INCLUDE'='CUST_ID,Double_COLUMN2,DECIMAL_COLUMN2')
>  LOAD DATA INPATH 'hdfs://192.168.2.145:54310/BabuStore/Data/uniqdata/2000_UniqData.csv' into table uniq_shared_dictionary OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"','BAD_RECORDS_LOGGER_ENABLE'='TRUE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1','SINGLE_Pass'='true') ;
> Output: 
> 0: jdbc:hive2://hadoop-master:10000> select CUST_ID from uniq_shared_dictionary ;
> +----------+--+
> | Cust_Id  |
> +----------+--+
> | 8999     |
> | 8999     |
> | 8999     |
> | 8999     |
> | 8999     |
> | 8999     |
> | 8999     |
> | 8999     |
> | 8999     |
> | 8999     |
> | 8999     |
> | 8999     |
> | 9000     |
> | 9001     |
> | 9002     |
> | 9003     |
> | 9004     |
> | 9005     |
> | 9006     |
> | 9007     |
> | 9008     |
> | 9009     |
> | 9010     |
> | 9011     |
> | 9012     |
> | 9013     |
> | 9014     |
> | 9015     |
> | 9016     |
> | 9017     |
> | 9018     |
> | 9019     |
> | 9020     |
> | 9021     |
> | 9022     |
> | 9023     |
> | 9024     |
> | 9025     |
> | 9026     |
> | 9027     |
> | 9028     |
> | 9029     |
> | 9030     |
> | 9031     |
> | 9032     |
> | 9033     |
> | 9034     |
> | 9035     |
> | 9036     |
> | 9037     |
> | 9038     |
> | 9039     |
> | 9040     |
> | 9041     |
> | 9042     |
> | 9043     |
> | 9044     |
> | 9045     |
> | 9046     |
> | 9047     |
> | 9048     |
> | 9049     |
> | 9050     |
> | 9051     |
> | 9052     |
> | 9053     |
> | 9054     |
> | 9055     |
> | 9056     |
> | 9057     |
> | 9058     |
> | 9059     |
> | 9060     |
> | 9061     |
> | 9062     |
> | 9063     |
> | 9064     |
> | 9065     |
> | 9066     |
> | 9067     |
> | 9068     |
> | 9069     |
> | 9070     |
> | 9071     |
> | 9072     |
> | 9073     |
> | 9074     |
> | 9075     |
> | 9076     |
> | 9077     |
> | 9078     |
> | 9079     |
> | 9080     |
> | 9081     |
> | 9082     |
> | 9083     |
> | 9084     |
> | 9085     |
> | 9086     |
> | 9087     |
> +----------+--+
> | Cust_Id  |
> +----------+--+
> | 9088     |
> | 9089     |
> | 9090     |
> | 9091     |
> | 9092     |
> | 9093     |
> | 9094     |
> | 9095     |
> | 9096     |
> | 9097     |
> | 9098     |
> | 9099     |
> | 9100     |
> | 9101     |
> | 9102     |
> | 9103     |
> | 9104     |
> | 9105     |
> | 9106     |
> | 9107     |
> | 9108     |
> | 9109     |
> | 9110     |
> | 9111     |
> | 9112     |
> | 9113     |
> | 9114     |
> | 9115     |
> | 9116     |
> | 9117     |
> | 9118     |
> | 9119     |
> | 9120     |
> | 9121     |
> | 9122     |
> | 9123     |
> | 9124     |
> | 9125     |
> | 9126     |
> | 9127     |
> | 9128     |
> | 9129     |
> | 9130     |
> | 9131     |
> | 9132     |
> | 9133     |
> | 9134     |
> | 9135     |
> | 9136     |
> | 9137     |
> | 9138     |
> | 9139     |
> | 9140     |
> | 9141     |
> | 9142     |
> | 9143     |
> | 9144     |
> | 9145     |
> | 9146     |
> | 9147     |
> | 9148     |
> | 9149     |
> | 9150     |
> | 9151     |
> | 9152     |
> | 9153     |
> | 9154     |
> | 9155     |
> | 9156     |
> | 9157     |
> | 9158     |
> | 9159     |
> | 9160     |
> | 9161     |
> | 9162     |
> | 9163     |
> | 9164     |
> | 9165     |
> | 9166     |
> | 9167     |
> | 9168     |
> | 9169     |
> | 9170     |
> | 9171     |
> | 9172     |
> | 9173     |
> | 9174     |
> | 9175     |
> | 9176     |
> | 9177     |
> | 9178     |
> | 9179     |
> | 9180     |
> | 9181     |
> | 9182     |
> | 9183     |
> | 9184     |
> | 9185     |
> | 9186     |
> | 9187     |
> +----------+--+
> | Cust_Id  |
> +----------+--+
> | 9188     |
> | 9189     |
> | 9190     |
> | 9191     |
> | 9192     |
> | 9193     |
> | 9194     |
> | 9195     |
> | 9196     |
> | 9197     |
> | 9198     |
> | 9199     |
> | 9200     |
> | 9201     |
> | 9202     |
> | 9203     |
> | 9204     |
> | 9205     |
> | 9206     |
> | 9207     |
> | 9208     |
> | 9209     |
> | 9210     |
> | 9211     |
> | 9212     |
> | 9213     |
> | 9214     |
> | 9215     |
> | 9216     |
> | 9217     |
> | 9218     |
> | 9219     |
> | 9220     |
> | 9221     |
> | 9222     |
> | 9223     |
> | 9224     |
> | 9225     |
> | 9226     |
> | 9227     |
> | 9228     |
> | 9229     |
> | 9230     |
> | 9231     |
> | 9232     |
> | 9233     |
> | 9234     |
> | 9235     |
> | 9236     |
> | 9237     |
> | 9238     |
> | 9239     |
> | 9240     |
> | 9241     |
> | 9242     |
> | 9243     |
> | 9244     |
> | 9245     |
> | 9246     |
> | 9247     |
> | 9248     |
> | 9249     |
> | 9250     |
> | 9251     |
> | 9252     |
> | 9253     |
> | 9254     |
> | 9255     |
> | 9256     |
> | 9257     |
> | 9258     |
> | 9259     |
> | 9260     |
> | 9261     |
> | 9262     |
> | 9263     |
> | 9264     |
> | 9265     |
> | 9266     |
> | 9267     |
> | 9268     |
> | 9269     |
> | 9270     |
> | 9271     |
> | 9272     |
> | 9273     |
> | 9274     |
> | 9275     |
> | 9276     |
> | 9277     |
> | 9278     |
> | 9279     |
> | 9280     |
> | 9281     |
> | 9282     |
> | 9283     |
> | 9284     |
> | 9285     |
> | 9286     |
> | 9287     |
> +----------+--+
> | Cust_Id  |
> +----------+--+
> | 9288     |
> | 9289     |
> | 9290     |
> | 9291     |
> | 9292     |
> | 9293     |
> | 9294     |
> | 9295     |
> | 9296     |
> | 9297     |
> | 9298     |
> | 9299     |
> | 9300     |
> | 9301     |
> | 9302     |
> | 9303     |
> | 9304     |
> | 9305     |
> | 9306     |
> | 9307     |
> | 9308     |
> | 9309     |
> | 9310     |
> | 9311     |
> | 9312     |
> | 9313     |
> | 9314     |
> | 9315     |
> | 9316     |
> | 9317     |
> | 9318     |
> | 9319     |
> | 9320     |
> | 9321     |
> | 9322     |
> | 9323     |
> | 9324     |
> | 9325     |
> | 9326     |
> | 9327     |
> | 9328     |
> | 9329     |
> | 9330     |
> | 9331     |
> | 9332     |
> | 9333     |
> | 9334     |
> | 9335     |
> | 9336     |
> | 9337     |
> | 9338     |
> | 9339     |
> | 9340     |
> | 9341     |
> | 9342     |
> | 9343     |
> | 9344     |
> | 9345     |
> | 9346     |
> | 9347     |
> | 9348     |
> | 9349     |
> | 9350     |
> | 9351     |
> | 9352     |
> | 9353     |
> | 9354     |
> | 9355     |
> | 9356     |
> | 9357     |
> | 9358     |
> | 9359     |
> | 9360     |
> | 9361     |
> | 9362     |
> | 9363     |
> | 9364     |
> | 9365     |
> | 9366     |
> | 9367     |
> | 9368     |
> | 9369     |
> | 9370     |
> | 9371     |
> | 9372     |
> | 9373     |
> | 9374     |
> | 9375     |
> | 9376     |
> | 9377     |
> | 9378     |
> | 9379     |
> | 9380     |
> | 9381     |
> | 9382     |
> | 9383     |
> | 9384     |
> | 9385     |
> | 9386     |
> | 9387     |
> +----------+--+
> | Cust_Id  |
> +----------+--+
> | 9388     |
> | 9389     |
> | 9390     |
> | 9391     |
> | 9392     |
> | 9393     |
> | 9394     |
> | 9395     |
> | 9396     |
> | 9397     |
> | 9398     |
> | 9399     |
> | 9400     |
> | 9401     |
> | 9402     |
> | 9403     |
> | 9404     |
> | 9405     |
> | 9406     |
> | 9407     |
> | 9408     |
> | 9409     |
> | 9410     |
> | 9411     |
> | 9412     |
> | 9413     |
> | 9414     |
> | 9415     |
> | 9416     |
> | 9417     |
> | 9418     |
> | 9419     |
> | 9420     |
> | 9421     |
> | 9422     |
> | 9423     |
> | 9424     |
> | 9425     |
> | 9426     |
> | 9427     |
> | 9428     |
> | 9429     |
> | 9430     |
> | 9431     |
> | 9432     |
> | 9433     |
> | 9434     |
> | 9435     |
> | 9436     |
> | 9437     |
> | 9438     |
> | 9439     |
> | 9440     |
> | 9441     |
> | 9442     |
> | 9443     |
> | 9444     |
> | 9445     |
> | 9446     |
> | 9447     |
> | 9448     |
> | 9449     |
> | 9450     |
> | 9451     |
> | 9452     |
> | 9453     |
> | 9454     |
> | 9455     |
> | 9456     |
> | 9457     |
> | 9458     |
> | 9459     |
> | 9460     |
> | 9461     |
> | 9462     |
> | 9463     |
> | 9464     |
> | 9465     |
> | 9466     |
> | 9467     |
> | 9468     |
> | 9469     |
> | 9470     |
> | 9471     |
> | 9472     |
> | 9473     |
> | 9474     |
> | 9475     |
> | 9476     |
> | 9477     |
> | 9478     |
> | 9479     |
> | 9480     |
> | 9481     |
> | 9482     |
> | 9483     |
> | 9484     |
> | 9485     |
> | 9486     |
> | 9487     |
> +----------+--+
> | Cust_Id  |
> +----------+--+
> | 9488     |
> | 9489     |
> | 9490     |
> | 9491     |
> | 9492     |
> | 9493     |
> | 9494     |
> | 9495     |
> | 9496     |
> | 9497     |
> | 9498     |
> | 9499     |
> | 9500     |
> | 9501     |
> | 9502     |
> | 9503     |
> | 9504     |
> | 9505     |
> | 9506     |
> | 9507     |
> | 9508     |
> | 9509     |
> | 9510     |
> | 9511     |
> | 9512     |
> | 9513     |
> | 9514     |
> | 9515     |
> | 9516     |
> | 9517     |
> | 9518     |
> | 9519     |
> | 9520     |
> | 9521     |
> | 9522     |
> | 9523     |
> | 9524     |
> | 9525     |
> | 9526     |
> | 9527     |
> | 9528     |
> | 9529     |
> | 9530     |
> | 9531     |
> | 9532     |
> | 9533     |
> | 9534     |
> | 9535     |
> | 9536     |
> | 9537     |
> | 9538     |
> | 9539     |
> | 9540     |
> | 9541     |
> | 9542     |
> | 9543     |
> | 9544     |
> | 9545     |
> | 9546     |
> | 9547     |
> | 9548     |
> | 9549     |
> | 9550     |
> | 9551     |
> | 9552     |
> | 9553     |
> | 9554     |
> | 9555     |
> | 9556     |
> | 9557     |
> | 9558     |
> | 9559     |
> | 9560     |
> | 9561     |
> | 9562     |
> | 9563     |
> | 9564     |
> | 9565     |
> | 9566     |
> | 9567     |
> | 9568     |
> | 9569     |
> | 9570     |
> | 9571     |
> | 9572     |
> | 9573     |
> | 9574     |
> | 9575     |
> | 9576     |
> | 9577     |
> | 9578     |
> | 9579     |
> | 9580     |
> | 9581     |
> | 9582     |
> | 9583     |
> | 9584     |
> | 9585     |
> | 9586     |
> | 9587     |
> +----------+--+
> | Cust_Id  |
> +----------+--+
> | 9588     |
> | 9589     |
> | 9590     |
> | 9591     |
> | 9592     |
> | 9593     |
> | 9594     |
> | 9595     |
> | 9596     |
> | 9597     |
> | 9598     |
> | 9599     |
> | 9600     |
> | 9601     |
> | 9602     |
> | 9603     |
> | 9604     |
> | 9605     |
> | 9606     |
> | 9607     |
> | 9608     |
> | 9609     |
> | 9610     |
> | 9611     |
> | 9612     |
> | 9613     |
> | 9614     |
> | 9615     |
> | 9616     |
> | 9617     |
> | 9618     |
> | 9619     |
> | 9620     |
> | 9621     |
> | 9622     |
> | 9623     |
> | 9624     |
> | 9625     |
> | 9626     |
> | 9627     |
> | 9628     |
> | 9629     |
> | 9630     |
> | 9631     |
> | 9632     |
> | 9633     |
> | 9634     |
> | 9635     |
> | 9636     |
> | 9637     |
> | 9638     |
> | 9639     |
> | 9640     |
> | 9641     |
> | 9642     |
> | 9643     |
> | 9644     |
> | 9645     |
> | 9646     |
> | 9647     |
> | 9648     |
> | 9649     |
> | 9650     |
> | 9651     |
> | 9652     |
> | 9653     |
> | 9654     |
> | 9655     |
> | 9656     |
> | 9657     |
> | 9658     |
> | 9659     |
> | 9660     |
> | 9661     |
> | 9662     |
> | 9663     |
> | 9664     |
> | 9665     |
> | 9666     |
> | 9667     |
> | 9668     |
> | 9669     |
> | 9670     |
> | 9671     |
> | 9672     |
> | 9673     |
> | 9674     |
> | 9675     |
> | 9676     |
> | 9677     |
> | 9678     |
> | 9679     |
> | 9680     |
> | 9681     |
> | 9682     |
> | 9683     |
> | 9684     |
> | 9685     |
> | 9686     |
> | 9687     |
> +----------+--+
> | Cust_Id  |
> +----------+--+
> | 9688     |
> | 9689     |
> | 9690     |
> | 9691     |
> | 9692     |
> | 9693     |
> | 9694     |
> | 9695     |
> | 9696     |
> | 9697     |
> | 9698     |
> | 9699     |
> | 9700     |
> | 9701     |
> | 9702     |
> | 9703     |
> | 9704     |
> | 9705     |
> | 9706     |
> | 9707     |
> | 9708     |
> | 9709     |
> | 9710     |
> | 9711     |
> | 9712     |
> | 9713     |
> | 9714     |
> | 9715     |
> | 9716     |
> | 9717     |
> | 9718     |
> | 9719     |
> | 9720     |
> | 9721     |
> | 9722     |
> | 9723     |
> | 9724     |
> | 9725     |
> | 9726     |
> | 9727     |
> | 9728     |
> | 9729     |
> | 9730     |
> | 9731     |
> | 9732     |
> | 9733     |
> | 9734     |
> | 9735     |
> | 9736     |
> | 9737     |
> | 9738     |
> | 9739     |
> | 9740     |
> | 9741     |
> | 9742     |
> | 9743     |
> | 9744     |
> | 9745     |
> | 9746     |
> | 9747     |
> | 9748     |
> | 9749     |
> | 9750     |
> | 9751     |
> | 9752     |
> | 9753     |
> | 9754     |
> | 9755     |
> | 9756     |
> | 9757     |
> | 9758     |
> | 9759     |
> | 9760     |
> | 9761     |
> | 9762     |
> | 9763     |
> | 9764     |
> | 9765     |
> | 9766     |
> | 9767     |
> | 9768     |
> | 9769     |
> | 9770     |
> | 9771     |
> | 9772     |
> | 9773     |
> | 9774     |
> | 9775     |
> | 9776     |
> | 9777     |
> | 9778     |
> | 9779     |
> | 9780     |
> | 9781     |
> | 9782     |
> | 9783     |
> | 9784     |
> | 9785     |
> | 9786     |
> | 9787     |
> +----------+--+
> | Cust_Id  |
> +----------+--+
> | 9788     |
> | 9789     |
> | 9790     |
> | 9791     |
> | 9792     |
> | 9793     |
> | 9794     |
> | 9795     |
> | 9796     |
> | 9797     |
> | 9798     |
> | 9799     |
> | 9800     |
> | 9801     |
> | 9802     |
> | 9803     |
> | 9804     |
> | 9805     |
> | 9806     |
> | 9807     |
> | 9808     |
> | 9809     |
> | 9810     |
> | 9811     |
> | 9812     |
> | 9813     |
> | 9814     |
> | 9815     |
> | 9816     |
> | 9817     |
> | 9818     |
> | 9819     |
> | 9820     |
> | 9821     |
> | 9822     |
> | 9823     |
> | 9824     |
> | 9825     |
> | 9826     |
> | 9827     |
> | 9828     |
> | 9829     |
> | 9830     |
> | 9831     |
> | 9832     |
> | 9833     |
> | 9834     |
> | 9835     |
> | 9836     |
> | 9837     |
> | 9838     |
> | 9839     |
> | 9840     |
> | 9841     |
> | 9842     |
> | 9843     |
> | 9844     |
> | 9845     |
> | 9846     |
> | 9847     |
> | 9848     |
> | 9849     |
> | 9850     |
> | 9851     |
> | 9852     |
> | 9853     |
> | 9854     |
> | 9855     |
> | 9856     |
> | 9857     |
> | 9858     |
> | 9859     |
> | 9860     |
> | 9861     |
> | 9862     |
> | 9863     |
> | 9864     |
> | 9865     |
> | 9866     |
> | 9867     |
> | 9868     |
> | 9869     |
> | 9870     |
> | 9871     |
> | 9872     |
> | 9873     |
> | 9874     |
> | 9875     |
> | 9876     |
> | 9877     |
> | 9878     |
> | 9879     |
> | 9880     |
> | 9881     |
> | 9882     |
> | 9883     |
> | 9884     |
> | 9885     |
> | 9886     |
> | 9887     |
> +----------+--+
> | Cust_Id  |
> +----------+--+
> | 9888     |
> | 9889     |
> | 9890     |
> | 9891     |
> | 9892     |
> | 9893     |
> | 9894     |
> | 9895     |
> | 9896     |
> | 9897     |
> | 9898     |
> | 9899     |
> | 9900     |
> | 9901     |
> | 9902     |
> | 9903     |
> | 9904     |
> | 9905     |
> | 9906     |
> | 9907     |
> | 9908     |
> | 9909     |
> | 9910     |
> | 9911     |
> | 9912     |
> | 9913     |
> | 9914     |
> | 9915     |
> | 9916     |
> | 9917     |
> | 9918     |
> | 9919     |
> | 9920     |
> | 9921     |
> | 9922     |
> | 9923     |
> | 9924     |
> | 9925     |
> | 9926     |
> | 9927     |
> | 9928     |
> | 9929     |
> | 9930     |
> | 9931     |
> | 9932     |
> | 9933     |
> | 9934     |
> | 9935     |
> | 9936     |
> | 9937     |
> | 9938     |
> | 9939     |
> | 9940     |
> | 9941     |
> | 9942     |
> | 9943     |
> | 9944     |
> | 9945     |
> | 9946     |
> | 9947     |
> | 9948     |
> | 9949     |
> | 9950     |
> | 9951     |
> | 9952     |
> | 9953     |
> | 9954     |
> | 9955     |
> | 9956     |
> | 9957     |
> | 9958     |
> | 9959     |
> | 9960     |
> | 9961     |
> | 9962     |
> | 9963     |
> | 9964     |
> | 9965     |
> | 9966     |
> | 9967     |
> | 9968     |
> | 9969     |
> | 9970     |
> | 9971     |
> | 9972     |
> | 9973     |
> | 9974     |
> | 9975     |
> | 9976     |
> | 9977     |
> | 9978     |
> | 9979     |
> | 9980     |
> | 9981     |
> | 9982     |
> | 9983     |
> | 9984     |
> | 9985     |
> | 9986     |
> | 9987     |
> +----------+--+
> | Cust_Id  |
> +----------+--+
> | 9988     |
> | 9989     |
> | 9990     |
> | 9991     |
> | 9992     |
> | 9993     |
> | 9994     |
> | 9995     |
> | 9996     |
> | 9997     |
> | 9998     |
> | 9999     |
> | 10000    |
> | 10001    |
> | 10002    |
> | 10003    |
> | 10004    |
> | 10005    |
> | 10006    |
> | 10007    |
> | 10008    |
> | 10009    |
> | 10010    |
> | 10011    |
> | 10012    |
> | 10013    |
> | 10014    |
> | 10015    |
> | 10016    |
> | 10017    |
> | 10018    |
> | 10019    |
> | 10020    |
> | 10021    |
> | 10022    |
> | 10023    |
> | 10024    |
> | 10025    |
> | 10026    |
> | 10027    |
> | 10028    |
> | 10029    |
> | 10030    |
> | 10031    |
> | 10032    |
> | 10033    |
> | 10034    |
> | 10035    |
> | 10036    |
> | 10037    |
> | 10038    |
> | 10039    |
> | 10040    |
> | 10041    |
> | 10042    |
> | 10043    |
> | 10044    |
> | 10045    |
> | 10046    |
> | 10047    |
> | 10048    |
> | 10049    |
> | 10050    |
> | 10051    |
> | 10052    |
> | 10053    |
> | 10054    |
> | 10055    |
> | 10056    |
> | 10057    |
> | 10058    |
> | 10059    |
> | 10060    |
> | 10061    |
> | 10062    |
> | 10063    |
> | 10064    |
> | 10065    |
> | 10066    |
> | 10067    |
> | 10068    |
> | 10069    |
> | 10070    |
> | 10071    |
> | 10072    |
> | 10073    |
> | 10074    |
> | 10075    |
> | 10076    |
> | 10077    |
> | 10078    |
> | 10079    |
> | 10080    |
> | 10081    |
> | 10082    |
> | 10083    |
> | 10084    |
> | 10085    |
> | 10086    |
> | 10087    |
> +----------+--+
> | Cust_Id  |
> +----------+--+
> | 10088    |
> | 10089    |
> | 10090    |
> | 10091    |
> | 10092    |
> | 10093    |
> | 10094    |
> | 10095    |
> | 10096    |
> | 10097    |
> | 10098    |
> | 10099    |
> | 10100    |
> | 10101    |
> | 10102    |
> | 10103    |
> | 10104    |
> | 10105    |
> | 10106    |
> | 10107    |
> | 10108    |
> | 10109    |
> | 10110    |
> | 10111    |
> | 10112    |
> | 10113    |
> | 10114    |
> | 10115    |
> | 10116    |
> | 10117    |
> | 10118    |
> | 10119    |
> | 10120    |
> | 10121    |
> | 10122    |
> | 10123    |
> | 10124    |
> | 10125    |
> | 10126    |
> | 10127    |
> | 10128    |
> | 10129    |
> | 10130    |
> | 10131    |
> | 10132    |
> | 10133    |
> | 10134    |
> | 10135    |
> | 10136    |
> | 10137    |
> | 10138    |
> | 10139    |
> | 10140    |
> | 10141    |
> | 10142    |
> | 10143    |
> | 10144    |
> | 10145    |
> | 10146    |
> | 10147    |
> | 10148    |
> | 10149    |
> | 10150    |
> | 10151    |
> | 10152    |
> | 10153    |
> | 10154    |
> | 10155    |
> | 10156    |
> | 10157    |
> | 10158    |
> | 10159    |
> | 10160    |
> | 10161    |
> | 10162    |
> | 10163    |
> | 10164    |
> | 10165    |
> | 10166    |
> | 10167    |
> | 10168    |
> | 10169    |
> | 10170    |
> | 10171    |
> | 10172    |
> | 10173    |
> | 10174    |
> | 10175    |
> | 10176    |
> | 10177    |
> | 10178    |
> | 10179    |
> | 10180    |
> | 10181    |
> | 10182    |
> | 10183    |
> | 10184    |
> | 10185    |
> | 10186    |
> | 10187    |
> +----------+--+
> | Cust_Id  |
> +----------+--+
> | 10188    |
> | 10189    |
> | 10190    |
> | 10191    |
> | 10192    |
> | 10193    |
> | 10194    |
> | 10195    |
> | 10196    |
> | 10197    |
> | 10198    |
> | 10199    |
> | 10200    |
> | 10201    |
> | 10202    |
> | 10203    |
> | 10204    |
> | 10205    |
> | 10206    |
> | 10207    |
> | 10208    |
> | 10209    |
> | 10210    |
> | 10211    |
> | 10212    |
> | 10213    |
> | 10214    |
> | 10215    |
> | 10216    |
> | 10217    |
> | 10218    |
> | 10219    |
> | 10220    |
> | 10221    |
> | 10222    |
> | 10223    |
> | 10224    |
> | 10225    |
> | 10226    |
> | 10227    |
> | 10228    |
> | 10229    |
> | 10230    |
> | 10231    |
> | 10232    |
> | 10233    |
> | 10234    |
> | 10235    |
> | 10236    |
> | 10237    |
> | 10238    |
> | 10239    |
> | 10240    |
> | 10241    |
> | 10242    |
> | 10243    |
> | 10244    |
> | 10245    |
> | 10246    |
> | 10247    |
> | 10248    |
> | 10249    |
> | 10250    |
> | 10251    |
> | 10252    |
> | 10253    |
> | 10254    |
> | 10255    |
> | 10256    |
> | 10257    |
> | 10258    |
> | 10259    |
> | 10260    |
> | 10261    |
> | 10262    |
> | 10263    |
> | 10264    |
> | 10265    |
> | 10266    |
> | 10267    |
> | 10268    |
> | 10269    |
> | 10270    |
> | 10271    |
> | 10272    |
> | 10273    |
> | 10274    |
> | 10275    |
> | 10276    |
> | 10277    |
> | 10278    |
> | 10279    |
> | 10280    |
> | 10281    |
> | 10282    |
> | 10283    |
> | 10284    |
> | 10285    |
> | 10286    |
> | 10287    |
> +----------+--+
> | Cust_Id  |
> +----------+--+
> | 10288    |
> | 10289    |
> | 10290    |
> | 10291    |
> | 10292    |
> | 10293    |
> | 10294    |
> | 10295    |
> | 10296    |
> | 10297    |
> | 10298    |
> | 10299    |
> | 10300    |
> | 10301    |
> | 10302    |
> | 10303    |
> | 10304    |
> | 10305    |
> | 10306    |
> | 10307    |
> | 10308    |
> | 10309    |
> | 10310    |
> | 10311    |
> | 10312    |
> | 10313    |
> | 10314    |
> | 10315    |
> | 10316    |
> | 10317    |
> | 10318    |
> | 10319    |
> | 10320    |
> | 10321    |
> | 10322    |
> | 10323    |
> | 10324    |
> | 10325    |
> | 10326    |
> | 10327    |
> | 10328    |
> | 10329    |
> | 10330    |
> | 10331    |
> | 10332    |
> | 10333    |
> | 10334    |
> | 10335    |
> | 10336    |
> | 10337    |
> | 10338    |
> | 10339    |
> | 10340    |
> | 10341    |
> | 10342    |
> | 10343    |
> | 10344    |
> | 10345    |
> | 10346    |
> | 10347    |
> | 10348    |
> | 10349    |
> | 10350    |
> | 10351    |
> | 10352    |
> | 10353    |
> | 10354    |
> | 10355    |
> | 10356    |
> | 10357    |
> | 10358    |
> | 10359    |
> | 10360    |
> | 10361    |
> | 10362    |
> | 10363    |
> | 10364    |
> | 10365    |
> | 10366    |
> | 10367    |
> | 10368    |
> | 10369    |
> | 10370    |
> | 10371    |
> | 10372    |
> | 10373    |
> | 10374    |
> | 10375    |
> | 10376    |
> | 10377    |
> | 10378    |
> | 10379    |
> | 10380    |
> | 10381    |
> | 10382    |
> | 10383    |
> | 10384    |
> | 10385    |
> | 10386    |
> | 10387    |
> +----------+--+
> | Cust_Id  |
> +----------+--+
> | 10388    |
> | 10389    |
> | 10390    |
> | 10391    |
> | 10392    |
> | 10393    |
> | 10394    |
> | 10395    |
> | 10396    |
> | 10397    |
> | 10398    |
> | 10399    |
> | 10400    |
> | 10401    |
> | 10402    |
> | 10403    |
> | 10404    |
> | 10405    |
> | 10406    |
> | 10407    |
> | 10408    |
> | 10409    |
> | 10410    |
> | 10411    |
> | 10412    |
> | 10413    |
> | 10414    |
> | 10415    |
> | 10416    |
> | 10417    |
> | 10418    |
> | 10419    |
> | 10420    |
> | 10421    |
> | 10422    |
> | 10423    |
> | 10424    |
> | 10425    |
> | 10426    |
> | 10427    |
> | 10428    |
> | 10429    |
> | 10430    |
> | 10431    |
> | 10432    |
> | 10433    |
> | 10434    |
> | 10435    |
> | 10436    |
> | 10437    |
> | 10438    |
> | 10439    |
> | 10440    |
> | 10441    |
> | 10442    |
> | 10443    |
> | 10444    |
> | 10445    |
> | 10446    |
> | 10447    |
> | 10448    |
> | 10449    |
> | 10450    |
> | 10451    |
> | 10452    |
> | 10453    |
> | 10454    |
> | 10455    |
> | 10456    |
> | 10457    |
> | 10458    |
> | 10459    |
> | 10460    |
> | 10461    |
> | 10462    |
> | 10463    |
> | 10464    |
> | 10465    |
> | 10466    |
> | 10467    |
> | 10468    |
> | 10469    |
> | 10470    |
> | 10471    |
> | 10472    |
> | 10473    |
> | 10474    |
> | 10475    |
> | 10476    |
> | 10477    |
> | 10478    |
> | 10479    |
> | 10480    |
> | 10481    |
> | 10482    |
> | 10483    |
> | 10484    |
> | 10485    |
> | 10486    |
> | 10487    |
> +----------+--+
> | Cust_Id  |
> +----------+--+
> | 10488    |
> | 10489    |
> | 10490    |
> | 10491    |
> | 10492    |
> | 10493    |
> | 10494    |
> | 10495    |
> | 10496    |
> | 10497    |
> | 10498    |
> | 10499    |
> | 10500    |
> | 10501    |
> | 10502    |
> | 10503    |
> | 10504    |
> | 10505    |
> | 10506    |
> | 10507    |
> | 10508    |
> | 10509    |
> | 10510    |
> | 10511    |
> | 10512    |
> | 10513    |
> | 10514    |
> | 10515    |
> | 10516    |
> | 10517    |
> | 10518    |
> | 10519    |
> | 10520    |
> | 10521    |
> | 10522    |
> | 10523    |
> | 10524    |
> | 10525    |
> | 10526    |
> | 10527    |
> | 10528    |
> | 10529    |
> | 10530    |
> | 10531    |
> | 10532    |
> | 10533    |
> | 10534    |
> | 10535    |
> | 10536    |
> | 10537    |
> | 10538    |
> | 10539    |
> | 10540    |
> | 10541    |
> | 10542    |
> | 10543    |
> | 10544    |
> | 10545    |
> | 10546    |
> | 10547    |
> | 10548    |
> | 10549    |
> | 10550    |
> | 10551    |
> | 10552    |
> | 10553    |
> | 10554    |
> | 10555    |
> | 10556    |
> | 10557    |
> | 10558    |
> | 10559    |
> | 10560    |
> | 10561    |
> | 10562    |
> | 10563    |
> | 10564    |
> | 10565    |
> | 10566    |
> | 10567    |
> | 10568    |
> | 10569    |
> | 10570    |
> | 10571    |
> | 10572    |
> | 10573    |
> | 10574    |
> | 10575    |
> | 10576    |
> | 10577    |
> | 10578    |
> | 10579    |
> | 10580    |
> | 10581    |
> | 10582    |
> | 10583    |
> | 10584    |
> | 10585    |
> | 10586    |
> | 10587    |
> +----------+--+
> | Cust_Id  |
> +----------+--+
> | 10588    |
> | 10589    |
> | 10590    |
> | 10591    |
> | 10592    |
> | 10593    |
> | 10594    |
> | 10595    |
> | 10596    |
> | 10597    |
> | 10598    |
> | 10599    |
> | 10600    |
> | 10601    |
> | 10602    |
> | 10603    |
> | 10604    |
> | 10605    |
> | 10606    |
> | 10607    |
> | 10608    |
> | 10609    |
> | 10610    |
> | 10611    |
> | 10612    |
> | 10613    |
> | 10614    |
> | 10615    |
> | 10616    |
> | 10617    |
> | 10618    |
> | 10619    |
> | 10620    |
> | 10621    |
> | 10622    |
> | 10623    |
> | 10624    |
> | 10625    |
> | 10626    |
> | 10627    |
> | 10628    |
> | 10629    |
> | 10630    |
> | 10631    |
> | 10632    |
> | 10633    |
> | 10634    |
> | 10635    |
> | 10636    |
> | 10637    |
> | 10638    |
> | 10639    |
> | 10640    |
> | 10641    |
> | 10642    |
> | 10643    |
> | 10644    |
> | 10645    |
> | 10646    |
> | 10647    |
> | 10648    |
> | 10649    |
> | 10650    |
> | 10651    |
> | 10652    |
> | 10653    |
> | 10654    |
> | 10655    |
> | 10656    |
> | 10657    |
> | 10658    |
> | 10659    |
> | 10660    |
> | 10661    |
> | 10662    |
> | 10663    |
> | 10664    |
> | 10665    |
> | 10666    |
> | 10667    |
> | 10668    |
> | 10669    |
> | 10670    |
> | 10671    |
> | 10672    |
> | 10673    |
> | 10674    |
> | 10675    |
> | 10676    |
> | 10677    |
> | 10678    |
> | 10679    |
> | 10680    |
> | 10681    |
> | 10682    |
> | 10683    |
> | 10684    |
> | 10685    |
> | 10686    |
> | 10687    |
> +----------+--+
> | Cust_Id  |
> +----------+--+
> | 10688    |
> | 10689    |
> | 10690    |
> | 10691    |
> | 10692    |
> | 10693    |
> | 10694    |
> | 10695    |
> | 10696    |
> | 10697    |
> | 10698    |
> | 10699    |
> | 10700    |
> | 10701    |
> | 10702    |
> | 10703    |
> | 10704    |
> | 10705    |
> | 10706    |
> | 10707    |
> | 10708    |
> | 10709    |
> | 10710    |
> | 10711    |
> | 10712    |
> | 10713    |
> | 10714    |
> | 10715    |
> | 10716    |
> | 10717    |
> | 10718    |
> | 10719    |
> | 10720    |
> | 10721    |
> | 10722    |
> | 10723    |
> | 10724    |
> | 10725    |
> | 10726    |
> | 10727    |
> | 10728    |
> | 10729    |
> | 10730    |
> | 10731    |
> | 10732    |
> | 10733    |
> | 10734    |
> | 10735    |
> | 10736    |
> | 10737    |
> | 10738    |
> | 10739    |
> | 10740    |
> | 10741    |
> | 10742    |
> | 10743    |
> | 10744    |
> | 10745    |
> | 10746    |
> | 10747    |
> | 10748    |
> | 10749    |
> | 10750    |
> | 10751    |
> | 10752    |
> | 10753    |
> | 10754    |
> | 10755    |
> | 10756    |
> | 10757    |
> | 10758    |
> | 10759    |
> | 10760    |
> | 10761    |
> | 10762    |
> | 10763    |
> | 10764    |
> | 10765    |
> | 10766    |
> | 10767    |
> | 10768    |
> | 10769    |
> | 10770    |
> | 10771    |
> | 10772    |
> | 10773    |
> | 10774    |
> | 10775    |
> | 10776    |
> | 10777    |
> | 10778    |
> | 10779    |
> | 10780    |
> | 10781    |
> | 10782    |
> | 10783    |
> | 10784    |
> | 10785    |
> | 10786    |
> | 10787    |
> +----------+--+
> | Cust_Id  |
> +----------+--+
> | 10788    |
> | 10789    |
> | 10790    |
> | 10791    |
> | 10792    |
> | 10793    |
> | 10794    |
> | 10795    |
> | 10796    |
> | 10797    |
> | 10798    |
> | 10799    |
> | 10800    |
> | 10801    |
> | 10802    |
> | 10803    |
> | 10804    |
> | 10805    |
> | 10806    |
> | 10807    |
> | 10808    |
> | 10809    |
> | 10810    |
> | 10811    |
> | 10812    |
> | 10813    |
> | 10814    |
> | 10815    |
> | 10816    |
> | 10817    |
> | 10818    |
> | 10819    |
> | 10820    |
> | 10821    |
> | 10822    |
> | 10823    |
> | 10824    |
> | 10825    |
> | 10826    |
> | 10827    |
> | 10828    |
> | 10829    |
> | 10830    |
> | 10831    |
> | 10832    |
> | 10833    |
> | 10834    |
> | 10835    |
> | 10836    |
> | 10837    |
> | 10838    |
> | 10839    |
> | 10840    |
> | 10841    |
> | 10842    |
> | 10843    |
> | 10844    |
> | 10845    |
> | 10846    |
> | 10847    |
> | 10848    |
> | 10849    |
> | 10850    |
> | 10851    |
> | 10852    |
> | 10853    |
> | 10854    |
> | 10855    |
> | 10856    |
> | 10857    |
> | 10858    |
> | 10859    |
> | 10860    |
> | 10861    |
> | 10862    |
> | 10863    |
> | 10864    |
> | 10865    |
> | 10866    |
> | 10867    |
> | 10868    |
> | 10869    |
> | 10870    |
> | 10871    |
> | 10872    |
> | 10873    |
> | 10874    |
> | 10875    |
> | 10876    |
> | 10877    |
> | 10878    |
> | 10879    |
> | 10880    |
> | 10881    |
> | 10882    |
> | 10883    |
> | 10884    |
> | 10885    |
> | 10886    |
> | 10887    |
> +----------+--+
> | Cust_Id  |
> +----------+--+
> | 10888    |
> | 10889    |
> | 10890    |
> | 10891    |
> | 10892    |
> | 10893    |
> | 10894    |
> | 10895    |
> | 10896    |
> | 10897    |
> | 10898    |
> | 10899    |
> | 10900    |
> | 10901    |
> | 10902    |
> | 10903    |
> | 10904    |
> | 10905    |
> | 10906    |
> | 10907    |
> | 10908    |
> | 10909    |
> | 10910    |
> | 10911    |
> | 10912    |
> | 10913    |
> | 10914    |
> | 10915    |
> | 10916    |
> | 10917    |
> | 10918    |
> | 10919    |
> | 10920    |
> | 10921    |
> | 10922    |
> | 10923    |
> | 10924    |
> | 10925    |
> | 10926    |
> | 10927    |
> | 10928    |
> | 10929    |
> | 10930    |
> | 10931    |
> | 10932    |
> | 10933    |
> | 10934    |
> | 10935    |
> | 10936    |
> | 10937    |
> | 10938    |
> | 10939    |
> | 10940    |
> | 10941    |
> | 10942    |
> | 10943    |
> | 10944    |
> | 10945    |
> | 10946    |
> | 10947    |
> | 10948    |
> | 10949    |
> | 10950    |
> | 10951    |
> | 10952    |
> | 10953    |
> | 10954    |
> | 10955    |
> | 10956    |
> | 10957    |
> | 10958    |
> | 10959    |
> | 10960    |
> | 10961    |
> | 10962    |
> | 10963    |
> | 10964    |
> | 10965    |
> | 10966    |
> | 10967    |
> | 10968    |
> | 10969    |
> | 10970    |
> | 10971    |
> | 10972    |
> | 10973    |
> | 10974    |
> | 10975    |
> | 10976    |
> | 10977    |
> | 10978    |
> | 10979    |
> | 10980    |
> | 10981    |
> | 10982    |
> | 10983    |
> | 10984    |
> | 10985    |
> | 10986    |
> | 10987    |
> +----------+--+
> | Cust_Id  |
> +----------+--+
> | 10988    |
> | 10989    |
> | 10990    |
> | 10991    |
> | 10992    |
> | 10993    |
> | 10994    |
> | 10995    |
> | 10996    |
> | 10997    |
> | 10998    |
> | 10999    |
> | NULL     |
> +----------+--+
> 2,013 rows selected (0.231 seconds)



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)


Mime
View raw message