Skip to main content
IONR
IONR
Silver ⭐️
Jul 17, 2026 6:57 AM UTC
Solved

Cloudera Data Visualization — Passing Parameters to a Dataset Query

 

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.

vafs
vafsAnswer
Gold ⭐️⭐️⭐️
Jul 22, 2026 9:41 PM UTC

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. 

View in thread

3 replies

vafs
Gold ⭐️⭐️⭐️
vafs
Gold ⭐️⭐️⭐️
Jul 17, 2026 5:59 PM UTC

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

Translate
IONR
IONRAuthor
Silver ⭐️
Jul 22, 2026 12:00 PM UTC

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

Translate
vafs
Gold ⭐️⭐️⭐️
vafsAnswer
Gold ⭐️⭐️⭐️
Jul 22, 2026 9:41 PM UTC

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. 

Translate
    Terms & ConditionsAccessibility statement