| create table impressions (imp string, msg string) | |
| row format delimited | |
| fields terminated by '\t' | |
| lines terminated by '\n' | |
| stored as textfile; | |
| LOAD DATA LOCAL INPATH '../../data/files/in7.txt' INTO TABLE impressions; | |
| select * from impressions; | |
| select imp,msg from impressions; | |
| drop table impressions; |