We are running on phoenix 3.0.
Here is the approximate schema:
CREATE TABLE BI.EVENTS (
DATE TIMESTAMP NOT NULL,
EVENT_TYPE VARCHAR NOT NULL,
EVENT_NAME VARCHAR NOT NULL,
DEVICE VARCHAR NOT NULL,
AID VARCHAR NOT NULL,
USER.IP VARCHAR,
USER.REFERER VARCHAR,
USER.UID VARCHAR,
USER.AGENT VARCHAR,
USER.DETAIL VARCHAR,
EVENT.DETAIL VARCHAR
CONSTRAINT PK PRIMARY KEY (DATE, EVENT_TYPE, EVENT_NAME, DEVICE, AID)
) VERSIONS=2, SALT_BUCKETS = 36;
On Mon, Mar 17, 2014 at 1:34 PM, Sean Huo <[email protected]> wrote:
> The strang thing is that this query runs fine:
>
> select trunc(date,'DAY',7) as day, 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;
>
>
> On Mon, Mar 17, 2014 at 1:32 PM, James Taylor <[email protected]>wrote:
>
>> 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
>>>
>>
>>
>
