Unable to run SQL query on multi fields using Elastic Search v. 7.3

You are trying to use KeywordField which is of type text.
The LIKE operator works only on fields of type keyword.
If you still need the KeywordField analyzed with the keyword-analyzer
you need to add an extra field keyword of `"type" : "keyword" and use that in your query:

SELECT * FROM \"t3-imp-2019\" where (productDescription.keyword like '%moringa%'

Of course this means that your keyword field will contain the whole String and won't be split up
to words by any analyzer.