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
