yang ming created PHOENIX-879:
---------------------------------
Summary: 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)
