[
https://issues.apache.org/jira/browse/PHOENIX-879?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13941485#comment-13941485
]
yang ming commented on PHOENIX-879:
-----------------------------------
[~jamestaylor],how to migrate from 2.2.0 to 3.0.0.The package structure has
been changed.
> Dynamic Columns:select and upsert error on a salt table
> -------------------------------------------------------
>
> Key: PHOENIX-879
> URL: https://issues.apache.org/jira/browse/PHOENIX-879
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 2.2.0-Release
> Reporter: yang ming
> Priority: Critical
>
> DDL:
> CREATE TABLE EventLog3 (
> eventId BIGINT NOT NULL,
> eventTime BIGINT NOT NULL,
> usedMemory bigint
> CONSTRAINT pk PRIMARY KEY (eventId, eventTime)
> )salt_buckets = 3;
> 1.select * from EventLog3(uu BIGINT) limit 10;
> error:
> java.lang.NullPointerException: at index 5
> at
> com.google.common.collect.ImmutableList.checkElementNotNull(ImmutableList.java:311)
> at
> com.google.common.collect.ImmutableList.construct(ImmutableList.java:302)
> at
> com.google.common.collect.ImmutableList.copyOf(ImmutableList.java:278)
> at com.salesforce.phoenix.schema.PTableImpl.init(PTableImpl.java:233)
> at
> com.salesforce.phoenix.schema.PTableImpl.<init>(PTableImpl.java:181)
> at
> com.salesforce.phoenix.schema.PTableImpl.makePTable(PTableImpl.java:151)
> at
> com.salesforce.phoenix.compile.FromCompiler$BaseColumnResolver.addDynamicColumns(FromCompiler.java:231)
> at
> com.salesforce.phoenix.compile.FromCompiler$SingleTableColumnResolver.<init>(FromCompiler.java:149)
> at
> com.salesforce.phoenix.compile.FromCompiler.getResolver(FromCompiler.java:106)
> at
> com.salesforce.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:106)
> at
> com.salesforce.phoenix.optimize.QueryOptimizer.optimize(QueryOptimizer.java:46)
> at
> com.salesforce.phoenix.optimize.QueryOptimizer.optimize(QueryOptimizer.java:41)
> at
> com.salesforce.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.optimizePlan(PhoenixStatement.java:223)
> at
> com.salesforce.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.executeQuery(PhoenixStatement.java:200)
> at
> com.salesforce.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.execute(PhoenixStatement.java:212)
> at
> com.salesforce.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1014)
> at sqlline.SqlLine$Commands.execute(SqlLine.java:3673)
> at sqlline.SqlLine$Commands.sql(SqlLine.java:3584)
> at sqlline.SqlLine.dispatch(SqlLine.java:821)
> at sqlline.SqlLine.begin(SqlLine.java:699)
> at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
> at sqlline.SqlLine.main(SqlLine.java:424)
> 2.upsert into EVENTLOG3 (eventId,eventTime,usedMemory,UU BIGINT) values
> (1,2,3,4);
> java.lang.NullPointerException: at index 5
> at
> com.google.common.collect.ImmutableList.checkElementNotNull(ImmutableList.java:311)
> at
> com.google.common.collect.ImmutableList.construct(ImmutableList.java:302)
> at
> com.google.common.collect.ImmutableList.copyOf(ImmutableList.java:278)
> at com.salesforce.phoenix.schema.PTableImpl.init(PTableImpl.java:233)
> at
> com.salesforce.phoenix.schema.PTableImpl.<init>(PTableImpl.java:181)
> at
> com.salesforce.phoenix.schema.PTableImpl.makePTable(PTableImpl.java:151)
> at
> com.salesforce.phoenix.compile.FromCompiler$BaseColumnResolver.addDynamicColumns(FromCompiler.java:231)
> at
> com.salesforce.phoenix.compile.FromCompiler$SingleTableColumnResolver.<init>(FromCompiler.java:149)
> at
> com.salesforce.phoenix.compile.FromCompiler.getResolver(FromCompiler.java:117)
> at
> com.salesforce.phoenix.compile.FromCompiler.getResolver(FromCompiler.java:123)
> at
> com.salesforce.phoenix.compile.UpsertCompiler.compile(UpsertCompiler.java:208)
> at
> com.salesforce.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:290)
> at
> com.salesforce.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.optimizePlan(PhoenixStatement.java:295)
> at
> com.salesforce.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.executeUpdate(PhoenixStatement.java:279)
> at
> com.salesforce.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.execute(PhoenixStatement.java:272)
> at
> com.salesforce.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1014)
> at sqlline.SqlLine$Commands.execute(SqlLine.java:3673)
> at sqlline.SqlLine$Commands.sql(SqlLine.java:3584)
> at sqlline.SqlLine.dispatch(SqlLine.java:821)
> at sqlline.SqlLine.begin(SqlLine.java:699)
> at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
> at sqlline.SqlLine.main(SqlLine.java:424)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
