SUPPORT / SAMPLES & SAS NOTES
Problem Note 70171: Wildcard searches bypass the ElasticSearch/OpenSearch cache in SAS® Visual Investigator
 |  |  |  |  |
When using a wild card (*) search in SAS Visual Investigator, the facets for non-keyword searches are not able to leverage the ElasticSearch/OpenSearch cache.
The combination of the match_all and dfs_query_then_fetch calls make the wildcard queries ineligible for the shard request cache.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Investigator (on SAS Viya 3.x) | Linux for x64 | 10.8 | Viya | ||