Hi, i'm also relative new to Elastic Search but i can already tell you that
140 Shards on one node.
sounds like a bad idea. Every shard is Lucene engine. So if your query needs to go though all 140 on one node might be that this is the problem and in result less fast, than having one, two or 3 shards.
Ok 1 and 5 maybe makes no difference. But i was woundering bout 140...
I can't help you with the query, since i'm also just started with ES and have no experience
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.