https://community.cloudera.com/t5/Support-Questions/update-with-alias-not-working/m-p/343967#M234063 <P>Hello Team,</P><P>&nbsp;</P><P>could you please advise how update with table alias works?</P><P>update cbs_cubes.TB_JDV_CBS_NEW<BR />set<BR />a.SUB_SERVICE_CODE_V=b.SUB_SERVICE_CODE_V from cbs_cubes.update1_sub_service_code b<BR />where a.SUB_SERVICE_CODE_V=b.SUB_SERVICE_CODE_V</P><P>&nbsp;</P><P><SPAN>[Cloudera][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:AnalysisException: 'cbs_cubes.TB_JDV_CBS_NEW' is not a valid table alias or reference. ), Query: update cbs_cubes.TB_JDV_CBS_NEW set a.SUB_SERVICE_CODE_V=b.SUB_SERVICE_CODE_V from cbs_cubes.update1_sub_service_code b where a.SUB_SERVICE_CODE_V=b.SUB_SERVICE_CODE_V.</SPAN></P><P>&nbsp;</P><P><SPAN>Thanks,</SPAN></P><P><SPAN>Roshan</SPAN></P> Wed, 18 May 2022 08:11:07 GMT roshanbi 2022-05-18T08:11:07Z