Thanks a lot Xiaojian Zhou for your clear explanation and detailed reply.
This has helped a lot to proceed with my experiments.
Ankit.
On Fri, Nov 27, 2020, 5:48 AM Xiaojian Zhou wrote:
> Ankit:
>
> I wrote some lucene sample code using your data and query.
>
> I also provided gfsh commands to
Ankit:
I wrote some lucene sample code using your data and query.
I also provided gfsh commands to create nested query.
Note: I purposely provided 2 data to show the difference of query.
package examples;
import org.apache.geode.cache.Region;
import
Hi Anil, Thanks a lot for your guidance. This has really helped me to
proceed.
My intended queries are working and returning projected data (as a struct).
Just wondering is there any api that does a struct --> JSON string
conversation..
-Ankit.
On Wed, Nov 25, 2020, 12:21 AM Anilkumar Gingade
Ankit,
Here is how to query col2.
"SELECT d.col2 FROM /JsonRegion v, v.data d, d.col2 c where c.k21 = '22'";
You can find example on how to query nested collections:
https://geode.apache.org/docs/guide/18/getting_started/querying_quick_reference.html
When you want to select a nested
Hi Anil,
Thanks a lot for your reply. This really helps to proceed. The query shared
by you worked but I need a slight variation of it, i.e where clause
contains col2 (data.col2.k21 = '22') which is array unlike col1
(object).
FYI: value is stored in cache.
PDX[28847624, __GEMFIRE_JSON]{
Ankit,
Here is how you can query your JSON object.
String queryStr = "SELECT d.col1 FROM /JsonRegion v, v.data d where d.col1.k11
= 'aaa'";
As replied earlier; the data is stored as PdxInstance type in the cache. In the
PdxInstance, the data is stored as top level or nested collection of
Hello geode-dev,
I am *evaluating usage of Geode (1.12) with storing JSON documents and
querying the same*. I am able to store the json records successfully in
geode but seeking guidance on how to query them.
More details on code and sample json is,
*Sample client-code*
import
Hello geode-dev,
I am *evaluating usage of Geode (1.12) with storing JSON documents and
querying the same*. I am able to store the json records successfully in
geode but seeking guidance on how to query them.
More details on code and sample json is,
*Sample client-code*
import
Ankit:
Anil can provide you some sample code of OQL query on JSON.
I will find some lucene sample code on JSON for you.
Regards
Xiaojian
On 11/23/20, 9:27 AM, "ankit Soni" wrote:
Hi
I am looking for any means of querying (OQL/Lucene/API etc..?) this stored
data. Looking for
Hi
I am looking for any means of querying (OQL/Lucene/API etc..?) this stored
data. Looking for achieving this functionality first and second, in a
performant way.
I shared the OQL like syntax, to share my use-case easily and based on some
reference found on doc. I am ok if a Lucene query or some
Anil:
The syntax is OQL. But I understand they want to query JSON object base on the
criteria.
On 11/23/20, 9:08 AM, "Anilkumar Gingade" wrote:
Gester, Looking at the sample query, I Believe Ankit is asking about OQL
query not Lucene...
-Anil.
On 11/23/20, 9:02 AM, "Xiaojian
Gester, Looking at the sample query, I Believe Ankit is asking about OQL query
not Lucene...
-Anil.
On 11/23/20, 9:02 AM, "Xiaojian Zhou" wrote:
Ankit:
Geode provided lucene query on json field. Your query can be supported.
Ankit:
Geode provided lucene query on json field. Your query can be supported.
https://gemfire.docs.pivotal.io/910/geode/tools_modules/lucene_integration.html
However in above document, it did not provided a query example on JSON object.
I can give you some sample code to query on JSON.
Sunday, November 22, 2020 8:52 PM
To: dev@geode.apache.org
Subject: Re: Geode - store and query JSON documents
Hello geode-devs, please provide a guidance on this.
Ankit.
On Sat, 21 Nov 2020 at 10:23, ankit Soni wrote:
> Hello team,
>
> I am *evaluating usage of Geode (1.12) with storing
Hello geode-devs, please provide a guidance on this.
Ankit.
On Sat, 21 Nov 2020 at 10:23, ankit Soni wrote:
> Hello team,
>
> I am *evaluating usage of Geode (1.12) with storing JSON documents and
> querying the same*. I am able to store the json records successfully in
> geode but seeking
Hello team,
I am *evaluating usage of Geode (1.12) with storing JSON documents and
querying the same*. I am able to store the json records successfully in
geode but seeking guidance on how to query them.
More details on code and sample json is,
*Sample client-code*
import
16 matches
Mail list logo
