Can you provide the schema of the table and the queries you are running? On Tue, Jan 15, 2019 at 12:35 PM Azharuddin Shaikh <azharuddins...@gmail.com> wrote:
> Thanks Pedro for your response. > > Actually we have an status column which consists of various status and we > are executing queries which select queries which are fetching data from > Hbase tables basis on status clause in the query and same is displayed on > the application dashboard. > > An average daily ingestion is of 10k rows to the existing table which is > currently at 5M+. > > We had tried secondary index to avoid full scan on table but when queries > are executed parallelly then timeout occurs after 30ms. > > It is working fine if we have only 1instance of an application running but > if there are multiple application instances then we are experiencing > timeouts. > > > On Tue, 15 Jan, 2019, 9:47 PM Pedro Boado, <pbo...@apache.org> wrote: > >> What type of queries are being thrown to the cluster? What's the average >> row size? 5M rows seems a tiny table size. 30ms is OK for scans over a few >> thousand records, but maybe not for full table scans. >> >