hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ping Zhu <p...@sharethis.com>
Subject Re: wrong number of records loaded to a table is returned by Hive
Date Fri, 01 Oct 2010 17:30:31 GMT
I had such issues on different versions of hadoop/hive: The version of
hadoop/hive
I am using now is hadoop 0.20.2/hive 0.7. The version of hadoop/hive I once
used is hadoop 0.20.0/hive 0.5

Ping

On Fri, Oct 1, 2010 at 10:23 AM, Ping Zhu <ping@sharethis.com> wrote:

> Hi,
>
>   I ran a simple Hive query inserting data into a target table from a
> source table. The number of records loaded to the target table (say number
> A), which is returned by running this query, is different with the number
> (say number B) returned by running a query "select count(1) from target". I
> checked the number of rows in target table's HDFS files by running command
> "hadoop fs -cat /root/hive/metastore_db/ptarget/* | wc -l ". The number
> returned is number B. I believe number B is the actual number of rows in
> target table.
>
>   I had this issue intermittently. Any comments?
>
>   Thank you very much.
>
>   Ping
>

Mime
View raw message