You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Vinod Rohilla (JIRA)" <ji...@apache.org> on 2017/03/15 12:12:41 UTC
[jira] [Updated] (CARBONDATA-774) Not like operator does not work
properly in carbondata
[ https://issues.apache.org/jira/browse/CARBONDATA-774?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vinod Rohilla updated CARBONDATA-774:
-------------------------------------
Summary: Not like operator does not work properly in carbondata (was: Not like operators does not work properly in carbondata)
> Not like operator 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)