question Hive Table loads less rows than the actual rows in the query in Support Questions

question Hive Table loads less rows than the actual rows in the query in Support Questions https://community.cloudera.com/t5/Support-Questions/Hive-Table-loads-less-rows-than-the-actual-rows-in-the-query/m-p/202350#M164356 <P>I am using hortonworks vm for hive computations.I am joining two hive tables and want to store the result in another hive table. When I run my query it returns me 65618892 rows but when i save the same query in the hive external table it only stores 11520062 rows and ends the query successfully without any error. I need help to store all of my data set in the hive external table.</P> Mon, 31 Jul 2017 18:52:14 GMT umairmajeed61 2017-07-31T18:52:14Z