hive数据从文本导入

145 阅读 0 评论 96 点赞

我是靠谱客的博主平常外套，这篇文章主要介绍hive数据从文本导入，现在分享给大家，希望可以做个参考。

1,建表语句

复制代码

1
2
3
4
5
6
7
8
9
(id int, name string,

age int, tel string)

ROW FORMAT DELIMITED

FIELDS TERMINATED BY 't'

STORED AS TEXTFILE;

2,url.txt文本

复制代码

1
2
3
1	wyp     25      13188888888888
2       test    30      13888888888888
3       zs      34      899314121

3,加载数据

复制代码

1
load data local inpath '/data/projects/clusters/test/url.txt' into table joeyon;

4,查询 select * from joeyon;

复制代码

1
2
3
4
5
hive> select * from joeyon;                                                           
OK
1	wyp	25	13188888888888
2	test	30	13888888888888
3	zs	34	899314121

5,命令行信息

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
ive> select * from joeyon;     
FAILED: Error in semantic analysis: Line 1:14 Table not found 'joeyon'
hive> create table joeyon
    > 
    > (id int, name string,
    > 
    > age int, tel string)
    > 
    > ROW FORMAT DELIMITED
    > 
    > FIELDS TERMINATED BY 't'
    > 
    > STORED AS TEXTFILE;
OK
Time taken: 0.055 seconds
hive> load data local inpath '/data/projects/clusters/test/url.txt' into table joeyon;
Copying data from file:/data/projects/clusters/test/url.txt
Copying file: file:/data/projects/clusters/test/url.txt
Loading data to table default.joeyon
OK
Time taken: 0.18 seconds
hive> select * from joeyon;                                                           
OK
1	wyp	25	13188888888888
2	test	30	13888888888888
3	zs	34	899314121
Time taken: 0.078 seconds
hive>