Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 365C8200C73 for ; Wed, 10 May 2017 14:21:11 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 31CD0160BB4; Wed, 10 May 2017 12:21:11 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id A466B160BA8 for ; Wed, 10 May 2017 14:21:09 +0200 (CEST) Received: (qmail 33964 invoked by uid 500); 10 May 2017 12:21:08 -0000 Mailing-List: contact issues-help@carbondata.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@carbondata.apache.org Delivered-To: mailing list issues@carbondata.apache.org Received: (qmail 33951 invoked by uid 99); 10 May 2017 12:21:08 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 May 2017 12:21:08 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 26E10C0D23 for ; Wed, 10 May 2017 12:21:08 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -100.002 X-Spam-Level: X-Spam-Status: No, score=-100.002 tagged_above=-999 required=6.31 tests=[RP_MATCHES_RCVD=-0.001, SPF_PASS=-0.001, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id EjS_7USwqzFO for ; Wed, 10 May 2017 12:21:06 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id 918495F36C for ; Wed, 10 May 2017 12:21:05 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id B8254E0D2B for ; Wed, 10 May 2017 12:21:04 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 2028521E0D for ; Wed, 10 May 2017 12:21:04 +0000 (UTC) Date: Wed, 10 May 2017 12:21:04 +0000 (UTC) From: "ravikiran (JIRA)" To: issues@carbondata.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (CARBONDATA-774) Not like operator does not work properly in carbondata MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Wed, 10 May 2017 12:21:11 -0000 [ https://issues.apache.org/jira/browse/CARBONDATA-774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16004591#comment-16004591 ] ravikiran commented on CARBONDATA-774: -------------------------------------- i verified in the current master. This scenario is working. Please resolve this issue. > 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 > Assignee: Rahul Kumar > 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)