I need to do an update of a column with values from another table Step1: execute(set hive.enforce.bucketing=true)by hadoop; execute(set hive.exec.dynamic.partition.mode=nonstrict)by hadoop; CREATE TABLE z_test1 ( LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255) ) clustered by (City) into 3 buckets stored as orc TBLPROPERTIES ('transactional'='true') Step2: Insert into z_test1 VALUES ("david","baker","houston","tx"),("rose","crab","houston","tx") lastname firstname address city david baker houston tx rose crab houston tx Step3: execute(set hive.enforce.bucketing=true)by hadoop; execute(set hive.exec.dynamic.partition.mode=nonstrict)by hadoop; CREATE TABLE z_test ( LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255), country varchar(255) ) clustered by (City) into 3 buckets stored as orc TBLPROPERTIES ('transactional'='true') Step4: Insert into z_test VALUES ("david","burrows","houston","tx","usa") lastname firstname address city country david burrows houston tx usa Step5: update z_test1 set FirstName= z.FirstName from z_test z where z_test1.LastName= z.LastName Error in step5 Desired Result: davids first name in table z_test1 should be updated as burrows from second table lastname firstname address city david burrows houston tx rose crab houston tx ... View more