Apache CarbonData Dev Mailing List archive

[jira] [Created] (CARBONDATA-774) Not like operators does not work properly in carbondata

Classic

List

Threaded

1 message

Akash R Nilugal (Jira)

[jira] [Created] (CARBONDATA-774) Not like operators does not work properly in carbondata

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)