https://community.cloudera.com/t5/Support-Questions/Count-Distinct-discrepancy-Hive/m-p/225086#M186949 <P>What datatype is mdse_item_i originally? Can you paste the output here for when you get the 7 distinct values versus the 10 distinct values? I'd like to see what the difference is.</P> Wed, 20 Jun 2018 20:36:30 GMT anarasimham 2018-06-20T20:36:30Z