https://community.cloudera.com/t5/Support-Questions/Hive-Table-loads-less-rows-than-the-actual-rows-in-the-query/m-p/202351#M164357 <P><A rel="user" href="https://community.cloudera.com/users/25153/umairmajeed61.html" nodeid="25153">@Umair Majeed</A> </P><P>Could you explain in brief how did you load the external table? </P><P>Also did you took count(*) to check the record count or it by through the stats available in the table properties? </P><P>Whats is the delimited , rows seperator used in the external table? </P><P>There are chances that the rows from the source query may be splitted into multiple records in the external tables. Check for the column delimiter and rows seperator. It might solve your issue. </P> Mon, 31 Jul 2017 20:38:10 GMT balavignesh_nag 2017-07-31T20:38:10Z