hive_script/multiple_insert.hql at master · tgib23/hive_script · GitHub

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
drop table if exists mult_src;
drop table if exists mult_dist;

create table mult_src (
	num int
	)
	partitioned by (part string);

create table mult_dist (
	num int
	)
	partitioned by (part string);

load data local inpath 'mult_src0' overwrite into table mult_src partition (part='src0');
load data local inpath 'mult_src1' overwrite into table mult_src partition (part='src1');

from mult_src
	insert overwrite table mult_dist partition (part='src0')
		select num where (part='src0')
	insert overwrite table mult_dist partition (part='src1')
		select num where (part='src1')
		;

from mult_src
	insert overwrite local directory '/home/hadoop/hive/build/dist/mult_src_output_v1_0'
		select num where (part='src0')
	insert overwrite local directory '/home/hadoop/hive/build/dist/mult_src_output_v1_1'
		select num where (part='src1');