Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Excel adds � in front of results

Highlighted

Excel adds � in front of results

New Contributor

Hi, not sure where to ask this question.  I'm simply an end-user, and dont understand the vast majority of the language used in these forums.  

 

When using excel to retrieve data from my database using Impala odbc driver, sometimes I get an extra � added in front of my string. 

 

When using HUE, this character is not there.

 

I tried running a select distinct on hue, I get 19 distinct values.  In excel, when I look at distinct values, I get 36.  Every string seems to get duplicated, with an extra � in front, except for NULL and (Blank) which do not get duplicated.