You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@geode.apache.org by Philippe CEROU <ph...@gfi.fr> on 2019/01/24 12:44:08 UTC

Query return no rows while requested column has wanted value (BUG ?).

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


Re: Query return no rows while requested column has wanted value (BUG ?).

Posted by Jason Huynh <jh...@pivotal.io>.
Great, glad it worked out!

Perhaps the engine should know to do the auto cast if there is an index
present.  I can understand not casting if no index is present, since there
can be some objects with float, others with double etc.

On Thu, Jan 24, 2019 at 9:01 AM Philippe CEROU <ph...@gfi.fr>
wrote:

> Jason, you are a genius !
>
>
>
> DATA is float, adding a « f » at the end resolved the problem 😊
>
>
>
> gfsh>query --query='select * from /ksdata-benchmark where C002=41.93172f'
>
> Result : true
>
> Limit  : 100
>
> Rows   : 100
>
>
>
>    id     |  C001  |   C002   |    C003    | C004 | C005  | C006 | C007 |
> C008 | C009 |  C010  |     C011      | C012 | C013 |  C014  | C015 | C016
> |  C017   | C018 | C019
>
> --------- | ------ | -------- | ---------- | ---- | ----- | ---- | ---- |
> ---- | ---- | ------ | ------------- | ---- | ---- | ------ | ---- | ---- |
> ------- | ---- | ----------
>
> 155660928 | AA140F | 41.93172 | -72.68692  | 225  | 0     | 2    | 6676 |
> 200  | B762 | N749AX | 1539723781000 | CVG  | BDL  | GB3430 | 1    | 0.0  |
> ABX3430 | null | 0
>
> 155658761 | AA140F | 41.93172 | -72.68692  | 225  | 0     | 2    | 6676 |
> 200  | B762 | N749AX | 1539723781000 | CVG  | BDL  | GB3430 | 1    | 0.0  |
> ABX3430 | null | 0
>
> 155642715 | AA140F | 41.93172 | -72.68692  | 225  | 0     | 2    | 6676 |
> 200  | B762 | N749AX | 1539723781000 | CVG  | BDL  | GB3430 | 1    | 0.0  |
> ABX3430 | null | 0
>
> 155642502 | AA140F | 41.93172 | -72.68692  | 225  | 0     | 2    | 6676 |
> 200  | B762 | N749AX | 1539723781000 | CVG  | BDL  | GB3430 | 1    | 0.0  |
> ABX3430 | null | 0
>
> 155667118 | AA140F | 41.93172 | -72.68692  | 225  | 0     | 2    | 6676 |
> 200  | B762 | N749AX | 1539723781000 | CVG  | BDL  | GB3430 | 1    | 0.0  |
> ABX3430 | null | 0
>
> 142769318 | A1F4D4 | 41.93172 | -121.54831 | 150  | 33000 | 100  | 6611 |
> 8444 | A320 | N225NV | 1539665988000 | EUG  | LAS  | G4169  | 0    | 0.0  |
> AAY169  | null | 1539670423
>
> 155643845 | AA140F | 41.93172 | -72.68692  | 225  | 0     | 2    | 6676 |
> 200  | B762 | N749AX | 1539723781000 | CVG  | BDL  | GB3430 | 1    | 0.0  |
> ABX3430 | null | 0
>
> 155657763 | AA140F | 41.93172 | -72.68692  | 225  | 0     | 2    | 6676 |
> 200  | B762 | N749AX | 1539723781000 | CVG  | BDL  | GB3430 | 1    | 0.0  |
> ABX3430 | null | 0
>
> 155647901 | AA140F | 41.93172 | -72.68692  | 225  | 0     | 2    | 6676 |
> 200  | B762 | N749AX | 1539723781000 | CVG  | BDL  | GB3430 | 1    | 0.0  |
> ABX3430 | null | 0
>
> 155664283 | AA140F | 41.93172 | -72.68692  | 225  | 0     | 2    | 6676 |
> 200  | B762 | N749AX | 1539723781000 | CVG  | BDL  | GB3430 | 1    | 0.0  |
> ABX3430 | null | 0
>
> ...
>
>
>
> What is strange is that we ask for filtering on column C002, for me GEODE
> perfectly knows the type (The row has been inserted PDX-ized with a «
> writer.writeFloat » function) and he should do itself the
> « understanding »...
>
>
>
> But I’m a good player, I can accept that.
>
>
>
> 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/>
>
> —
>
> [image: Facebook] <https://www.facebook.com/gfiinformatique> [image:
> Twitter] <https://twitter.com/gfiinformatique> [image: Instagram]
> <https://www.instagram.com/gfiinformatique/> [image: LinkedIn]
> <https://www.linkedin.com/company/gfi-informatique> [image: YouTube]
> <https://www.youtube.com/user/GFIinformatique>
> —
> [image: cid:image006.jpg@01D2F97F.AA6ABB50] <http://www.gfi.world/>
>
>
>
>
>
> *De :* Jason Huynh [mailto:jhuynh@pivotal.io]
> *Envoyé :* jeudi 24 janvier 2019 17:56
> *À :* user@geode.apache.org
> *Objet :* Re: Query return no rows while requested column has wanted
> value (BUG ?).
>
>
>
>
>
> 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 <ph...@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/>
>
>
>
>

