From dev-return-49319-archive-asf-public=cust-asf.ponee.io@phoenix.apache.org Sun Feb 11 18:31:07 2018 Return-Path: X-Original-To: archive-asf-public@eu.ponee.io Delivered-To: archive-asf-public@eu.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by mx-eu-01.ponee.io (Postfix) with ESMTP id 047FA18064E for ; Sun, 11 Feb 2018 18:31:07 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id E8782160C4E; Sun, 11 Feb 2018 17:31:06 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 3ACF2160C2E for ; Sun, 11 Feb 2018 18:31:06 +0100 (CET) Received: (qmail 58541 invoked by uid 500); 11 Feb 2018 17:31:05 -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 58530 invoked by uid 99); 11 Feb 2018 17:31:05 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 11 Feb 2018 17:31:05 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id DF39B18032A for ; Sun, 11 Feb 2018 17:31:04 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -110.311 X-Spam-Level: X-Spam-Status: No, score=-110.311 tagged_above=-999 required=6.31 tests=[ENV_AND_HDR_SPF_MATCH=-0.5, RCVD_IN_DNSWL_MED=-2.3, SPF_PASS=-0.001, T_RP_MATCHES_RCVD=-0.01, 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 (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id ShtpRrovlX9q for ; Sun, 11 Feb 2018 17:31:04 +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 7AC345FACF for ; Sun, 11 Feb 2018 17:31:03 +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 AD809E01DB for ; Sun, 11 Feb 2018 17:31:02 +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 718C121E85 for ; Sun, 11 Feb 2018 17:31:01 +0000 (UTC) Date: Sun, 11 Feb 2018 17:31:01 +0000 (UTC) From: "James Taylor (JIRA)" To: dev@phoenix.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (PHOENIX-4596) Add SINGLE_CELL_PER_LEVEL to ensure denseness with hierarchies of views MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 James Taylor created PHOENIX-4596: ------------------------------------- Summary: Add SINGLE_CELL_PER_LEVEL to ensure denseness with hierarchies of views Key: PHOENIX-4596 URL: https://issues.apache.org/jira/browse/PHOENIX-4596 Project: Phoenix Issue Type: Sub-task Reporter: James Taylor Currently we store the col qualifier counter at the physical table level. If we stored it at the view level then the array would be dense. We didn't do this initially because we wouldn't be able to handle adding a new column to the base table (unless we preallocated a fixed number of columns and started the view counters at this number). We could solve this issue if we stored column values for each level of the hierarchy in its own cell. The base table column values would be stored in a single cell. Views would store their columns in a separate cell, grand child-views in their own cell and so on. We could also do this only when a column is added to the base table (or a view), then store that column value (and any further columns that are added) in its own cell. We start the column qualifier counter at each level at the number of cols in the parent +1. -- This message was sent by Atlassian JIRA (v7.6.3#76005)