Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 3D97D18552 for ; Mon, 28 Mar 2016 10:53:54 +0000 (UTC) Received: (qmail 61931 invoked by uid 500); 28 Mar 2016 10:53:52 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 61864 invoked by uid 500); 28 Mar 2016 10:53:52 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 61854 invoked by uid 99); 28 Mar 2016 10:53:52 -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, 28 Mar 2016 10:53:52 +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 496CA1A50EF for ; Mon, 28 Mar 2016 10:53:52 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.179 X-Spam-Level: * X-Spam-Status: No, score=1.179 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx2-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id QrS7u0t8N35o for ; Mon, 28 Mar 2016 10:53:50 +0000 (UTC) Received: from mail-vk0-f65.google.com (mail-vk0-f65.google.com [209.85.213.65]) by mx2-lw-us.apache.org (ASF Mail Server at mx2-lw-us.apache.org) with ESMTPS id CCEE65F47D for ; Mon, 28 Mar 2016 10:53:49 +0000 (UTC) Received: by mail-vk0-f65.google.com with SMTP id e6so14440518vkh.1 for ; Mon, 28 Mar 2016 03:53:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to; bh=nYOcf251oemZJYF0S3qgXJgsiY7iXhi2sBdkLilhIqg=; b=UIxy1djQJ94pasZYvHnzhpns0pnFHkjqhHgwMJZ6BomGINxMhiXnr8w4y5PIabN2Pl yPywLqJ/NepNuJUr2SU/On16QJEP2VbH6FD5mI9ni/5xfYw15Y1sokG3X3f/ZlSY/riK F/tcrXpalPvCCpm8couTmwRg17kedLoexJeXV+kLaGRNbuP8dvIwp/pqsLBtTeofFeDo MOl4CuNt88pogoIXTpxpFT2UKjnCIc86/ub4qzSlwT/r+mroHyEPvekDsgFvR67U/wSv Mk/7cveydJ+h56S2ahA6JXXvBHA1h+nBTbQRyWCCwtHKdUIoBQln9eoC45d/I9IjofHU dGeg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to; bh=nYOcf251oemZJYF0S3qgXJgsiY7iXhi2sBdkLilhIqg=; b=PEHxWEIx3VFwiVtjb22dSOORALyTzE6UWCLEiYQ+o08YTIPG4lbLHfwst4BGFkHr/T nx+XjkIDnfExCJEayu7bemiIBN4pCFrZrPGqNt6d0z0AKWmVlykkc9mvWjrGoTipmFLS nfmQwftD7na5xRIpshQPuVrGLshgE/tb0PIioeryEQ6YHNkI6hnL6B9oGsvDRm3eRfXp tviPrDRfmoQkdlxHxjPHt36OiA9s1eLNvuXL2tALd7A3Z1steTSZ22sBTKuCegnvSJMD UC9VhEmFPdTntM5OkM8NXg0RHH3tKNW66JsNHlHVaOQQx7e+SLUcQI57TgvnldN+pmuT e0tA== X-Gm-Message-State: AD7BkJIS08Qs2skE95JflFPTwoWLccW1e6R0e7M1vE/rTkbI2U3O8CqrjHu7ygt4PGl6sstctIlJ/tGzHpYeuA== MIME-Version: 1.0 X-Received: by 10.176.65.33 with SMTP id j30mr11348939uad.142.1459162428989; Mon, 28 Mar 2016 03:53:48 -0700 (PDT) Received: by 10.31.128.213 with HTTP; Mon, 28 Mar 2016 03:53:48 -0700 (PDT) In-Reply-To: References: Date: Mon, 28 Mar 2016 11:53:48 +0100 Message-ID: Subject: Re: Automatic Update statistics on ORC tables in Hive From: Mich Talebzadeh To: user Content-Type: multipart/alternative; boundary=94eb2c1246443fe746052f19ba32 --94eb2c1246443fe746052f19ba32 Content-Type: text/plain; charset=UTF-8 Thanks. This does not seem to be implemented although the Jira says resolved. It also mentions the timestamp of the last update stats. I do not see it yet. Regards, Mich Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * http://talebzadehmich.wordpress.com On 28 March 2016 at 06:19, Gopal Vijayaraghavan wrote: > > > This might be a bit far fetched but is there any plan for background > >ANALYZE STATISTICS to be performed on ORC tables > > > https://issues.apache.org/jira/browse/HIVE-12669 > > Cheers, > Gopal > > > --94eb2c1246443fe746052f19ba32 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Thanks. This does not seem to be implemented although= the Jira says resolved. It also mentions the timestamp of the last update = stats. I do not see it yet.

Regards,
Mich

On 28 March 2016 at 06:19, Gopal Vijayaragha= van <gopalv@apache.org> wrote:

> This might be a bit far fetched but is there any plan for background >ANALYZE STATISTICS to be performed=C2=A0 on ORC tables


https://issues.apache.org/jira/browse/HIVE-1= 2669

Cheers,
Gopal



--94eb2c1246443fe746052f19ba32--