Is it possible to save and use PPL join results in visualization

OpenSearch Dashboards
1

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser): 3.2

Describe the issue: I have two indexes which i am trying to join and use the result for visualization in dashboard. But i am encountering the following issues:

  • The PPL join command is not running in Query editor

- The PPL is not showing up as Source in while creating Visualizations

Relevant Logs or Screenshots:

image
image1170×652 25 KB

2

@Am_user in order to run the query in the Query editor you will need to enable the calcite plugin, further details are available here

The command is:

PUT /_plugins/_query/settings
{
  "transient": { "plugins.calcite.enabled": true }
}

If this still doesn’t work, can you provide the logs generated when this is executed?

3

This worked. Thanks!

1 Like