Re: Apache calcite geode adapter

Hi Ashish, I am not sure if anyone is maintaining the calcite integration at the moment. My guess is that the integration was limited in scope and probably was only coded against replicated regions and probably only featured a subset of OQL capability. I am not sure how difficult it would be to

Re: Continuous Query problem

Hi Stephen, I am not sure how the cq operation is null. I tried to reproduce with a test (not exactly the same and haven't been able to so far). The queries themselves look like they should work. When populating the second region, is the client cq just doing a put back to the server or is it

How to publish Apache Geode Metrics to Wavefront

Hello Geode User List, Here is a blog post about publishing metrics to Wavefront. https://medium.com/@huynhja/publishing-apache-geode-metrics-to-wavefront-6e9a6cf5992b?sk=48d701092e02a711c7c924f14deec1fc This time, with a companion video: https://youtu.be/BDZh-FLkDTg The source can be found

Re: Blog about how to use geode-kafka-connector

ks for sharing this. > > On Tue, Mar 3, 2020 at 10:53 AM Nabarun Nag wrote: > >> Please do share !!! >> >> On Tue, Mar 3, 2020 at 10:50 AM Anthony Baker wrote: >> >>> Nice! Yes, please continue to share! >>> Anthony >>> >>> >&g

Blog about how to use geode-kafka-connector

Hello Geode Users! I wrote a blog/how-to about using the geode-kafka-connector (under development) to connect Apache Kafka and Apache Geode. https://medium.com/@huynhja/ingest-store-and-search-json-data-with-apache-kafka-and-apache-geode-fc6d0d2f9d9f I'll continue to share blogs and such if

Re: OQL Method Authorizer Blog

Great job Juan! Very informative and detailed read. On Fri, Feb 14, 2020 at 4:43 AM Nabarun Nag wrote: > Hi Geode Community, > > Please do visit the blog that Juan Ramos has put up on the OQL Method > Authorizer : > >

Re: RECOVERING A WAN INSTALLATION

Hi Evaristo, I spoke with another committer, Anil, and from what we understand, this process that is described would work. I am not sure if this it the recommended way to do a restart but we believe the steps outlined would get the intended outcome. To clear a Serial gateway, I believe stopping

Re: Spark geode best practices

Hi Ashish, Do you have custom code that connects spark to geode? I know there was a geode-spark connector at one point and that it was forked: https://github.com/Pivotal-Field-Engineering/geode-spark-connector (but it looks like it hasn't been updated in awhile). Just curious if there was

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

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

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

Re: Incosistent behaviour with functional indexes

The query tracing might have some bugs around it, I would guess this is the case if you are getting the expected/correct results from the query itself.. The second case seems like a good fit for the join optimizations we made a while back. I am not sure if the toString() is causing the

Re: Spark streaming output to geode

Not sure if this helps any, there used to be a Geode Spark Connector module that was removed with ticket GEODE-194. I believe someone has adopted/‘forked’ the code and maintaining it here: https://github.com/Pivotal-Field-Engineering/geode-spark-connector I think the connection with workers

Re: GEODE joining two big tables and getting aggregation - Suggestions

er fetching it in server function. Now getting the query > back fo 100K records in less than a second. > > Regards, > Mags > > On Mon, Apr 30, 2018 at 9:02 PM, Jason Huynh <jhu...@pivotal.io> wrote: > >> Just to be sure, are the two regions are colocated by productId?

Re: GEODE joining two big tables and getting aggregation - Suggestions

Just to be sure, are the two regions are colocated by productId? Looking at the provided query, what is the r alias? is it supposed to be r1 or r2? select sum(r.price.multiply(r.quantity)) from Region1 r1, Region2 r2 where r1.productId = r2.productId and r2.eventId = '123' The index on

Re: LinkedList with OQL not working

List:[Position [secId=OBJECTA]]) > > struct(ID:3,linkedList:[Position [secId=OBJECTA]]) > > > > Currently your output also confines with layout as (Map<ID, > LinkedList>) > > > > Thanks, > > Dharam > > > > *From:* Jason Huynh [mailtojhu...@piv

Re: LinkedList with OQL not working

he issue is Option1 does not give right outcome as filter condition > is not being applied. > > In real world, the actual object stored in geode itself is de normalized > document. In my example "Dependencies grouped by service name" > > Now if I again have to write c

Re: LinkedList with OQL not working

Correction, empd not empty, not sure how autocorrect came into play. On Wed, Feb 21, 2018 at 10:48 AM Jason Huynh <jhu...@pivotal.io> wrote: > I just tried similar queries and get the following output > Option1: > struct(ID:1,linkedList:[ObjectA, ObjectB]) > struct(ID:1,l

Re: LinkedList with OQL not working

In option1, are you receiving the linked list or is it not returning the values at all? Is the problem in option1 just a display issue? For option2, you might be able to do a distinct with an order by but that will force uniqueness in the tupling which you may not be looking for. On Wed, Feb

Re: Function Executor thread stacked

Hi Vahram, It would be interesting to know what object is not serializing/deserializing correctly. Is there any chance you are passing in function arguments that have had modifications that would impact serialization that the class files on the server do not know about? -Jason On Wed, Jan 10,

[DISCUSS] Proposal to Deprecate Hash Index

This is a proposal to deprecate existing Hash Index and deprecate the create hash index apis. Currently the Hash Index name causes confusion. It is not a traditional hash look up index, but more of memory savings index. The index does not store index keys in memory and must hash the keys every

Re: Querying 30K data from geode region

Cool, creating an index will definitely help here. create an index on userID On Wed, Jul 5, 2017 at 11:13 AM Amit Pandey wrote: > Yes Projection is a good idea. > > On Wed, Jul 5, 2017 at 11:42 PM, Amit Pandey > wrote: > >> Its pretty

Re: Querying 30K data from geode region

Adding to what Swapnil suggested, assuming you are only interested in a few of the fields and not the entire object, try adding a projection field to the query. This might improve performance as less data would need to be serialized to a client. I'd definitely try adding an index (some queries

Re: IndexMaintenanceException while remove old keys correctly from Compact Map Range Index

;> >> Thanks & Regards, >> >> Dharam >> >> >> >> *From:* Anilkumar Gingade [mailto:aging...@pivotal.io] >> *Sent:* Friday, May 05, 2017 2:35 AM >> *To:* user@geode.apache.org >> *Subject:* Re: IndexMaintenanceException while rem

Re: IndexMaintenanceException while remove old keys correctly from Compact Map Range Index

gt; happen at this point, but it will help to know exactly how these objects > are put and how they are updated and removed. Are they being modified at > any point? > > > > What version are you currently using? I'm going to guess 1.0? > > > > Is there an actual domain

Re: GeodeRedisAdapter improvments/feedback

an entry value: >- for small collections and read-only fat collections > ADVANTAGE: no need to create a separate region > > We would track the metrics and automatically convert based on a > combination of frequency of updates and size. > > We next define what a fat co

Re: GeodeRedisAdapter improvments/feedback

Hi Hitesh, Not sure about everyone else, but I had a hard time reading this, however I think I figured out what you were describing... the only part I still am unsure about is Feedback/vote: both behaviour is desirable. Do you mean you want feedback and voting on whether both behaviors are

Re: Issue with creating indexes in PdxIntance

t; Below syntax seems to be working even with ValueConstraint, but not sure > if that’s the right way to define! > > > > Could you help me to verify that? > > cache-ref=*"geodeCache"*/> > > Thanks & Regards, > > Dharam > > > > *From:* Ja

Re: Issue with message delivery in CQListener

Hi Dharam, Would you be able to provide more information? From the provided code, I am unable to determine why/how a duplicate create event is being sent. It doesn't look like that should be happening. Is there a reason why you are removing the value in the cqListener? I would assume that