The JDBC Lookup documentation explains how to configure the cache and how the eviction works, but there is no discussion about how the cache actually works. Is the query being evaluated and then hashed, with the hash value being used as a key? or is something else happening?
Userlevel 2
- StreamSets Employee
- 37 replies
-
2 August 2022
Cache if “resolved query”-based. Given the lookup SQL Query, and once resolved all potential existing EL expressions in it, the cache will store an entry with key this resolved query, and with value the result of this query.
Please check documentation for other generic details: https://docs.streamsets.com/portal/platform-datacollector/latest/datacollector/UserGuide/Processors/JDBCLookup.html#concept_vsl_dvt_d2b.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.