Is the indexed data possibly represented by Strings instead of doubles or floats? If so, you'd have to surround the value with single quotes.
If the indexed data is double, perhaps try adding a d to the value to match, for example: query --query='select * from /ksdata-benchmark where C002=40.5078d' If it's float, try adding an f query --query='select * from /ksdata-benchmark where C002=40.5078f' On Thu, Jan 24, 2019 at 4:44 AM Philippe CEROU <philippe.ce...@gfi.fr> wrote: > Hi, > > > > My new test report that a query with an indexed column filtering do not > respond well ☹ > > > > In same GFSH SHELL : > > > > - *We check indexes.* > > > > gfsh>list indexes > > Member Name | Member ID | Region Path > | Name | Type | Indexed Expression | From Clause | > Valid Index > > ----------- | ---------------------------------------- | ----------------- > | --------------------- | ----- | ------------------ | ----------------- | > ----------- > > nx101c-srv | 10.200.6.101(nx101c-srv:18983)<v2>:41001 | /ksdata-benchmark > | ksdata-benchmark-C001 | RANGE | C001 | /ksdata-benchmark | > true > > nx101c-srv | 10.200.6.101(nx101c-srv:18983)<v2>:41001 | /ksdata-benchmark > | ksdata-benchmark-C002 | RANGE | C002 | /ksdata-benchmark | > true > > nx101c-srv | 10.200.6.101(nx101c-srv:18983)<v2>:41001 | /ksdata-benchmark > | ksdata-benchmark-C003 | RANGE | C003 | /ksdata-benchmark | > true > > nx101c-srv | 10.200.6.101(nx101c-srv:18983)<v2>:41001 | /ksdata-benchmark > | ksdata-benchmark-C011 | RANGE | C011 | /ksdata-benchmark | > true > > nx102a-srv | 10.200.2.102(nx102a-srv:4043)<v6>:41001 | /ksdata-benchmark > | ksdata-benchmark-C001 | RANGE | C001 | /ksdata-benchmark | > true > > nx102a-srv | 10.200.2.102(nx102a-srv:4043)<v6>:41001 | /ksdata-benchmark > | ksdata-benchmark-C002 | RANGE | C002 | /ksdata-benchmark | > true > > nx102a-srv | 10.200.2.102(nx102a-srv:4043)<v6>:41001 | /ksdata-benchmark > | ksdata-benchmark-C003 | RANGE | C003 | /ksdata-benchmark | > true > > nx102a-srv | 10.200.2.102(nx102a-srv:4043)<v6>:41001 | /ksdata-benchmark > | ksdata-benchmark-C011 | RANGE | C011 | /ksdata-benchmark | > true > > nx103b-srv | 10.200.4.103(nx103b-srv:22141)<v8>:41001 | /ksdata-benchmark > | ksdata-benchmark-C001 | RANGE | C001 | /ksdata-benchmark | > true > > nx103b-srv | 10.200.4.103(nx103b-srv:22141)<v8>:41001 | /ksdata-benchmark > | ksdata-benchmark-C002 | RANGE | C002 | /ksdata-benchmark | > true > > nx103b-srv | 10.200.4.103(nx103b-srv:22141)<v8>:41001 | /ksdata-benchmark > | ksdata-benchmark-C003 | RANGE | C003 | /ksdata-benchmark | > true > > nx103b-srv | 10.200.4.103(nx103b-srv:22141)<v8>:41001 | /ksdata-benchmark > | ksdata-benchmark-C011 | RANGE | C011 | /ksdata-benchmark | > true > > nx104c-srv | 10.200.6.104(nx104c-srv:14996)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C001 | RANGE | C001 | /ksdata-benchmark | > true > > nx104c-srv | 10.200.6.104(nx104c-srv:14996)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C002 | RANGE | C002 | /ksdata-benchmark | > true > > nx104c-srv | 10.200.6.104(nx104c-srv:14996)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C003 | RANGE | C003 | /ksdata-benchmark | > true > > nx104c-srv | 10.200.6.104(nx104c-srv:14996)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C011 | RANGE | C011 | /ksdata-benchmark | > true > > nx105a-srv | 10.200.2.105(nx105a-srv:15236)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C001 | RANGE | C001 | /ksdata-benchmark | > true > > nx105a-srv | 10.200.2.105(nx105a-srv:15236)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C002 | RANGE | C002 | /ksdata-benchmark | > true > > nx105a-srv | 10.200.2.105(nx105a-srv:15236)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C003 | RANGE | C003 | /ksdata-benchmark | > true > > nx105a-srv | 10.200.2.105(nx105a-srv:15236)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C011 | RANGE | C011 | /ksdata-benchmark | > true > > nx106b-srv | 10.200.4.106(nx106b-srv:15146)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C001 | RANGE | C001 | /ksdata-benchmark | > true > > nx106b-srv | 10.200.4.106(nx106b-srv:15146)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C002 | RANGE | C002 | /ksdata-benchmark | > true > > nx106b-srv | 10.200.4.106(nx106b-srv:15146)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C003 | RANGE | C003 | /ksdata-benchmark | > true > > nx106b-srv | 10.200.4.106(nx106b-srv:15146)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C011 | RANGE | C011 | /ksdata-benchmark | > true > > nx107c-srv | 10.200.6.107(nx107c-srv:15145)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C001 | RANGE | C001 | /ksdata-benchmark | > true > > nx107c-srv | 10.200.6.107(nx107c-srv:15145)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C002 | RANGE | C002 | /ksdata-benchmark | > true > > nx107c-srv | 10.200.6.107(nx107c-srv:15145)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C003 | RANGE | C003 | /ksdata-benchmark | > true > > nx107c-srv | 10.200.6.107(nx107c-srv:15145)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C011 | RANGE | C011 | /ksdata-benchmark | > true > > nx108a-srv | 10.200.2.108(nx108a-srv:6702)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C001 | RANGE | C001 | /ksdata-benchmark | > true > > nx108a-srv | 10.200.2.108(nx108a-srv:6702)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C002 | RANGE | C002 | /ksdata-benchmark | > true > > nx108a-srv | 10.200.2.108(nx108a-srv:6702)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C003 | RANGE | C003 | /ksdata-benchmark | > true > > nx108a-srv | 10.200.2.108(nx108a-srv:6702)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C011 | RANGE | C011 | /ksdata-benchmark | > true > > nx109b-srv | 10.200.4.109(nx109b-srv:15153)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C001 | RANGE | C001 | /ksdata-benchmark | > true > > nx109b-srv | 10.200.4.109(nx109b-srv:15153)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C002 | RANGE | C002 | /ksdata-benchmark | > true > > nx109b-srv | 10.200.4.109(nx109b-srv:15153)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C003 | RANGE | C003 | /ksdata-benchmark | > true > > nx109b-srv | 10.200.4.109(nx109b-srv:15153)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C011 | RANGE | C011 | /ksdata-benchmark | > true > > nx110c-srv | 10.200.6.110(nx110c-srv:7833)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C001 | RANGE | C001 | /ksdata-benchmark | > true > > nx110c-srv | 10.200.6.110(nx110c-srv:7833)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C002 | RANGE | C002 | /ksdata-benchmark | > true > > nx110c-srv | 10.200.6.110(nx110c-srv:7833)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C003 | RANGE | C003 | /ksdata-benchmark | > true > > nx110c-srv | 10.200.6.110(nx110c-srv:7833)<v2>:41000 | /ksdata-benchmark > | ksdata-benchmark-C011 | RANGE | C011 | /ksdata-benchmark | > true > > > > - *We look for 10 rows in the region.* > > > > gfsh>query --query='select * from /ksdata-benchmark limit 10' > > Result : true > > Rows : 10 > > > > id | C001 | C002 | C003 | C004 | C005 | C006 | C007 | > C008 | C009 | C010 | C011 | C012 | C013 | C014 | C015 | C016 > | C017 | C018 | C019 > > --------- | ------ | -------- | ---------- | ---- | ----- | ---- | ---- | > ---- | ---- | ------ | ------------- | ---- | ---- | ------ | ---- | ------ > | ------- | ---- | ---------- > > 155649429 | AA140F | 41.93172 | -72.68692 | 225 | 0 | 2 | 6676 | > 200 | B762 | N749AX | 1539723781000 | CVG | BDL | GB3430 | 1 | 0.0 > | ABX3430 | null | 0 > > 57639670 | A3A9AF | 26.07674 | -80.14734 | 98 | 0 | 39 | 567 | > 5000 | B738 | N335PH | 1539813322000 | DFW | FLL | AA2198 | 1 | 0.0 > | AAL2198 | null | 0 > > 90168867 | A185E4 | 61.62376 | -42.72361 | 237 | 33975 | 427 | 0 | > 200 | B752 | N198AA | 1539691580000 | EDI | JFK | AA279 | 0 | 0.0 > | AAL279 | null | 1539706679 > > 161925675 | 896365 | 0.5398 | 38.80256 | 222 | 38000 | 439 | 1725 | > 200 | A320 | A6-ANN | 1539767936000 | SHJ | NBO | G9734 | 0 | 0.0 > | ABY734 | null | 1539769748 > > 41805771 | ACA3A3 | 38.42651 | -76.27241 | 36 | 34950 | 522 | 6023 | > 200 | A321 | N913US | 1539783243000 | CLT | LGA | AA1788 | 0 | -576.0 > | AAL1788 | null | 1539784956 > > 19563868 | ACAE2E | 22.01125 | -86.63313 | 12 | 22675 | 428 | 0 | > 200 | B738 | N916NN | 1539715160000 | CUN | JFK | AA1327 | 0 | 1728.0 > | AAL1327 | null | 1539726765 > > 37873484 | A9653D | 36.7088 | -86.96444 | 113 | 39000 | 527 | 1722 | > 8444 | A319 | N704US | 1539735271000 | STL | CLT | AA1706 | 0 | 0.0 > | AAL1706 | null | 1539737940 > > 51661631 | A6E131 | 39.89947 | -74.94922 | 286 | 2925 | 170 | 7313 | > 5000 | A321 | N542UW | 1539814575000 | BOS | PHL | AA2019 | 0 | 64.0 > | AAL2019 | null | 1539815105 > > 102895831 | A13C73 | 33.93931 | -118.41019 | 0 | 100 | 100 | 0 | > 8444 | A321 | N179UW | 1539649728000 | LAX | LAS | AA501 | 1 | 0.0 > | AAL501 | null | 0 > > 187880419 | 344216 | 48.5078 | 2.36587 | 199 | 22350 | 408 | 7620 | > 200 | B738 | EC-LPR | 1539803387000 | CDG | AGP | UX1038 | 0 | 1856.0 > | AEA1038 | null | 1539810800 > > > > - *We target the first and last previously returned rows.* > > > > gfsh>query --query='select * from /ksdata-benchmark where C002=41.93172' > > Result : true > > Limit : 100 > > Rows : 0 *à** No row !* > > > > gfsh>query --query='select * from /ksdata-benchmark where C002=40.5078' > > Result : true > > Limit : 100 > > Rows : 0 *à** No row !* > > > > GEODE do not return rows while this one exists ☹ > > > > Cordialement, > > > *— NOTE : n/a* > — > Gfi Informatique > *Philippe Cerou* > Architecte & Expert Système > GFI Production / Toulouse > philippe.cerou @gfi.fr > > — > > 1 Rond-point du Général Eisenhower, 31400 Toulouse > > Tél. : +33 (0)5.62.85.11.55 > Mob. : +33 (0)6.03.56.48.62 > *www.gfi.world* <http://www.gfi.world/> > > >
