carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vinod Rohilla (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CARBONDATA-774) Not like operators does not work properly in carbondata
Date Wed, 15 Mar 2017 12:12:41 GMT
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)

Mime
View raw message