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 cust-asf.ponee.io (Postfix) with SMTP id C9F3E160C05 for ; Wed, 3 Jan 2018 19:36:55 +0100 (CET) Received: (qmail 65830 invoked by uid 500); 3 Jan 2018 18:36:55 -0000 Mailing-List: contact user-help@impala.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@impala.apache.org Delivered-To: mailing list user@impala.apache.org Received: (qmail 65820 invoked by uid 99); 3 Jan 2018 18:36:54 -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, 03 Jan 2018 18:36:54 +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 7EEDB180161 for ; Wed, 3 Jan 2018 18:36:54 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.879 X-Spam-Level: * X-Spam-Status: No, score=1.879 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_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=cloudera.com 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 ddgUXVPUdnqn for ; Wed, 3 Jan 2018 18:36:51 +0000 (UTC) Received: from mail-oi0-f51.google.com (mail-oi0-f51.google.com [209.85.218.51]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 23E6F5F3B6 for ; Wed, 3 Jan 2018 18:36:51 +0000 (UTC) Received: by mail-oi0-f51.google.com with SMTP id t78so1536625oie.8 for ; Wed, 03 Jan 2018 10:36:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cloudera.com; s=google; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=hrRInEZh5osKJzaZSaVWfZbS3A9/qAJg08FWEBqPXDU=; b=VcWx4ol0baNbSwh0lsIpledyEJqgylVvR32WIzv6dePEXI9UOg2bG+U02cSdDTlUzh wtOrZEDco582GFVcMjdj9HvtpQVigzO6wrB+K7yvBx+QWRGpJ3XHkHm5TRaXQUJmo7nN j0dWqo7FCrSX6ZNh6FtBADatMaRatFpV7nzlrF/Q8cEg1xwiISqzyX7ZAiRcDLnW6VSd nw5l3f2XSPvMjFDSpxEvdCkkOLj/si47/lszeUiJPL+9YVnYXPXblBkTM5nPQt/X0Nf6 IRSDzXsalTpFXMiEoZn+q1vKI/6PWHasglNjCaPTmaRgIs0jlcuD1OQByqQsBCNwnzvO CpXw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=hrRInEZh5osKJzaZSaVWfZbS3A9/qAJg08FWEBqPXDU=; b=WEbyH2SjEoHA/RqQGNjexCqGi1IV9jwa8Y5uyzK16vt3c68o+3vW8c4L1MufjAMZhP Rry/WzAn249GuTJ/1WRQ8fFgWaFTv5kfOYgl2TBmJgNBNdcElZ0KNtcFBDm4EXQJox3d NyX9qkJ5ifKFXeJ7iC+C6e8Or1IPDeadIqEbhvHy6UrtAPeKTDFgusQ/4rsmq0E+rrNi qNdAylijrjO85rvuvOSKiEifUyjSB5DqltnEL9v8DnqRs0pI9ND06mJHVlEIhxRcl6X/ S2GfCTiVtIDNJP+KfPGXbT0S28VE+3Q9KMSXuFIuWwodZJS/8F/leblFnUOMvlli7t/1 5fPw== X-Gm-Message-State: AKGB3mKYxfWz0Ugi89zL1RUmPTomwDLJyTTgn3bsb3gvnjj3HFnue1L+ homFHa6d0AYMesHBPwDMziy+81Vv5QMZCG93ENzoKw== X-Google-Smtp-Source: ACJfBov5jIQczxp5U0pp5Hn/pAmcK9d5L8QhWakajUNzf4RI7F5mROudvTetGaP1K5t3rEU2XV0ONmRSnaBkP59OUVs= X-Received: by 10.202.199.133 with SMTP id x127mr1127284oif.17.1515004603887; Wed, 03 Jan 2018 10:36:43 -0800 (PST) MIME-Version: 1.0 Received: by 10.202.235.65 with HTTP; Wed, 3 Jan 2018 10:36:43 -0800 (PST) In-Reply-To: References: From: Alexander Behm Date: Wed, 3 Jan 2018 10:36:43 -0800 Message-ID: Subject: Re: Issues running compute incremental stats in Impala - alter not possible To: user@impala.apache.org Content-Type: multipart/alternative; boundary="001a1134fa803fa0b50561e37fca" archived-at: Wed, 03 Jan 2018 18:36:56 -0000 --001a1134fa803fa0b50561e37fca Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Thanks for the report. I have not seen this issue. Looks like the alter RPC is rejected by the Hive Metastore. Maybe looking into the Hive/Metastore logs would help. The SHOW CREATE TABLE output might also help us debug. On Wed, Jan 3, 2018 at 10:28 AM, Piyush Narang wrote: > Hi folks, > > > > I=E2=80=99m running into some issues when I try to compute incremental st= ats in > Impala that I was hoping someone would be able to help with. I=E2=80=99m = able to > =E2=80=98compute stats=E2=80=99 in Impala on my smaller tables just fine.= When I try > computing stats incrementally for one of my larger tables, I seem to be > running into this error: > > > compute incremental stats bi_ full partition (param1=3D0,day=3D'2017-10= -04', > hour=3D00,host_platform=3D'EU'); > > Query: compute incremental stats bi_full partition > (param1=3D0,day=3D'2017-10-04',hour=3D00,host_platform=3D'EU') > > WARNINGS: ImpalaRuntimeException: Error making 'alter_partitions' RPC to > Hive Metastore: > > CAUSED BY: InvalidOperationException: alter is not possible > > > > Looking at impalad.INFO and catalogd.INFO I don=E2=80=99t see any additio= nal > details. I verified that I=E2=80=99m the owner of the tables in HDFS. > > > > Has anyone run into this issue in the past? Any workarounds? > > > > Thanks, > > > > -- Piyush > > > --001a1134fa803fa0b50561e37fca Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks for the report. I have not seen this issue. Looks l= ike the alter RPC is rejected by the Hive Metastore. Maybe looking into the= Hive/Metastore logs would help.

The SHOW CREATE TABLE o= utput might also help us debug.

<= div class=3D"gmail_quote">On Wed, Jan 3, 2018 at 10:28 AM, Piyush Narang <p.narang@criteo.com> wrote:

Hi folks,=

=C2=A0

I=E2=80=99m running= into some issues when I try to compute incremental stats in Impala that I = was hoping someone would be able to help with. I=E2=80=99m able to =E2=80= =98compute stats=E2=80=99 in Impala on my smaller tables just fine. When I try computing stats incrementally for one of my larger tables, I seem to= be running into this error:

> compute increm= ental stats bi_ full partition (param1=3D0,day=3D'2017-10-04',= hour=3D00,host_platform=3D'EU');

Query: compute incr= emental stats bi_full partition (param1=3D0,day=3D'2017-10-04',hour=3D00,host_platform=3D'EU')

WARNINGS: ImpalaRun= timeException: Error making 'alter_partitions' RPC to Hive Metastor= e:

CAUSED BY: InvalidO= perationException: alter is not possible

=C2=A0

Looking at impalad.= INFO and catalogd.INFO I don=E2=80=99t see any additional details. I verifi= ed that I=E2=80=99m the owner of the tables in HDFS.

=C2=A0

Has anyone run into= this issue in the past? Any workarounds?

=C2=A0

Thanks,

=

=C2=A0

--=C2=A0Piyush

=C2=A0


--001a1134fa803fa0b50561e37fca--