Make sure our schema allows for SQL joins across indices

o19s / opensearch-ubi

OpenSearch plugin for User Behavior Insights

Apache License 2.0

6 stars 1 forks source link

Make sure our schema allows for SQL joins across indices #8

Closed jzonthemtn closed 8 months ago

jzonthemtn commented 9 months ago

Make sure our schema allows for SQL joins across indices.

jzonthemtn commented 8 months ago

We need to look at the initial list of desired reporting charts/graphs and ensure that our schemas can support the queries to power those visualizations.

epugh commented 8 months ago

What's teh best way to tackle this? We have both a miro board of potential reporting needs, plus some feedback from Stavros... Should we create a ticket for each one and try and get more explicit on what data is needed for each one?

jzonthemtn commented 8 months ago

We should mock up what each chart would look like and then try creating each one in OpenSearch Dashboards.

RasonJ commented 8 months ago

Reported the bug here: https://github.com/opensearch-project/sql/issues/2550