Re: Unable to do count(*) on hbase view

On Tue, Sep 20, 2022 at 12:14 PM KhajaAsmath Mohammed < mdkhajaasm...@gmail.com> wrote: > Hi, > > I am new to phoenix. I am doing simple count(*) on view and it throws me > exception. Select * from table limit 5 works though. Any suggestions on > this please? > > *select count(*) from "prewards_ev

Subscribe

Fwd: Unable to do count(*) on hbase view

> > > Hi, > > I am new to phoenix. I am doing simple count(*) on view and it throws me > exception. Select * from table limit 5 works though. Any suggestions on > this please? > > *select count(*) from "prewards_event";* > > Error: Error -1 (0) : Error while executing SQL "select count(*) from

Timeout with Apache Phenonix

HI, I have set up below properties in hbase-site.xml but I stil get error with timeout. /usr/lib/phoenix/bin/sqlline-thin.py ip-10-120-1-129.qa.i-edo.net I have set this in hbase-site.xml of phoenix and hbase too. phoenix.query.timeoutMs 1800 phoenix.query.timeoutMs 1800

Re: Unable to do count(*) on hbase view

You need to increase phoenix.query.queueSize and/or phoenix.stats.guidepost.width. The number of guideposts in your table must not exceed phoenix.query.queueSize, otherwise full scans will fail. see https://phoenix.apache.org/tuning.html On Tue, Sep 20, 2022 at 8:02 PM KhajaAsmath Mohammed < md