Vinod Rohilla created CARBONDATA-774: ----------------------------------------
Summary: Not like operators does not work properly in carbondata Key: CARBONDATA-774 URL: https://issues.apache.org/jira/browse/CARBONDATA-774 Project: CarbonData Issue Type: Bug Components: sql Affects Versions: 1.0.0-incubating Environment: Spark 2.1 Reporter: Vinod Rohilla Priority: Trivial Attachments: CSV.tar.gz Not Like operator result does not display same as hive. Steps to reproduces: A): Create table in Hive CREATE TABLE uniqdata_h (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) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' 2:Load Data in hive a)load data local inpath '/opt/TestData/Data/uniqdata/2000_UniqData.csv' into table uniqdata_h b)load data local inpath '/opt/TestData/Data/uniqdata/4000_UniqData.csv' into table uniqdata_h c)load data local inpath '/opt/TestData/Data/uniqdata/6000_UniqData.csv' into table uniqdata_h d)load data local inpath '/opt/TestData/Data/uniqdata/7000_UniqData.csv' into table uniqdata_h e)load data local inpath '/opt/TestData/Data/uniqdata/3000_1_UniqData.csv' into table uniqdata_h 3: Run the Query: select CUST_ID from uniqdata_h where CUST_ID NOT LIKE 100079 4:Result in Hive +----------+--+ | CUST_ID | +----------+--+ | 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 | | 9088 | | 9089 | | 9090 | | 9091 | | 9092 | | 9093 | | 9094 | | 9095 | | 9096 | | 9097 | | 9098 | +----------+--+ | CUST_ID | +----------+--+ | 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 | | 9188 | | 9189 | | 9190 | | 9191 | | 9192 | | 9193 | | 9194 | | 9195 | | 9196 | | 9197 | | 9198 | +----------+--+ | CUST_ID | +----------+--+ | 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 | | 9288 | | 9289 | | 9290 | | 9291 | | 9292 | | 9293 | | 9294 | | 9295 | | 9296 | | 9297 | | 9298 | +----------+--+ | CUST_ID | +----------+--+ | 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 | | 9388 | | 9389 | | 9390 | | 9391 | | 9392 | | 9393 | | 9394 | | 9395 | | 9396 | | 9397 | | 9398 | +----------+--+ | CUST_ID | +----------+--+ | 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 | | 9488 | | 9489 | | 9490 | | 9491 | | 9492 | | 9493 | | 9494 | | 9495 | | 9496 | | 9497 | | 9498 | +----------+--+ | CUST_ID | +----------+--+ | 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 | | 9588 | | 9589 | | 9590 | | 9591 | | 9592 | | 9593 | | 9594 | | 9595 | | 9596 | | 9597 | | 9598 | +----------+--+ | CUST_ID | +----------+--+ | 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 | | 9688 | | 9689 | | 9690 | | 9691 | | 9692 | | 9693 | | 9694 | | 9695 | | 9696 | | 9697 | | 9698 | +----------+--+ | CUST_ID | +----------+--+ | 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 | | 9788 | | 9789 | | 9790 | | 9791 | | 9792 | | 9793 | | 9794 | | 9795 | | 9796 | | 9797 | | 9798 | +----------+--+ | CUST_ID | +----------+--+ | 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 | | 9888 | | 9889 | | 9890 | | 9891 | | 9892 | | 9893 | | 9894 | | 9895 | | 9896 | | 9897 | | 9898 | +----------+--+ | CUST_ID | +----------+--+ | 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 | | 9988 | | 9989 | | 9990 | | 9991 | | 9992 | | 9993 | | 9994 | | 9995 | | 9996 | | 9997 | | 9998 | +----------+--+ | CUST_ID | +----------+--+ | 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 | | 10088 | | 10089 | | 10090 | | 10091 | | 10092 | | 10093 | | 10094 | | 10095 | | 10096 | | 10097 | | 10098 | +----------+--+ | CUST_ID | +----------+--+ | 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 | | 10188 | | 10189 | | 10190 | | 10191 | | 10192 | | 10193 | | 10194 | | 10195 | | 10196 | | 10197 | | 10198 | +----------+--+ | CUST_ID | +----------+--+ | 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 | | 10288 | | 10289 | | 10290 | | 10291 | | 10292 | | 10293 | | 10294 | | 10295 | | 10296 | | 10297 | | 10298 | +----------+--+ | CUST_ID | +----------+--+ | 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 | | 10388 | | 10389 | | 10390 | | 10391 | | 10392 | | 10393 | | 10394 | | 10395 | | 10396 | | 10397 | | 10398 | +----------+--+ | CUST_ID | +----------+--+ | 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 | | 10488 | | 10489 | | 10490 | | 10491 | | 10492 | | 10493 | | 10494 | | 10495 | | 10496 | | 10497 | | 10498 | +----------+--+ | CUST_ID | +----------+--+ | 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 | | 10588 | | 10589 | | 10590 | | 10591 | | 10592 | | 10593 | | 10594 | | 10595 | | 10596 | | 10597 | | 10598 | +----------+--+ | CUST_ID | +----------+--+ | 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 | | 10688 | | 10689 | | 10690 | | 10691 | | 10692 | | 10693 | | 10694 | | 10695 | | 10696 | | 10697 | | 10698 | +----------+--+ | CUST_ID | +----------+--+ | 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 | | 10788 | | 10789 | | 10790 | | 10791 | | 10792 | | 10793 | | 10794 | | 10795 | | 10796 | | 10797 | | 10798 | +----------+--+ | CUST_ID | +----------+--+ | 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 | | 10888 | | 10889 | | 10890 | | 10891 | | 10892 | | 10893 | | 10894 | | 10895 | | 10896 | | 10897 | | 10898 | +----------+--+ | CUST_ID | +----------+--+ | 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 | | 10988 | | 10989 | | 10990 | | 10991 | | 10992 | | 10993 | | 10994 | | 10995 | | 10996 | | 10997 | | 10998 | +----------+--+ | CUST_ID | +----------+--+ | 10999 | +----------+--+ B) Create table in carbon CREATE TABLE uniqdata (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 ("TABLE_BLOCKSIZE"= "256 MB") 2:Load Data in hive a)LOAD DATA INPATH 'HDFS_URL/BabuStore/Data/uniqdata/2000_UniqData.csv' into table uniqdata OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1') b)LOAD DATA INPATH 'HDFS_URL/BabuStore/Data/uniqdata/4000_UniqData.csv' into table uniqdata OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1') c)LOAD DATA INPATH 'HDFS_URL/BabuStore/Data/uniqdata/6000_UniqData.csv' into table uniqdata OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1') d)LOAD DATA INPATH 'HDFS_URL/BabuStore/Data/uniqdata/7000_UniqData.csv' into table uniqdata OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1') e)LOAD DATA INPATH 'HDFS_URL/BabuStore/Data/uniqdata/3000_1_UniqData.csv' into table uniqdata OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1') 3: Run the Query: select CUST_ID from uniqdata_h where CUST_ID NOT LIKE 100079 4:Result in carbon data 0: jdbc:hive2://localhost:10000> select CUST_ID from UNIQDATA where CUST_ID NOT LIKE 100079; +----------+--+ | CUST_ID | +----------+--+ +----------+--+ No rows selected (59.188 seconds) Expected Result: Correct result should be displayed while using not like operator. -- This message was sent by Atlassian JIRA (v6.3.15#6346)