In this post, I describe how to insert data from a text file to a hive table.
Suppose you have tab delimited file::
1 2 3 4 |
% cat /tmp/input.txt k1 v1 k2 v2 |
Create a Hive table stored as a text file.
1 2 3 4 |
create table test_table (k string, v string) </code><code>row format delimited </code><code>fields terminated by '\t' stored as textfile; |
Load the text file (stored locally) into the Hive table:
1 2 3 4 5 6 7 |
hive(test_db)> load data local inpath 'file:/homes/user/hive/input.txt' into table test_table; Loading data to table test_db.test_table OK Time taken: 0.43 seconds |
Create a Hive table stored as sequence file.
1 |
create table test_sq(k string, v string) stored as sequencefile; |
Now you can load into the sequence table from the text table:
1 |
insert into table test_sq select * from test_table; |
[Read More...]