https://community.cloudera.com/t5/Support-Questions/Hive-3-1-4-Multiple-rows-from-COUNT-query/m-p/314196#M225913 <P>Hi asish,</P><P>I collected statistics again (I already did it before posting), but the result is the same: 4 rows instead 1.</P><P><FONT face="courier new,courier,monospace" size="3">+------------------+</FONT><BR /><FONT face="courier new,courier,monospace" size="3">| num_all_changes |</FONT><BR /><FONT face="courier new,courier,monospace" size="3">+------------------+</FONT><BR /><FONT face="courier new,courier,monospace" size="3">| 63 |</FONT><BR /><FONT face="courier new,courier,monospace" size="3">| 58 |</FONT><BR /><FONT face="courier new,courier,monospace" size="3">| 64 |</FONT><BR /><FONT face="courier new,courier,monospace" size="3">| 59 |</FONT><BR /><FONT face="courier new,courier,monospace" size="3">+------------------+</FONT><BR /><FONT face="courier new,courier,monospace" size="3">4 rows selected (13.45 seconds)</FONT></P> Wed, 07 Apr 2021 07:26:13 GMT giovannimori 2021-04-07T07:26:13Z