Hive Select Into

I have a database people in hive. It's schema is as follows:

name string,
dob_date int,
dob_month int,
dob_year int.

I have successfully loaded data from a file into the database.
Now I want to have people having dob_year=1990 into a new table.
The following code doesn't work :

Select * into people1990 from people where dob_year=1990;