[ https://issues.apache.org/jira/browse/KUDU-1893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15893046#comment-15893046 ]
Andrew Wong commented on KUDU-1893: ----------------------------------- Fixed in 3907340a28bad494cc28a0c93431372a811159d0. > Queries incorrectly yielding null results > ----------------------------------------- > > Key: KUDU-1893 > URL: https://issues.apache.org/jira/browse/KUDU-1893 > Project: Kudu > Issue Type: Bug > Components: cfile > Affects Versions: 1.2.0 > Reporter: Andrew Wong > Assignee: Andrew Wong > Priority: Blocker > > 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: > {code} > 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 > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)