https://community.cloudera.com/t5/Support-Questions/Hive-3-1-4-Multiple-rows-from-COUNT-query/m-p/313878#M225779 <P>Hi,</P><P>the simple count(*) on the base table is working correctly:</P><P class="lia-indent-padding-left-30px"><FONT face="courier new,courier,monospace">select count(*) from be_prd_prt.test_case;</FONT><BR /><FONT face="courier new,courier,monospace">+---------+</FONT><BR /><FONT face="courier new,courier,monospace">| _c0 |</FONT><BR /><FONT face="courier new,courier,monospace">+---------+</FONT><BR /><FONT face="courier new,courier,monospace">| 537586 |</FONT><BR /><FONT face="courier new,courier,monospace">+---------+</FONT><BR /><FONT face="courier new,courier,monospace">1 row selected (0.2 seconds)</FONT></P><P>I have troubles with the query I wrote, because it returns a wrong number of rows (not just 1, as expected)</P> Wed, 31 Mar 2021 09:18:22 GMT giovannimori 2021-03-31T09:18:22Z