#openobserve

Accessing Variable in openobserve SQL Query

TLDR Shashank was having trouble accessing a variable in a custom SQL query. Hengfei offered a solution, which was shown to work with Shashank's acknowledgement.

1mo

Join the chat

Oct 20, 2023 (1 month ago)

Photo of md5-a830a209ddc7244eb2f35531dcf20752

Shashank

12:18 PM

Hi Team, In my openobserve instance under dashboard settings I have created a variable name: test. I want to access this in my customSQL query. Using $test is not working for me. Can someone pls suggest the workaround !!

Photo of md5-c30bb074b7d997d2cd6e689678b65dc1

Hengfei

12:22 PM

SQL or PromQL?

Shashank

12:23 PM

SQL

Hengfei

12:27 PM

SELECT histogram(_timestamp) as "x_axis_1", count(_timestamp) as "y_axis_1"  FROM "production-eks" where kubernetes_namespace_name='$namespace'  GROUP BY x_axis_1 ORDER BY x_axis_1

12:28

Hengfei

12:28 PM

just $test

12:28

Hengfei

12:28 PM

you need to use Custom SQL

Shashank

12:29 PM

Thanks it worked I used '$test' in my case.

OpenObserve

OpenObserve is an open-source, petabyte-scale observability platform for the cloud native realm, offering a 10x cost reduction and 140x less storage use compared to competitors like Elasticsearch or Splunk. Built in Rust for exceptional performance, it offers comprehensive features like logs, metrics, traces, dashboards, and more | Knowledge Base powered by Struct.AI

Indexed 404 threads (74% resolved)

Join Our Community

Similar Threads

Understanding QueryVariables in OpenObserve Dashboard v0.5.1

Gaby questioned the functionality of QueryVariables in the OpenObserve dashboard. Kirtan explained the use and requested feedback to improve. Gaby created an issue for enhancements.

4mo

SQL Query Issues in OpenObserve

Shashank attempted a SQL query in OpenObserve, but faced errors with certain functions. Hengfei confirmed these functions are not currently supported.

2mo

Troubleshooting Openobserve Setup with Azure Blob on K8S

David had difficulties setting up Openobserve with Azure Blob in Kubernetes. Prabhat provided guidance and setup values, informing David about possible data transmission delays, which resolved the issue.