CREATE TABLE T2 AS SELECT * FROM T1 WHERE C1 LIKE 'something%';
It works, I've just tried it.
Later addition. It works on a limited data. If your source table is huge then it's going to be a problem. The main problem is that this query allocates only one reducer by default. So you have two choices - either increase number of reducers or do the following:
- Copy a sample file to your directory
- Create a new table based on this file