You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Matouk IFTISSEN <ma...@ysance.com> on 2014/12/19 22:16:01 UTC
Hive count(*) anormal result--> it returns just last number of
inserted records
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 <http://www.ysance.com/>
Fax : +33 1 73 72 97 26
*Ysance sur* :*Twitter* <http://twitter.com/ysance>* | Facebook
<https://www.facebook.com/pages/Ysance/131036788697> | Google+
<https://plus.google.com/u/0/b/115710923959357341736/115710923959357341736/posts>
| LinkedIn
<http://www.linkedin.com/company/ysance> | Newsletter
<http://www.ysance.com/nous-contacter.html>*
*Nos autres sites* : *ys4you* <http://wwww.ys4you.com/>* | labdecisionnel
<http://www.labdecisionnel.com/> | decrypt <http://decrypt.ysance.com/>*