Cloudera Data Visualization — Passing Parameters to a Dataset Query

[#1]

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.

[#2]

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-r...

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

[#3]

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

[#4 · Accepted solution]

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.