I was lookup doc by N1ql from bucket ,there are 3 million+ doc in the bucket,i want to retrieve 50000 documents by java like this:
query (Select.select("*")
.from("PriceCheckDB_second")
.where("busiConditHash="+hashValue
+" and ExpireDate>\""+effectdate+"\""
+" and EffectDate<\""+expiredate+"\"")
I begin retrieve for a while ,then i found one node was down from the UI, i stop retrive but the issue node was keeping high resource used that 99% cpu usage and keep using all along.