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 1C181200C56 for ; Fri, 14 Apr 2017 17:37:56 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 1A95E160B8C; Fri, 14 Apr 2017 15:37:56 +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 39A06160B80 for ; Fri, 14 Apr 2017 17:37:55 +0200 (CEST) Received: (qmail 15594 invoked by uid 500); 14 Apr 2017 15:37:52 -0000 Mailing-List: contact user-help@impala.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@impala.incubator.apache.org Delivered-To: mailing list user@impala.incubator.apache.org Received: (qmail 15581 invoked by uid 99); 14 Apr 2017 15:37:52 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 14 Apr 2017 15:37:52 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 7998FCCEF3 for ; Fri, 14 Apr 2017 15:37:52 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.48 X-Spam-Level: ** X-Spam-Status: No, score=2.48 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001, WEIRD_PORT=0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=cloudera-com.20150623.gappssmtp.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id tCeytLQ5caDa for ; Fri, 14 Apr 2017 15:37:50 +0000 (UTC) Received: from mail-oi0-f50.google.com (mail-oi0-f50.google.com [209.85.218.50]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 4A8DF5FC4C for ; Fri, 14 Apr 2017 15:37:49 +0000 (UTC) Received: by mail-oi0-f50.google.com with SMTP id x184so7030372oia.1 for ; Fri, 14 Apr 2017 08:37:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cloudera-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=NEKkMq/EDYCg5LUH2AjmvQ0zYc8Sp8gu85OOpl3bzL8=; b=Wpz/GBSJQrvUIaxFaE67D+U/zKnP55QxGIcx7pkYCPx69SrqNwuSCp+10DZlW0vXA2 5W8i0+tCbEeGDwCd4xsk/YrHcsRCckgKw+79HeI8mjpR42NYghspyQ6iK21u2LFBxqqe kqPODJZ4YCT5sGJoFO8vwehdML5J+oSYAGqc+qhYpItPdFJCVk4r5MUTZxMwSEnzuctp xJJ92f2L7VcsCRYu4XIbnAYXYAhWTOZaTiyv25oLO9P2+oDmORl8sIsqmwHmj/FMg3BN ULnv7M3i61FcQxASmA3oXxHKFcbn7ZqpbEicO8HWndDnpSZRD/83JYi/aRuw0/z3DFAc e4/Q== 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=NEKkMq/EDYCg5LUH2AjmvQ0zYc8Sp8gu85OOpl3bzL8=; b=KfQMYC1z1ZSgdPPkzRnAcs/1iQsoNn5b1Y4GKXA4snwpJ0ToBJUcuBGK1vZHHVoRDt 5bMvobQUWZHFazy+Z9Bc/iKR24Ei1hTlANAVvTycbwOWvCgpps2g4/zAHE9MTekrZZLr CLvKbPvwmR6VuAtOpUuMjjmXYGdXsWpcAAS+ym9mU5S8q2njHEQungO3cWbuFtfziycE CnVhtzHWory21H2e8XYhbyf/NYoJup0spLv+CyyO4eRonBOP78mqpcxY/A4ZRmQMwmbp O9QEl8jY1Ps7iZ7IUfYEEmuwLIPAUgtAG43NJNOSnmUJfVCxyfeWh4ot9KvBb80WVZ5J PQLg== X-Gm-Message-State: AN3rC/7FgpuF6GvMi+Ow3EsFaxQtgc6dcLjEudFiOtJf2cAOhEVvnIZQ 3Aed91Whdc9M6pzrGRCw5rYQJBh9dWVObo8= X-Received: by 10.157.1.102 with SMTP id 93mr5275106otu.260.1492184267892; Fri, 14 Apr 2017 08:37:47 -0700 (PDT) MIME-Version: 1.0 Received: by 10.202.48.21 with HTTP; Fri, 14 Apr 2017 08:37:47 -0700 (PDT) In-Reply-To: References: From: Alexander Behm Date: Fri, 14 Apr 2017 08:37:47 -0700 Message-ID: Subject: Re: Impala query seems doesn't return correct result when query after insert immediately. To: user@impala.incubator.apache.org Content-Type: multipart/alternative; boundary=94eb2c09560e3a49b0054d22394f archived-at: Fri, 14 Apr 2017 15:37:56 -0000 --94eb2c09560e3a49b0054d22394f Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thanks for posting. What Impala version are you running? Is the issue always reproducible? Are you behind a load balancer? Can you provide SHOW CREATE TABLE or the involved tables? Thanks! Alex On Fri, Apr 14, 2017 at 12:05 AM, =E4=BF=8A=E6=9D=B0=E9=99=88 wrote: > Hi > I met following strange issue, I insert a table from another table, and > execute immediately, it shows wrong result. > [bdpe822n2:21000] > insert into test.test5 select * from test.test2; > > Query: insert into test.test5 select * from test.test2 > Query submitted at: 2017-04-14 14:21:53 (Coordinator: > http://bdpe822n2:25000) > Query progress can be monitored at: http://bdpe822n2:25000/query_ > plan?query_id=3Dba42eeb19d262dc6:c10ef07500000000 > Modified 16 row(s) in 5.22s > [bdpe822n2:21000] > select * from test5; > Query: select * from test5 > Query submitted at: 2017-04-14 14:22:05 (Coordinator: > http://bdpe822n2:25000) > Query progress can be monitored at: http://bdpe822n2:25000/query_ > plan?query_id=3D7c4ff772ce33f171:6933975300000000 > +----+------+----------+ > | id | name | progress | > +----+------+----------+ > | 3 | jj | 12.1 | > | 3 | test | 15.3 | > | 4 | jj | 12.3 | > | 2 | fs | 15.2 | > | 18 | jj | 12.3 | > | 13 | jj | 12.3 | > | 14 | jj | 13.4 | > | 2 | jj | 12.1 | > | 12 | jj | 12.3 | > | 6 | jj | 12.3 | > | 5 | jj | 12.3 | > | 20 | jj | 12.3 | > | 45 | jj | 13.4 | > | 15 | jj | 15.5 | > | 3 | jj | 12.3 | > | 1 | jj | 23.5 | > +----+------+----------+ > Fetched 16 row(s) in 0.18s > [bdpe822n2:21000] > select * from test5 where id=3D3; > Query: select * from test5 where id=3D3 > Query submitted at: 2017-04-14 14:22:13 (Coordinator: > http://bdpe822n2:25000) > Query progress can be monitored at: http://bdpe822n2:25000/query_ > plan?query_id=3D23432b5caf4b1ab4:9ade99c300000000 > +----+------+----------+ > | id | name | progress | > +----+------+----------+ > | 3 | jj | 12.3 | > +----+------+----------+ > Fetched 1 row(s) in 0.18s > > However, after I restart the impala cluster, it can get correct result. > Does anyone met issue like this? Should I need to run some synchronized > command? > > > -- > Thanks & Best Regards > --94eb2c09560e3a49b0054d22394f Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Thanks for posting. What Impala version are you running? I= s the issue always reproducible? Are you behind a load balancer? Can you pr= ovide SHOW CREATE TABLE or the involved tables?

Thanks!<= /div>

Alex

On Fri, Apr 14, 2017 at 12:05 AM, =E4=BF=8A=E6=9D= =B0=E9=99=88 <cjjnjust@gmail.com> wrote:
Hi=C2=A0
I met following strange issue= , I insert a table from another table, and execute immediately, it shows wr= ong result.=C2=A0
[bdpe822n2:21000] > insert into test.te= st5 select * from test.test2; =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0Query: insert into test.test5 select * from test.test2
Quer= y submitted at: 2017-04-14 14:21:53 (Coordinator: http://bdpe822n2:25000)
Modified 16 row(s) in 5.22s
[bdpe822n2:21000] = > select * from test5;
Query: select * from test5
Qu= ery submitted at: 2017-04-14 14:22:05 (Coordinator: http://bdpe822n2:25000)
+----+------+----------+
| id | name | progr= ess |
+----+------+----------+
| 3 =C2=A0| jj =C2=A0 | = 12.1 =C2=A0 =C2=A0 |
| 3 =C2=A0| test | 15.3 =C2=A0 =C2=A0 |
| 4 =C2=A0| jj =C2=A0 | 12.3 =C2=A0 =C2=A0 |
| 2 =C2=A0| fs= =C2=A0 | 15.2 =C2=A0 =C2=A0 |
| 18 | jj =C2=A0 | 12.3 =C2=A0 =C2= =A0 |
| 13 | jj =C2=A0 | 12.3 =C2=A0 =C2=A0 |
| 14 | jj= =C2=A0 | 13.4 =C2=A0 =C2=A0 |
| 2 =C2=A0| jj =C2=A0 | 12.1 =C2= =A0 =C2=A0 |
| 12 | jj =C2=A0 | 12.3 =C2=A0 =C2=A0 |
| = 6 =C2=A0| jj =C2=A0 | 12.3 =C2=A0 =C2=A0 |
| 5 =C2=A0| jj =C2=A0 = | 12.3 =C2=A0 =C2=A0 |
| 20 | jj =C2=A0 | 12.3 =C2=A0 =C2=A0 |
| 45 | jj =C2=A0 | 13.4 =C2=A0 =C2=A0 |
| 15 | jj =C2=A0 = | 15.5 =C2=A0 =C2=A0 |
| 3 =C2=A0| jj =C2=A0 | 12.3 =C2=A0 =C2=A0= |
| 1 =C2=A0| jj =C2=A0 | 23.5 =C2=A0 =C2=A0 |
+----+-= -----+----------+
Fetched 16 row(s) in 0.18s
[bdpe822n2= :21000] > select * from test5 where id=3D3;
Query: select * fr= om test5 where id=3D3
Query submitted at: 2017-04-14 14:22:13 (Co= ordinator: http://bdpe= 822n2:25000)
+----+------+-------= ---+
| id | name | progress |
+----+------+----------+<= /div>
| 3 =C2=A0| jj =C2= =A0 | 12.3 =C2=A0 =C2=A0 |
+----+------+----------+
<= div>Fetched 1 row(s) in 0.18s

However, after I res= tart the impala cluster, it can get correct result. Does anyone met issue l= ike this? Should I need to run some synchronized command?=C2=A0


-- <= br>
Thanks & Best Re= gards

--94eb2c09560e3a49b0054d22394f--