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 <p...@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 >