From dev-return-56897-archive-asf-public=cust-asf.ponee.io@phoenix.apache.org Fri Jun 7 17:59:04 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id B10B9180784 for ; Fri, 7 Jun 2019 19:59:03 +0200 (CEST) Received: (qmail 85154 invoked by uid 500); 7 Jun 2019 17:59:02 -0000 Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@phoenix.apache.org Delivered-To: mailing list dev@phoenix.apache.org Received: (qmail 85057 invoked by uid 99); 7 Jun 2019 17:59:01 -0000 Received: from mailrelay1-us-west.apache.org (HELO mailrelay1-us-west.apache.org) (209.188.14.139) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Jun 2019 17:59:01 +0000 Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 88C2CE2D05 for ; Fri, 7 Jun 2019 17:59:00 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 49C2024637 for ; Fri, 7 Jun 2019 17:59:00 +0000 (UTC) Date: Fri, 7 Jun 2019 17:59:00 +0000 (UTC) From: "Jacob Isaac (JIRA)" To: dev@phoenix.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (PHOENIX-5317) Upserting rows into child views with pk fails when the base view has an index on it. MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/PHOENIX-5317?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacob Isaac updated PHOENIX-5317: --------------------------------- Attachment: PHOENIX-5137-TestFailure.txt > Upserting rows into child views with pk fails when the base view has an index on it. > ------------------------------------------------------------------------------------ > > Key: PHOENIX-5317 > URL: https://issues.apache.org/jira/browse/PHOENIX-5317 > Project: Phoenix > Issue Type: Sub-task > Affects Versions: 4.13.0, 4.14.1 > Reporter: Jacob Isaac > Priority: Major > Attachments: PHOENIX-5137-TestFailure.txt > > > Steps to reproduce - > 1 Create Base Table, Base/Global View and Index using non tenanted connection. > CREATE TABLE IF NOT EXISTS TEST.BASETABLE ( > TENANT_ID CHAR(15) NOT NULL, > KEY_PREFIX CHAR(3) NOT NULL, > CREATED_DATE DATE, > CREATED_BY CHAR(15), > SYSTEM_MODSTAMP DATE > CONSTRAINT PK PRIMARY KEY ( > TENANT_ID, > KEY_PREFIX > ) > ) VERSIONS=1, MULTI_TENANT=true, IMMUTABLE_ROWS=TRUE, REPLICATION_SCOPE=1; > CREATE VIEW IF NOT EXISTS TEST.MY_GLOBAL_VIEW ( > TEXT1 VARCHAR NOT NULL, > INT1 BIGINT NOT NULL, > DOUBLE1 DECIMAL(12, 3), > IS_BOOLEAN BOOLEAN, > RELATIONSHIP_ID CHAR(15), > TEXT_READ_ONLY VARCHAR, > DATE_TIME1 DATE, > JSON1 VARCHAR, > IP_START_ADDRESS VARCHAR > CONSTRAINT PKVIEW PRIMARY KEY > ( > TEXT1, INT1 > ) > ) > AS SELECT * FROM TEST.BASETABLE WHERE KEY_PREFIX = '0CY'; > CREATE INDEX IF NOT EXISTS TEST_MY_GLOBAL_VIEW_SEC_INDEX > ON TEST.MY_GLOBAL_VIEW (TEXT1, INT1) > INCLUDE (CREATED_BY, RELATIONSHIP_ID, JSON1, DOUBLE1, IS_BOOLEAN, IP_START_ADDRESS, CREATED_DATE, SYSTEM_MODSTAMP, TEXT_READ_ONLY); > 2. Create child view using an tenant-owned connection > CREATE VIEW IF NOT EXISTS TEST."z01" (COL1 VARCHAR, COL2 VARCHAR, COL3 VARCHAR, COL4 VARCHAR CONSTRAINT PK PRIMARY KEY (COL1, COL2, COL3, COL4)) AS SELECT * FROM TEST.MY_GLOBAL_VIEW; > 3. Upsert into child view > UPSERT INTO TEST."z01" (DATE_TIME1, INT1, TEXT1, COL1, COL2, COL3, COL4) VALUES (TO_DATE('2017-10-16 22:00:00', 'yyyy-MM-dd HH:mm:ss'), 10, 'zzzzz', '8', 'zzzzz', 'zzzzz', 'zzzzz'); > Following exception is thrown - > 0: jdbc:phoenix:localhost> UPSERT INTO TEST."z01" (DATE_TIME1, INT1, TEXT1, COL1, COL2, COL3, COL4) VALUES (TO_DATE('2017-10-16 22:00:00', 'yyyy-MM-dd HH:mm:ss'), 10, 'zzzzz', '8', 'zzzzz', 'zzzzz', 'zzzzz'); > java.lang.IllegalArgumentException > at com.google.common.base.Preconditions.checkArgument(Preconditions.java:76) > at com.google.common.collect.Lists.computeArrayListCapacity(Lists.java:105) > at com.google.common.collect.Lists.newArrayListWithExpectedSize(Lists.java:195) > at org.apache.phoenix.index.IndexMaintainer.(IndexMaintainer.java:424) > at org.apache.phoenix.index.IndexMaintainer.create(IndexMaintainer.java:143) > at org.apache.phoenix.schema.PTableImpl.getIndexMaintainer(PTableImpl.java:1176) > at org.apache.phoenix.util.IndexUtil.generateIndexData(IndexUtil.java:303) > at org.apache.phoenix.execute.MutationState$1.next(MutationState.java:519) > at org.apache.phoenix.execute.MutationState$1.next(MutationState.java:501) > at org.apache.phoenix.execute.MutationState.send(MutationState.java:941) > at org.apache.phoenix.execute.MutationState.send(MutationState.java:1387) > at org.apache.phoenix.execute.MutationState.commit(MutationState.java:1228) > at org.apache.phoenix.jdbc.PhoenixConnection$3.call(PhoenixConnection.java:666) > at org.apache.phoenix.jdbc.PhoenixConnection$3.call(PhoenixConnection.java:662) > at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) > at org.apache.phoenix.jdbc.PhoenixConnection.commit(PhoenixConnection.java:662) > at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:399) > at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:379) > at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) > at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:378) > at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:366) > at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1775) > at sqlline.Commands.execute(Commands.java:822) > at sqlline.Commands.sql(Commands.java:732) > at sqlline.SqlLine.dispatch(SqlLine.java:807) > at sqlline.SqlLine.begin(SqlLine.java:681) > at sqlline.SqlLine.start(SqlLine.java:398) > at sqlline.SqlLine.main(SqlLine.java:292) -- This message was sent by Atlassian JIRA (v7.6.3#76005)