Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id AB4D6200D2F for ; Wed, 1 Nov 2017 21:06:05 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id AA0491609EC; Wed, 1 Nov 2017 20:06:05 +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 F10CA160BEA for ; Wed, 1 Nov 2017 21:06:04 +0100 (CET) Received: (qmail 43378 invoked by uid 500); 1 Nov 2017 20:06:04 -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 43367 invoked by uid 99); 1 Nov 2017 20:06:04 -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; Wed, 01 Nov 2017 20:06:04 +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 60AA5180871 for ; Wed, 1 Nov 2017 20:06:03 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -99.202 X-Spam-Level: X-Spam-Status: No, score=-99.202 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, RP_MATCHES_RCVD=-0.001, SPF_PASS=-0.001, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id lsgbhhJgUx0t for ; Wed, 1 Nov 2017 20:06:02 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id 9DCA75F6BE for ; Wed, 1 Nov 2017 20:06:02 +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 931EBE2592 for ; Wed, 1 Nov 2017 20:06:01 +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 EF49824410 for ; Wed, 1 Nov 2017 20:06:00 +0000 (UTC) Date: Wed, 1 Nov 2017 20:06:00 +0000 (UTC) From: "James Taylor (JIRA)" To: dev@phoenix.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (PHOENIX-4334) Unable to update stats on views that reside on separate regions before phoenix.stats.updateFrequency has elapsed MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Wed, 01 Nov 2017 20:06:05 -0000 [ https://issues.apache.org/jira/browse/PHOENIX-4334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16234656#comment-16234656 ] James Taylor commented on PHOENIX-4334: --------------------------------------- I thought the last updated time was based on the guideposts, not the global setting in the physical table? Do we have a test case for this (or can we outline one)? Is the info in the explain plan wrong? > Unable to update stats on views that reside on separate regions before phoenix.stats.updateFrequency has elapsed > ---------------------------------------------------------------------------------------------------------------- > > Key: PHOENIX-4334 > URL: https://issues.apache.org/jira/browse/PHOENIX-4334 > Project: Phoenix > Issue Type: Bug > Affects Versions: 4.12.0 > Reporter: Mujtaba Chohan > Assignee: Samarth Jain > Priority: Major > > Consider multiple tenant views that all reside on unique region/region servers. Updating stats on any one of the view causes other views to report estimated stats last update time as current resulting in stats command getting ignored for other views till {{phoenix.stats.updateFrequency}} has elapsed. -- This message was sent by Atlassian JIRA (v6.4.14#64029)