Constant CREATE
Source pub const CREATE: &str = "-- Covers self-join.\n\nCREATE MATERIALIZED VIEW nexmark_q8\nAS\nSELECT\n P.id,\n P.name,\n P.starttime\nFROM (\n SELECT\n id,\n name,\n window_start AS starttime,\n window_end AS endtime\n FROM\n TUMBLE(person, date_time, INTERVAL \'10\' SECOND)\n GROUP BY\n id,\n name,\n window_start,\n window_end\n) P\nJOIN (\n SELECT\n seller,\n window_start AS starttime,\n window_end AS endtime\n FROM\n TUMBLE(auction, date_time, INTERVAL \'10\' SECOND)\n GROUP BY\n seller,\n window_start,\n window_end\n) A ON P.id = A.seller\n AND P.starttime = A.starttime\n AND P.endtime = A.endtime;\n";