Hive queries to read ES data taking too long | Need suggestions to improve

Thanks for your reply Costin, I am now trying Spark SQL and the pushdown is working great!

I've created 2 more queries: