ql/src/test/queries/clientpositive/notable_alias3.q

CREATE TABLE dest1(c string, key INT, value DOUBLE) STORED AS TEXTFILE;

FROM src
INSERT OVERWRITE TABLE dest1 SELECT '1234', src.key, sum(src.value) WHERE src.key < 100 group by key;