Hive Select Into

Question

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;

create table people1990 as select * from people where dob_year=1990 should work — Balaswamy Vaddeman, Aug 05 '13 at 06:02

score 33 · Accepted Answer · answered Aug 05 '13 at 06:16

33

You can use create table tablename as in Hive.

example:

create table people1990 as select * from people where dob_year=1990

answered Aug 05 '13 at 06:16

Balaswamy Vaddeman

8,360
3
30
40

Hive Select Into

1 Answers1