https://community.cloudera.com/t5/Support-Questions/Select-in-impala-has-different-value-with-hive/m-p/67148#M13766 <P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/18441">@saranvisa</a></P><P>&nbsp;</P><P>1) I have compare it &amp; it is in the same location</P><P>2) actualy, value from column x in hive, show in column y in impala, please see below image for detail</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="compare.PNG" style="width: 600px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/4080iCA9A3C0A54174F7A/image-size/large?v=v2&amp;px=999" role="button" title="compare.PNG" alt="compare.PNG" /></span></P><P>&nbsp;</P><P>base on above image, we can see. value of <STRONG>n i p</STRONG> column in hive, show in <STRONG>am_name_senior</STRONG> in impala.</P><P>&nbsp;</P><P>Thanks</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 11 May 2018 02:53:20 GMT hendry 2018-05-11T02:53:20Z