This enhancement request is already submitted for future considerations.
However, I tried another scenario with partial caching and it worked for me. I did the following steps:
Run the VQL, ‘Create view test as select 1,2,3 from dual()
Turn on partial cache.
Run the query, ‘SELECT * FROM test WHERE field1 = 1’. The data set is cached now.
Run the query, SELECT * FROM test WHERE field1 = 1 and field2 = 2’ and it comes from the cache.
Usually I prefer using the full cache mode over partial cache because of certain limitations of partial cache. So, you might want to reconsider using full cache mode for your scenario or using the ‘and’ operator as shown above.
For more information, you can go through some [best practices for caching](https://community.denodo.com/kb/view/document/Best%20Practices%20to%20Maximize%20Performance%20III%3A%20Caching?category=Best+Practices)
Hope this helps!