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/>
