From dev-return-52423-archive-asf-public=cust-asf.ponee.io@phoenix.apache.org Tue Jun 12 00:24:04 2018 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 [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 2F260180670 for ; Tue, 12 Jun 2018 00:24:04 +0200 (CEST) Received: (qmail 32094 invoked by uid 500); 11 Jun 2018 22:24:03 -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 32083 invoked by uid 99); 11 Jun 2018 22:24:03 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 11 Jun 2018 22:24:03 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id CF1E61A18DB for ; Mon, 11 Jun 2018 22:24:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -109.501 X-Spam-Level: X-Spam-Status: No, score=-109.501 tagged_above=-999 required=6.31 tests=[ENV_AND_HDR_SPF_MATCH=-0.5, KAM_ASCII_DIVIDERS=0.8, RCVD_IN_DNSWL_MED=-2.3, SPF_PASS=-0.001, USER_IN_DEF_SPF_WL=-7.5, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id 7OLQoH7CYW8d for ; Mon, 11 Jun 2018 22:24:02 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id 557715F2F2 for ; Mon, 11 Jun 2018 22:24:01 +0000 (UTC) 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 6B684E0C51 for ; Mon, 11 Jun 2018 22:24: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 22A8421099 for ; Mon, 11 Jun 2018 22:24:00 +0000 (UTC) Date: Mon, 11 Jun 2018 22:24:00 +0000 (UTC) From: "James Taylor (JIRA)" To: dev@phoenix.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (PHOENIX-4195) PHOENIX-4195 Deleting view rows with extended PKs through the base table silently fails 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-4195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16508858#comment-16508858 ] James Taylor commented on PHOENIX-4195: --------------------------------------- Probably best to file another Jira to talk about how a global tenant can best see tenant specific view data. Since the schema is potentially different for each view, doing so in a single query is going to be problematic. You could have the same column in different views with different types. As far as this Jira goes, you're going to break other functionality (i.e. indexes on views) by mutating view data through a global connection. Also, you'd be disabling an optimization that helps the vast majority of use cases. I think it needs to be thought through more or a different approach needs to be taken - like establishing a tenant specific connection to delete each tenant's data. There's minuscule overhead in establishing this connection. > PHOENIX-4195 Deleting view rows with extended PKs through the base table silently fails > --------------------------------------------------------------------------------------- > > Key: PHOENIX-4195 > URL: https://issues.apache.org/jira/browse/PHOENIX-4195 > Project: Phoenix > Issue Type: Bug > Reporter: Thomas D'Silva > Assignee: Geoffrey Jacoby > Priority: Major > Attachments: test.diff > > > The attached test fails. -- This message was sent by Atlassian JIRA (v7.6.3#76005)