As seen on the community page last year this was the limitation as mentioned by @nik9000
"This is a side effect of the internal implementation of wildards as NFAs that are determinized to DFAs. The determinization process can take a up a crazy amount of memory so we limit the size of the determinized DFAs so we don't fill up memory.
I consider this a limitation of wildcard queries though I don't think it is one we're likely to remove any time soon."
So just wanted to get an update regarding this that is it still an limitation or is there some other way we can resolve this.
The ElasticSearch version that we are using is,
elasticsearch 6.8.7