Hi Sean, What version of Phoenix are you using? Would it be possible to post your CREATE TABLE statement and also (if you have it), a series of UPSERT statements that leads to repro-ing this issue? Thanks, James
On Mon, Mar 17, 2014 at 1:18 PM, Sean Huo <[email protected]> wrote: > Why do I get a NPE with this query on sqlline > > select trunc(date,'DAY',7) as day ,device, count(distinct uid) from > bi.events where date >= to_date('2014-02-05','yyyy-MM-dd') and date < > to_date('2014-03-05','yyyy-MM-dd') and uid is not null group by > trunc(date,'DAY',7), device; > > > at > org.apache.phoenix.schema.RowKeyValueAccessor.<init>(RowKeyValueAccessor.java:70) > > at > org.apache.phoenix.compile.ExpressionCompiler.wrapGroupByExpression(ExpressionCompiler.java:435) > > at > org.apache.phoenix.compile.ExpressionCompiler.visit(ExpressionCompiler.java:521) > > at > org.apache.phoenix.compile.ExpressionCompiler.visit(ExpressionCompiler.java:109) > > at org.apache.phoenix.parse.ColumnParseNode.accept(ColumnParseNode.java:52) > > at > org.apache.phoenix.compile.ProjectionCompiler.compile(ProjectionCompiler.java:223) > > at > org.apache.phoenix.compile.QueryCompiler.compileSingleQuery(QueryCompiler.java:273) > > at org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:126) > > at org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:113) > > at > org.apache.phoenix.optimize.QueryOptimizer.optimize(QueryOptimizer.java:47) > > at > org.apache.phoenix.optimize.QueryOptimizer.optimize(QueryOptimizer.java:42) > > at > org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.optimizePlan(PhoenixStatement.java:214) > > at > org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.executeQuery(PhoenixStatement.java:192) > > at > org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.execute(PhoenixStatement.java:203) > > at > org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1029) > > > Thanks > > Sean >
