使用 where 子句复制表

CREATE TABLE myschema.tableNew AS (
    SELECT *
    FROM myschema.tableOld
WHERE column1 = 'myCriteria'
) WITH  DATA