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)