Multi-value variables with redis datasource about grafana-redis-datasource HOT 9 CLOSED

Hi @MathieuEtchepare
The trick with LUA script should work fine on a single shard deployment.

Another option is to utilize RedisGears module. RedisGears is a powerful framework for the execution of the functions. It supports Python and C API.

Here is an example of the script

gb = GB('CommandReader')
gb.flatmap(lambda x:  execute('SUNION',*x[1].split(",")))
gb.register(trigger='SUNION')

Which you can load to the database with RedisGears enabled like:
redis-cli -p 6379 RG.PYEXECUTE "$(cat sunion.py)"

To execute the trigger:

redis-cli -p 6379 RG.TRIGGER SUNION 'America,Europe'
1) "Spain"
2) "UK"
3) "France"
4) "USA"
5) "Mexico"

Use RG.TRIGGER SUNION ${<your-multi-select-variable>:csv} to display in Grafana.

Thank you
__
Nail

from grafana-redis-datasource.

Hello @MathieuEtchepare, thank you for opening the issue.

When you have multi-value variables, you should use repeat panels or rows for this variable. This feature was introduced for backend plugins in Grafana 7.1 and the latest version of Redis Data Source 1.2, please make sure that you are using the latest version.

Can you use first variable in the query or command directly instead of using 2nd variable?

You may take a look at the example dashboard, which has multi-value for Redis instances: https://github.com/RedisTimeSeries/grafana-redis-datasource/blob/master/dashboards/redis.json

Let me know if it's clear.

from grafana-redis-datasource.

Thanks for your answer.
I just noticed that the last part of my question was really unclear and I'm sorry for that.

As a matter of fact, I'm using a first variable to display geographical zones, let's say America, Europe and Asia.
For each I have a list in redis named after it with countries.
To sum up in redis I have:

• Regions [America, Europe, Asia]
• America [USA, Mexico, ...]
• Asia [China, Japan, ...]
• Europe [France, UK, Spain, ...]

If I select in the first variable America and Europe, is there a way to display the union of these two zones in a second variable?
(By the way, the dashboard, you linked is awesome, I'm going to use it a lot thank you)

from grafana-redis-datasource.

Hello @MathieuEtchepare,

There are multiple advanced variable format options for variables in Grafana which you can play with: https://grafana.com/docs/grafana/latest/variables/advanced-variable-format-options/

Do you keep countries as LIST data type or SET?

from grafana-redis-datasource.

I'm keeping them as a set, I looked at the SUNION command but it needs spaced separated values I think, which is not possible with Grafana if I read correctly the doc you just sent.

from grafana-redis-datasource.

@MathieuEtchepare, one of the possible solutions is to use EVAL command:

eval "return redis.call('sunion',${region:singlequote})" 0

I am checking with the team for other options.

from grafana-redis-datasource.

Hello @MathieuEtchepare, please let us know if LUA or RedisGears solution works for you.

from grafana-redis-datasource.

Hi,

Sorry for the late response, I was on other subjects these days...
I am going to use the LUA solution as I only need a simple line of code for now, but I will think about RedisGears if I need a more complex solution.

Thanks for your time, I really appreciate the effort you put into helping me.

Have a nice day! 😃

from grafana-redis-datasource.

@MathieuEtchepare, thank you for the update.

Please let us know if you need anything else.

from grafana-redis-datasource.