https://community.cloudera.com/t5/Support-Questions/Hive-3-1-4-Multiple-rows-from-COUNT-query/m-p/313877#M225778 <P>Can you please try the below command:</P><P>&nbsp; &nbsp;select count(*) from&nbsp;<SPAN>&nbsp;data2;&nbsp;</SPAN></P><P>&nbsp;</P><P><SPAN>It should return one single row .</SPAN></P> Wed, 31 Mar 2021 09:08:16 GMT asish 2021-03-31T09:08:16Z