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.

while incremental append my total count of ordr

Highlighted

while incremental append my total count of ordr

New Contributor

CREATE TABLE tt.LastUpdated AS SELECT t1.* FROM (SELECT * FROM tt.order UNION ALL SELECT * FROM tt.increment_filter) t1 JOIN (SELECT OrderID, max(modified_date) max_modified FROM (SELECT * FROM tt.order UNION ALL SELECT * FROM tt.increment_filter) t2 GROUP BY OrderID) s ON t1.OrderID = s.OrderID AND t1.modified_date = s.max_modified;

this is my logic which is accurate for duplicate data but when unique data came status wise result is wrong