joinService with sublayer aggregation

[AndrewGriffinGIT]

Has anyone been able to get this to work?

[dhatcher]

Can you provide a little more background on how you are trying to get it to work and what you are trying to accomplish?

[AndrewGriffinGIT]

"joinService": { "index": "myindex", "allowMultiPoint": false, "returnFields": [ "UNIQUEKEY", "USERID" ], "dateFields":[], "subLayers": [ {"name": "geohex_aggregation2", "options": { "hexConfig": [ { "resolution": 6, "offset": 800 }, { "resolution": 4, "offset": 20003 }, { "resolution": 2, "offset": 640000 }

      ]
}

}]

From: Danny Hatcher @.> Sent: Thursday, May 11, 2023 1:36 PM To: koopjs/koop-provider-elasticsearch @.> Cc: Griffin, Andrew @.>; Author @.> Subject: [EXT] Re: [koopjs/koop-provider-elasticsearch] joinService with sublayer aggregation (Issue #81)

Think Before You Click. This is an external email.

---

Can you provide a little more background on how you are trying to get it to work and what you are trying to accomplish?

— Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https:/github.com/koopjs/koop-provider-elasticsearch/issues/81*issuecomment-1544495752__;Iw!!OKBdgDQ8!5z44PeIZW47-fWKOt5EGviThH-63uSSf7Fy3kycY-3--dHWgoRYgW8dhcqGwKQ45uilMQzipxL_3xkYePdNvb5QE-AjA$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/AZAS6OY2XC2WHNIB5CKZK7DXFUWPHANCNFSM6AAAAAAX6QKJLY__;!!OKBdgDQ8!5z44PeIZW47-fWKOt5EGviThH-63uSSf7Fy3kycY-3--dHWgoRYgW8dhcqGwKQ45uilMQzipxL_3xkYePdNvb5ZB1KvX$. You are receiving this because you authored the thread.Message ID: @.**@.>>

---

This email communication is intended as a private communication for the sole use of the primary addressee and those individuals listed for copies in the original message. The information contained in this email is private and confidential and if you are not an intended recipient you are hereby notified that copying, forwarding or other dissemination or distribution of this communication by any means is prohibited. If you are not specifically authorized to receive this email and if you believe that you received it in error please notify the original sender immediately. We honor similar requests relating to the privacy of email communications

[jmp601]

I'll chime in to this thread as well. Elastic has been working on ESQL and are actually rebranding it a bit (I believe it is keeping the same name of ESQL?) Maybe someone from Elastic can chime in. Here is what they have in this space so far: https://www.elastic.co/blog/introduction-to-esql-new-query-language-flexible-iterative-analytics. But.... I believe the near future, perhaps later this calendar year, we will start seeing much of what is being described as this new and improved version, Here is a video: https://www.youtube.com/watch?v=RDhvugeLRj4

I believe there are tremendous opportunities here with this koop provider in this space.

[AndrewGriffinGIT]

Join service in koop works great. As i am joining an index with attributes to another index with geometry. Was just wondering if I could do hex aggregation on the join as well.

[jmp601]

Just curious, but how many records are you trying to render with the join?

[AndrewGriffinGIT]

few hundred, but will only grow with time