Uploaded image for project: 'Kudu'
  1. Kudu
  2. KUDU-1893

Queries incorrectly yielding null results

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.2.0
    • Fix Version/s: 1.3.0
    • Component/s: cfile
    • Labels:
      None
    • Target Version/s:

      Description

      The queries were on an added, nullable, int32 column with auto encoding and default compression. Range and equality predicates like `projectId == 32` or `projectId >= 32` yielded the result for projectId 32, as well as a large number of rows with null projectId.

      Response looks something like:

      STRING projectName=eq179_eq430_1.3_1207, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2016-12-07T17:25:18.696000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2016-12-07T17:25:18.696000Z, INT32 projectId=NULL
      STRING projectName=santosh_collection_12, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2016-12-11T01:52:04.360000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2016-12-11T01:52:04.360000Z, INT32 projectId=NULL
      STRING projectName=To Test Cancel Import, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=5, UNIXTIME_MICROS createDate=2016-12-13T00:30:26.010000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2016-12-13T00:30:26.010000Z, INT32 projectId=NULL
      STRING projectName=test_hmm_1, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2016-12-13T14:03:01.810000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2016-12-13T14:03:01.810000Z, INT32 projectId=NULL
      STRING projectName=Test_M_151216_1, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2016-12-15T14:39:26.684000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2016-12-15T14:39:26.684000Z, INT32 projectId=NULL
      STRING projectName=test_1_M, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2016-12-15T14:59:46.206000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2016-12-15T14:59:46.206000Z, INT32 projectId=NULL
      STRING projectName=mm-dev-2, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2016-12-15T21:01:26.942000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2016-12-15T21:01:26.942000Z, INT32 projectId=NULL
      STRING projectName=abc, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2016-12-16T04:23:46.032000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2016-12-16T04:23:46.032000Z, INT32 projectId=NULL
      STRING projectName=abcdefg, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2016-12-16T04:57:09.212000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2016-12-16T04:57:09.212000Z, INT32 projectId=NULL
      STRING projectName=testNew, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2016-12-16T10:44:12.130000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2016-12-16T10:44:12.130000Z, INT32 projectId=NULL
      STRING projectName=test_1_M_191216, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2016-12-19T16:36:07.774000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2016-12-19T16:36:07.774000Z, INT32 projectId=NULL
      STRING projectName=ePF-Test_Dec 22_504140723, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=57, UNIXTIME_MICROS createDate=2016-12-22T23:15:32.300000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2016-12-22T23:15:32.300000Z, INT32 projectId=NULL
      STRING projectName=mrj_22DecHours_, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=57, UNIXTIME_MICROS createDate=2016-12-22T23:55:01.963000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2016-12-22T23:55:01.963000Z, INT32 projectId=NULL
      STRING projectName=mrj_22Dec_1658Hours, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=57, UNIXTIME_MICROS createDate=2016-12-22T23:58:48.292000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2016-12-22T23:58:48.292000Z, INT32 projectId=NULL
      STRING projectName=mrj_22Dec_1715Hours, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=57, UNIXTIME_MICROS createDate=2016-12-23T00:16:24.674000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2016-12-23T00:16:24.674000Z, INT32 projectId=NULL
      STRING projectName=Test_4.2.1_EQ179_EQ430_1.3_2017, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-03T22:29:25.061000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-03T22:29:25.061000Z, INT32 projectId=NULL
      STRING projectName=cs import test 0104, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=5, UNIXTIME_MICROS createDate=2017-01-04T23:36:21.169000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-04T23:36:21.169000Z, INT32 projectId=NULL
      STRING projectName=import_040117, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-06T15:44:15.800000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-06T15:44:15.800000Z, INT32 projectId=NULL
      STRING projectName=USEQ 5M Port 0108 KK, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-09T06:35:28.350000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-09T06:35:28.350000Z, INT32 projectId=NULL
      STRING projectName=testch1234, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-09T22:28:55.422000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-09T22:28:55.422000Z, INT32 projectId=NULL
      STRING projectName=textch12334, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-09T22:33:59.110000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-09T22:33:59.110000Z, INT32 projectId=NULL
      STRING projectName=UKPL_2.5M Resi Port KK 0109, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-10T02:20:35.102000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-10T02:20:35.102000Z, INT32 projectId=NULL
      STRING projectName=test_MC1, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-10T21:04:59.035000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-10T21:04:59.035000Z, INT32 projectId=NULL
      STRING projectName=test_MD_18772, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-11T13:07:35.601000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-11T13:07:35.601000Z, INT32 projectId=NULL
      STRING projectName=test_110117, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-11T15:31:51.708000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-11T15:31:51.708000Z, INT32 projectId=NULL
      STRING projectName=import_test_110117, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-11T15:34:04.650000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-11T15:34:04.650000Z, INT32 projectId=NULL
      STRING projectName=test_MD_import_110117, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-11T15:38:09.152000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-11T15:38:09.152000Z, INT32 projectId=NULL
      STRING projectName=try_import_123, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-11T15:56:22.314000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-11T15:56:22.314000Z, INT32 projectId=NULL
      STRING projectName=try_import_110117, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-11T16:03:46.173000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-11T16:03:46.173000Z, INT32 projectId=NULL
      STRING projectName=chtest111, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=18, UNIXTIME_MICROS createDate=2017-01-13T23:29:52.611000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-13T23:29:52.611000Z, INT32 projectId=NULL
      STRING projectName=testBugCH, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-14T06:10:25.084000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-14T06:10:25.084000Z, INT32 projectId=NULL
      STRING projectName=val_md_160117, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-16T08:48:41.650000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-16T08:48:41.650000Z, INT32 projectId=NULL
      STRING projectName=test21111, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-17T13:44:25.812000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-17T13:44:25.812000Z, INT32 projectId=NULL
      STRING projectName=import_test_170117, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-17T13:44:51.950000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-17T13:44:51.950000Z, INT32 projectId=NULL
      STRING projectName=test_170117, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-17T13:56:08.024000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-17T13:56:08.024000Z, INT32 projectId=NULL
      STRING projectName=md_import_170117, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-17T14:41:44.704000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-17T14:41:44.704000Z, INT32 projectId=NULL
      STRING projectName=coll_MD_200117, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-20T11:32:29.728000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-20T11:32:29.728000Z, INT32 projectId=NULL
      STRING projectName=east123_import_200117, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-20T12:07:04.414000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-20T12:07:04.414000Z, INT32 projectId=NULL
      STRING projectName=import_ABC Commercial_200117, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-20T12:08:38.242000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-20T12:08:38.242000Z, INT32 projectId=NULL
      STRING projectName=ash_b4_training_test, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-24T17:49:36.733000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-24T17:49:36.733000Z, INT32 projectId=NULL
      STRING projectName=test_reinsinf, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=6, UNIXTIME_MICROS createDate=2017-01-25T00:25:55.244000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-01-25T00:25:55.244000Z, INT32 projectId=NULL
      STRING projectName=FiveM Comm2 KK 0203, STRING projectDescription=NULL, STRING comment=NULL, STRING createUserId=5, UNIXTIME_MICROS createDate=2017-02-03T22:19:55.389000Z, STRING updateUserId=NULL, UNIXTIME_MICROS updateDate=2017-02-03T22:19:55.389000Z, INT32 projectId=32
      

        Attachments

          Activity

            People

            • Assignee:
              andrew.wong Andrew Wong
              Reporter:
              anjuwong Andrew Wong
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: