Return-Path: X-Original-To: apmail-phoenix-dev-archive@minotaur.apache.org Delivered-To: apmail-phoenix-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 2316711C09 for ; Fri, 2 May 2014 05:26:50 +0000 (UTC) Received: (qmail 69558 invoked by uid 500); 2 May 2014 05:26:48 -0000 Delivered-To: apmail-phoenix-dev-archive@phoenix.apache.org Received: (qmail 69490 invoked by uid 500); 2 May 2014 05:26:47 -0000 Mailing-List: contact dev-help@phoenix.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@phoenix.incubator.apache.org Delivered-To: mailing list dev@phoenix.incubator.apache.org Received: (qmail 69384 invoked by uid 99); 2 May 2014 05:26:45 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 May 2014 05:26:45 +0000 X-ASF-Spam-Status: No, hits=-2000.7 required=5.0 tests=ALL_TRUSTED,RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO mail.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 02 May 2014 05:26:44 +0000 Received: (qmail 67538 invoked by uid 99); 2 May 2014 05:26:17 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 May 2014 05:26:17 +0000 Date: Fri, 2 May 2014 05:26:17 +0000 (UTC) From: "James Taylor (JIRA)" To: dev@phoenix.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Resolved] (PHOENIX-879) Dynamic Columns:select and upsert error on a salt table MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ 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.(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.(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.(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.(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)