We use denodo on top of Spark through JDBC.
We have some derived views built on top of some big tables. We would like to limit
the number of records a user can query based off of this view automatically rather than user
specifying LIMIT clause.
for e.g. assuming the allowable limit is 100,
" select * from Derived_view " should return only 100 records
" select country, count(1) from derived_view " should return counts for 100 different countries.
In other words, the LIMIT should be delegated as the last command after all the
aggrgations/transformations/joins are done on spark.
Is there a way to achieve this in denodo?