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 0307F10064 for ; Fri, 19 Dec 2014 21:17:35 +0000 (UTC) Received: (qmail 97823 invoked by uid 500); 19 Dec 2014 21:17:33 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 97755 invoked by uid 500); 19 Dec 2014 21:17:33 -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 97745 invoked by uid 99); 19 Dec 2014 21:17:32 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 19 Dec 2014 21:17:32 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,HTML_OBFUSCATE_05_10,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of matouk.iftissen@ysance.com designates 209.85.216.52 as permitted sender) Received: from [209.85.216.52] (HELO mail-qa0-f52.google.com) (209.85.216.52) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 19 Dec 2014 21:17:29 +0000 Received: by mail-qa0-f52.google.com with SMTP id x12so1184100qac.11 for ; Fri, 19 Dec 2014 13:16:22 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:from:date:message-id:subject:to :content-type; bh=9APt6+3hzgODz+195HTatOs4gVPseQVpx/ZzS6cY6U8=; b=dv/HdP5/77bDClL3fcSMMsfjgZ83BNJLzxKeVDnJfZW7HV13wZ1vWttZ7LCxI2nOYh 0rygIqwNmd+fbOG/BKTFgltm07vpOpoQsn0hbP5ez83zrxn2ArU3i1OhSxLkPRs9F55F aEO5wYZDVTEi90ImGZ2XO42td2/QgkOiIsAEkr0clCNMAF3IdhOP2x3LSxYQLfT+NRIu 352m2Dvou4PppSiNheAvdRRHW/EmdGHglItrN0IvkysMcjvnDBBxgx6cgITRb8b+RTlu S23UcI12/Drw08MU7I4Z1ql71XumYkei2lM5QaKJYXjIQtlUv80PzHEUL0/xMu07kiFK xIkA== X-Gm-Message-State: ALoCoQm+p+bIyaXOGf1KcAmHln20XbOnNxojxi8oKlfS1RZpqkZ3ieGwOLGCdP2cpDXIL2HvK9yS X-Received: by 10.224.65.134 with SMTP id j6mr17491668qai.90.1419023782663; Fri, 19 Dec 2014 13:16:22 -0800 (PST) MIME-Version: 1.0 Received: by 10.140.18.201 with HTTP; Fri, 19 Dec 2014 13:16:01 -0800 (PST) From: Matouk IFTISSEN Date: Fri, 19 Dec 2014 22:16:01 +0100 Message-ID: Subject: Hive count(*) anormal result--> it returns just last number of inserted records To: user@hive.apache.org Content-Type: multipart/alternative; boundary=001a11c2c9a47e72aa050a9838a1 X-Virus-Checked: Checked by ClamAV on apache.org --001a11c2c9a47e72aa050a9838a1 Content-Type: text/plain; charset=UTF-8 Hi geeks, I have a table ( myTable in orc format), when I insert in this table records : ( insert into table myTable select * from another_table -- in the folder where data are sotred I find files: 00000_0 (first insert), 00000_0, 00000_1 (second insert), ...etc-- ) and when I do : select count (*) from myTable (using Hue or Hive CLI) Hive returns just the last number of inserted records, however myTable contient more records (old records) and when I do: select "a", count (*) from myTable (using Hue or Hive CLI) the count is just What can be the cause of this ? ( metastore , stats, ... or is there a proprety that should be set ??). for Infos: Hive --> 0.13 (or later) Hadoop--> HDP 2.1.3 More thanks for your answers. Regards -- --------------- Life and Relations are not binary *Matouk IFTISSEN | Consultant BI & Big Data[image: http://www.ysance.com] * 24 rue du sentier - 75002 Paris - www.ysance.com Fax : +33 1 73 72 97 26 *Ysance sur* :*Twitter* * | Facebook | Google+ | LinkedIn | Newsletter * *Nos autres sites* : *ys4you* * | labdecisionnel | decrypt * --001a11c2c9a47e72aa050a9838a1 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi geeks,
I have =C2=A0a table ( myTable in orc format), when I inse= rt in this table records :
=C2=A0( = insert into table =C2=A0myTable =C2=A0select * from another_table -- in the= folder where data are sotred I find files: 00000_0 (first insert),=C2=A000000_0,=C2=A000000_1 (second insert), ...etc--=C2=A0)
and = =C2=A0when I do :
select count (*) f= rom myTable =C2=A0(using Hue or Hive CLI)
Hive returns just the last number= of inserted records, however =C2=A0myTable contient more records (old reco= rds)
and when I do:

select "a"= , count (*) from myTable =C2=A0(using Hue or Hive CLI)
the count is just=C2=A0

What can be the cause of this ?= ( metastore , stats, ... or is there a proprety that should be set ??).

fo= r Infos:
Hive --> 0.13 (or later)
=
Hadoop--> HDP 2.1.3

More thanks for= your answers.
Regards


--
---------------
Life and Relations are not binary
Matouk IFTISSEN | Consultant= BI & Big Data
3D"http://www.ysance.com"=C2=A0
24 rue du sentier - 75002 Paris -=C2=A0www.ysance.com
Fax :=C2=A0+33 1 73 72 97 26<= /a>=C2=A0
Ysance sur=C2=A0:Twitter=C2=A0|=C2=A0Facebook=C2=A0|=C2=A0Google+=C2=A0|=C2=A0LinkedIn=C2=A0|=C2=A0Newsletter
Nos autres sites=C2=A0:=C2=A0ys4you=C2=A0|=C2=A0labdecisionnel=C2=A0|=C2=A0decrypt
--001a11c2c9a47e72aa050a9838a1--