https://community.cloudera.com/t5/Support-Questions/Count-Distinct-discrepancy-Hive/m-p/225087#M186950 <P><A href="https://community.hortonworks.com/questions/198236/count-distinct-discrepancy-hive.html#"></A><A href="https://community.cloudera.com/legacyfs/online/attachments/77788-screen-shot-2018-06-20-at-125515-pm.png">screen-shot-2018-06-20-at-125515-pm.png</A>@anarasimham thanks for your reply.</P><P>mdse_item_i data type is int</P><P>`mdse_item_i` int</P><P>and the output attached as screenshot</P> Thu, 21 Jun 2018 00:56:15 GMT reddyr211 2018-06-21T00:56:15Z