Untitled

CREATE MATERIALIZED VIEW hobs_ods_staging.hos_cart_details_username AS
  SELECT * FROM hobs_ods_staging.hos_cart_details
  WHERE hoscd_username IS NOT NULL
  PRIMARY KEY (hoscd_username, hoscd_event_date, hoscd_opid, hoscd_buid, hoscd_key)
  WITH CLUSTERING ORDER BY (hoscd_event_date ASC, hoscd_opid ASC, hoscd_buid ASC, hoscd_key ASC);