https://community.cloudera.com/t5/Support-Questions/update-with-alias-not-working/m-p/343978#M234065 <P>Hi&nbsp;<a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/81707">@roshanbi</a>&nbsp;,</P><P>The query itself seems incomplete to me, I do not see where is the alias "a" defined in the</P><P>&nbsp;</P><P><SPAN>a.SUB_SERVICE_CODE_V=b.SUB_SERVICE_CODE_V</SPAN></P><P>&nbsp;</P><P><SPAN>part. Also it is not clear which is the database name, which is a table, and is there any complex types involved here.</SPAN></P><P><SPAN>Can you run a select on the "cbs_cubes.TB_JDV_CBS_NEW"? (assuming that's a "database.table")</SPAN></P><P><SPAN>Can you run a simple update on it?&nbsp;</SPAN></P><P><SPAN>Are you using the latest Cloudera Impala JDBC driver version?</SPAN></P><P><SPAN>Is the affected table a Kudu based table?</SPAN></P><P>&nbsp;</P><P><SPAN>Thanks, Miklos</SPAN></P> Wed, 18 May 2022 12:34:12 GMT mszurap 2022-05-18T12:34:12Z