phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: NullPointerException
Date Mon, 17 Mar 2014 20:32:10 GMT
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 <sean@crunchyroll.com> 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
>

Mime
View raw message