Home Forums HBase Phoneix Agg function SQL failed.

This topic contains 0 replies, has 1 voice, and was last updated by  Deepak Gattala 5 months, 1 week ago.

  • Creator
    Topic
  • #54477

    Deepak Gattala
    Participant

    select a.host, a.domain, count(*),sum(a.DB),sum(a.CORE),SUM(a.ACTIVE_VISITOR),avg(a.DB),avg(a.CORE),avg(a.ACTIVE_VISITOR),min(a.DB),max(a.db),min(a.core),max(a.core),min(a.ACTIVE_VISITOR),max(a.ACTIVE_VISITOR) from PERFORMANCE_1000000 a inner join PERFORMANCE_1000000000 b on a.CORE=b.CORE where a.core>10 group by a.host, a.domain order by a.host, a.domain desc;

    java.sql.SQLException: Encountered exception in hash plan [0] execution.
    at org.apache.phoenix.execute.HashJoinPlan.iterator(HashJoinPlan.java:139)
    at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:202)
    at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:188)
    at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:146)
    at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:151)
    at org.apache.phoenix.jdbc.PhoenixConnection.executeStatements(PhoenixConnection.java:207)
    at org.apache.phoenix.util.PhoenixRuntime.executeStatements(PhoenixRuntime.java:257)
    at org.apache.phoenix.util.PhoenixRuntime.main(PhoenixRuntime.java:201)
    Caused by: org.apache.phoenix.exception.PhoenixIOException
    at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:97)
    at org.apache.phoenix.iterate.ParallelIterators.getIterators(ParallelIterators.java:289)
    at org.apache.phoenix.iterate.ConcatResultIterator.getIterators(ConcatResultIterator.java:44)
    at org.apache.phoenix.iterate.ConcatResultIterator.currentIterator(ConcatResultIterator.java:66)
    at org.apache.phoenix.iterate.ConcatResultIterator.next(ConcatResultIterator.java:86)
    at org.apache.phoenix.join.HashCacheClient.serialize(HashCacheClient.java:100)
    at org.apache.phoenix.join.HashCacheClient.addHashCache(HashCacheClient.java:77)
    at org.apache.phoenix.execute.HashJoinPlan$1.call(HashJoinPlan.java:112)
    at org.apache.phoenix.execute.HashJoinPlan$1.call(HashJoinPlan.java:107)
    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
    at java.util.concurrent.FutureTask.run(FutureTask.java:138)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
    at java.lang.Thread.run(Thread.java:662)
    Caused by: java.util.concurrent.TimeoutException
    at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:228)
    at java.util.concurrent.FutureTask.get(FutureTask.java:91)
    at org.apache.phoenix.iterate.ParallelIterators.getIterators(ParallelIterators.java:283)
    … 12 more

You must be logged in to reply to this topic.