Hadoop, Pig, and SQL (SELECT)

gistfile1.txt

SELECT * FROM mytable;

DUMP mytable;
SELECT col1, col2 FROM mytable;

mytable = FOREACH mytable GENERATE col1, col2;
DUMP mytable;
SELECT col1 AS new_col1, col2 AS new_col2 FROM mytable;

mytable = FOREACH mytable GENERATE col1 AS new_col1, col2 AS new_col2;
DUMP mytable;
SELECT col1::integer, col2::varchar FROM mytable;

mytable = FOREACH mytable GENERATE (int)col1, (chararray)col2;
DUMP mytable;
SELECT * FROM mytable LIMIT 10;

mytable = LIMIT mytable 10;
DUMP mytable;
SELECT * FROM mytable ORDER BY col1 ASC;

mytable = ORDER mytable BY col1 ASC;
DUMP mytable;
SELECT * FROM mytable WHERE col1 > 20;

mytable = FILTER mytable BY col1 > 20;
DUMP mytable;