question Cloudera Data Visualization — Passing Parameters to a Dataset Query in Support Questions

Cloudera Data Visualization — Passing Parameters to a Dataset Query

IONR — Fri, 17 Jul 2026 06:57:47 GMT

Hi all,

I am working with Cloudera Data Visualization 7.1.6 and creating a dashboard that includes a KPI visual.

The visual uses a dataset based on a Hive query. Is there any way to pass dashboard filter values or parameters directly to the dataset query?

Based on the official documentation and the information I found online, it appears that Cloudera Data Visualization applies filters only at the visualization or UI level and does not support passing parameters to the underlying dataset query.

Could someone confirm whether this is an architectural limitation, or whether there is an alternative solution or workaround?

Thanks in advance for any suggestions or help.

Re: Cloudera Data Visualization — Passing Parameters to a Dataset Query

vafs — Fri, 17 Jul 2026 17:59:06 GMT

Hello @IONR,

Thanks for being part of our community.

With filters are you referring to parameters such as "WHERE" on a SQL query?
If so, that should be possible as described here:
http://docs-archive.cloudera.com/data-visualization/7/work-with-data/topics/viz-edit-dataset-query-restrict-rows.html

If not, can you elaborate more how are you doing the dataset?

Also, wanted to mention that Data Vizualization 7.1.6 is out of support since August 2024. Maybe a newer version has what you need, you can take a look on Data Vizualization 8, for example.
https://www.cloudera.com/services-and-support/support-lifecycle-policy.html

Re: Cloudera Data Visualization — Passing Parameters to a Dataset Query

IONR — Wed, 22 Jul 2026 12:12:06 GMT

Hi @vafs , thanks for your response.

I’ll try to explain my use case more clearly.

I have a line chart for N entities, and for each entity I have one KPI value per day, for example over a one-year period. As a result, the dataset size is approximately:

number of entities × number of days

I was considering reducing the dataset size by passing filters directly to the Hive query. However, these filters would need to be dynamic and based on the values selected by the user in the dashboard.

In general, is it possible in CDV to pass user-selected filters or parameters dynamically to the dataset query, or is this an architectural limitation of the platform and therefore not supported by design?

Thanks in advance for any information.

ps. About DS, the flow is: UI Visual → Dataset (based on a Hive query) → Hive

Re: Cloudera Data Visualization — Passing Parameters to a Dataset Query

vafs — Wed, 22 Jul 2026 21:41:21 GMT

Hello @IONR,

Thanks for the detailed information.
As far as I know that dynamic querying is not possible.

Data Visualization procures to provide high response on filtering but on Datasets already created. Not by creating Datasets with custom filtering each.