Block Cache

Hi, Is there an easy way to completely turn off block cache for a specific table at table creation time itself? Something like, CREATE TABLE X ( . ) BLOCK_CACHE=FALSE; I could likely hint the queries during read time, but setting I'd like to turn it off completely. Thanks,Sumit

Re: Block Cache

Sorry, do not bother. I figured out - can be done by specifying  BLOCKCACHE=false at create table time. From: Sumit Nigam To: Users Mail List Phoenix Sent: Thursday, November 5, 2015 1:58 PM Subject: Block Cache Hi, Is there an easy

Re: Block Cache

Now, I have a question. Are secondary indexes maintained in block cache?  When I describe one of my indexes, I see - IN_MEMORY => 'false', BLOCKCACHE => 'true' Does this mean that the index does not reside in memory? Should I explicitly set IN_MEMORY=true when I create index? Thanks,Sumit

Error "could not find hash cache for joinId" when doing Inner Join with any table or view with Multi_Tenant=true

Hi, I am seeing the following error when doing an INNER JOIN of a view with MULTI_TENANT=true with any other table or view: java.lang.RuntimeException: org.apache.phoenix.exception.PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException:

Re: Connection pooling in Phoenix ?

Hi Dmitry, James has answered this couple of times in earlier threads. Found this useful. Hope it helps! https://groups.google.com/forum/#!topic/phoenix-hbase-user/lL-SVFeFpNg https://groups.google.com/forum/#!topic/phoenix-hbase-user/U3hCUhRTZV8 Regards Ravi On Thu, Nov 5, 2015 at 2:21 PM,

RE: Error "could not find hash cache for joinId" when doing Inner Join with any table or view with Multi_Tenant=true

Hi Maryann, I have created this defect report in JIRA: https://issues.apache.org/jira/browse/PHOENIX-2381 Thanks, Don Brinn From: Maryann Xue [mailto:maryann@gmail.com] Sent: Thursday, November 5, 2015 5:13 PM To: user@phoenix.apache.org Subject: Re: Error "could not find hash cache for

Connection pooling in Phoenix ?

Hi, Could someone provide an overview of connection pooling vis a vis Phoenix? 1. Does Phoenix do connection pooling under the covers? We currently just create connections and then close them once we're done with a given request which doesn't seem to drastically curtail performance. However,

Re: Error "could not find hash cache for joinId" when doing Inner Join with any table or view with Multi_Tenant=true

Thanks a lot, Don! I have assigned the issue to myself and will look into it shortly. On Thu, Nov 5, 2015 at 7:10 PM, Don Brinn wrote: > Hi Maryann, > > > > I have created this defect report in JIRA: > https://issues.apache.org/jira/browse/PHOENIX-2381 > > > > Thanks, > > > >