RE: Query return no rows while requested column has wanted value (BUG ?).

Posted by Philippe CEROU <ph...@gfi.fr>.
Jason, you are a genius !

DATA is float, adding a « f » at the end resolved the problem 😊

gfsh>query --query='select * from /ksdata-benchmark where C002=41.93172f'
Result : true
Limit  : 100
Rows   : 100

   id     |  C001  |   C002   |    C003    | C004 | C005  | C006 | C007 | C008 | C009 |  C010  |     C011      | C012 | C013 |  C014  | C015 | C016 |  C017   | C018 | C019
--------- | ------ | -------- | ---------- | ---- | ----- | ---- | ---- | ---- | ---- | ------ | ------------- | ---- | ---- | ------ | ---- | ---- | ------- | ---- | ----------
155660928 | AA140F | 41.93172 | -72.68692  | 225  | 0     | 2    | 6676 | 200  | B762 | N749AX | 1539723781000 | CVG  | BDL  | GB3430 | 1    | 0.0  | ABX3430 | null | 0
155658761 | AA140F | 41.93172 | -72.68692  | 225  | 0     | 2    | 6676 | 200  | B762 | N749AX | 1539723781000 | CVG  | BDL  | GB3430 | 1    | 0.0  | ABX3430 | null | 0
155642715 | AA140F | 41.93172 | -72.68692  | 225  | 0     | 2    | 6676 | 200  | B762 | N749AX | 1539723781000 | CVG  | BDL  | GB3430 | 1    | 0.0  | ABX3430 | null | 0
155642502 | AA140F | 41.93172 | -72.68692  | 225  | 0     | 2    | 6676 | 200  | B762 | N749AX | 1539723781000 | CVG  | BDL  | GB3430 | 1    | 0.0  | ABX3430 | null | 0
155667118 | AA140F | 41.93172 | -72.68692  | 225  | 0     | 2    | 6676 | 200  | B762 | N749AX | 1539723781000 | CVG  | BDL  | GB3430 | 1    | 0.0  | ABX3430 | null | 0
142769318 | A1F4D4 | 41.93172 | -121.54831 | 150  | 33000 | 100  | 6611 | 8444 | A320 | N225NV | 1539665988000 | EUG  | LAS  | G4169  | 0    | 0.0  | AAY169  | null | 1539670423
155643845 | AA140F | 41.93172 | -72.68692  | 225  | 0     | 2    | 6676 | 200  | B762 | N749AX | 1539723781000 | CVG  | BDL  | GB3430 | 1    | 0.0  | ABX3430 | null | 0
155657763 | AA140F | 41.93172 | -72.68692  | 225  | 0     | 2    | 6676 | 200  | B762 | N749AX | 1539723781000 | CVG  | BDL  | GB3430 | 1    | 0.0  | ABX3430 | null | 0
155647901 | AA140F | 41.93172 | -72.68692  | 225  | 0     | 2    | 6676 | 200  | B762 | N749AX | 1539723781000 | CVG  | BDL  | GB3430 | 1    | 0.0  | ABX3430 | null | 0
155664283 | AA140F | 41.93172 | -72.68692  | 225  | 0     | 2    | 6676 | 200  | B762 | N749AX | 1539723781000 | CVG  | BDL  | GB3430 | 1    | 0.0  | ABX3430 | null | 0
...

What is strange is that we ask for filtering on column C002, for me GEODE perfectly knows the type (The row has been inserted PDX-ized with a « writer.writeFloat » function) and he should do itself the « understanding »...

But I’m a good player, I can accept that.

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/>
—
[Facebook]<https://www.facebook.com/gfiinformatique> [Twitter] <https://twitter.com/gfiinformatique>  [Instagram] <https://www.instagram.com/gfiinformatique/>  [LinkedIn] <https://www.linkedin.com/company/gfi-informatique>  [YouTube] <https://www.youtube.com/user/GFIinformatique>
—
[cid:image006.jpg@01D2F97F.AA6ABB50]<http://www.gfi.world/>


De : Jason Huynh [mailto:jhuynh@pivotal.io]
Envoyé : jeudi 24 janvier 2019 17:56
À : user@geode.apache.org
Objet : Re: Query return no rows while requested column has wanted value (BUG ?).


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 <ph...@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<http://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/>


Re: Query return no rows while requested column has wanted value (BUG ?).

Posted by Jason Huynh <jh...@pivotal.io>.
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 <ph...@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/>
>
>
>