Re: org.apache.phoenix.join.MaxServerCacheSizeExceededException

Hi Nanda, It seems the server is taking the default value for phoenix.query.maxServerCacheBytes https://phoenix.apache.org/tuning.html phoenix.query.maxServerCacheBytes - Maximum size (in bytes) of the raw results of a relation before being compressed and sent over to the region servers.

Multiple versions for single row key

Hello, HBase tables support multiple versions (default is 3) for single row key. I am trying to see how efficiently this can be achieved in Phoenix (don't want to create view on existing HBase table, just want to go with new Phoenix table). Is it better to create a separate secondary key

Re: org.apache.phoenix.join.MaxServerCacheSizeExceededException

I already override the property, but still it takes the default value, because of which none of my joins are working. TIA NANDA On Feb 10, 2016 8:52 PM, "rafa" wrote: > Hi Nanda, > > It seems the server is taking the default value for > phoenix.query.maxServerCacheBytes > >

OutOfOrderScannerNextException with phoenix 4.6-HBase-1.0-cdh5.5

I'm getting below exception in SELECT DISTINCT query using tenant-specific connection with phoenix 4.6-HBase-1.0-cdh5.5 . The exception disappears if I either switch to non-tenant connection, or remove DISTINCT from the query. Caused by:

Re: Spark Phoenix Plugin

Hi Pierre, I am getting this error now. Error: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException: SYSTEM.CATALOG,,1453397732623.8af7b44f3d7609eb301ad98641ff2611.:

Cannot support join operations in scans with limit

We're getting below exception in sqlline in phoenix 4.6 (community edition) with hbase1.0_cdh5.5, any ideas? 0: jdbc:phoenix:localhost> select * from table2 B join (select id from table1) A on A.id=B.otherid; java.lang.RuntimeException: org.apache.phoenix.exception.PhoenixIOException:

How to set the logging level of Apache Phoenix

My application runs on Tomcat server. The phoenix-client-4.4.0-HBase-1.1.jar is deployed to $CATALINA_HOME/lib folder for the application to access HBase tables via Phoenix. Tomcat's catalina.out shows a lot of Phoenix debugging message. How to change Phoenix's log level from DEBUG to INFO?

org.apache.phoenix.join.MaxServerCacheSizeExceededException

Hi , I am using HDP 2.3.0 with Phoneix 4.4 and i quiet often get the below exception, Caused by: java.sql.SQLException: Encountered exception in sub plan [0] execution. at org.apache.phoenix.execute.HashJoinPlan.iterator(HashJoinPlan.java:156)