Untitled

CREATE MATERIALIZED VIEW hobs_ods_staging.cart_details_by_createdtime_key AS
SELECT businessid, createdtime, key, buid, opid, status, type, updatedtime, username, value, valuetype
FROM hobs_ods_staging.cart_details
WHERE businessid IS NOT NULL AND createdtime IS NOT NULL AND key IS NOT NULL
PRIMARY KEY (businessid, createdtime, key)
WITH CLUSTERING ORDER BY (createdtime ASC, key ASC);