Re: Phoenix Slow Problem

Thanks for your answer but why it gives 1 way parallel and can not be more? On Sunday, 30 October 2016, Mich Talebzadeh wrote: > If you create a secondary index in Phoenix on the table on single or > selected columns, that index (which will be added to Hbase) will be

Re: Hash join out of memory error

hbase-site.xml is in /home/ubuntu/phoenix/bin directory I am using a java program to run it and I have tried three ways to specify classpath: 1. classpath environment variable in bashrc export CLASSPATH=$CLASSPATH:/home/ubuntu/phoenix/bin:/home/ ubuntu/phoenix/phoenix-4.8.1-HBase-1.2-client.jar

Re: Hash join out of memory error

Is the directory containing hbase-site.xml where you have made the modification included on your overriden CLASSPATH? How are you running this query -- is it on the classpath for that program? ashish tapdiya wrote: Query: SELECT /*+ NO_STAR_JOIN*/ IP, RANK, TOTAL FROM (SELECT SOURCEIPADDR as