phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (PHOENIX-879) Dynamic Columns:select and upsert error on a salt table
Date Fri, 02 May 2014 05:26:17 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-879?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

James Taylor resolved PHOENIX-879.
----------------------------------

    Resolution: Cannot Reproduce

> 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)

Mime
View raw message