EG5Rp11k

1CREATE TABLE employee (employeeId INT, employeeName STRING, employeeSalary INT) PARTITIONED BY (ds INT);
2	
3LOAD DATA LOCAL INPATH './examples/files/kv2.txt' OVERWRITE INTO TABLE employee PARTITION (ds=2000);
4	
5LOAD DATA LOCAL INPATH './examples/files/kv2.txt' OVERWRITE INTO TABLE employee PARTITION (ds=4000);
6	
7CREATE TABLE employee (employeeId INT, employeeName STRING) PARTITIONED BY (employeeSalary INT);
8	
9LOAD DATA LOCAL INPATH './examples/files/kv2.txt' OVERWRITE INTO TABLE employee PARTITION (employeeSalary=2000, employeeSalary=4000);
10	
11FROM from_statement
12INSERT OVERWRITE TABLE tablename1 [PARTITION (partcol1=val1, partcol2=val2 ...) [IF NOT          EXISTS]] select_statement1
13[INSERT OVERWRITE TABLE tablename2 [PARTITION ... [IF NOT EXISTS]] select_statement2] 
14[INSERT INTO TABLE tablename2 [PARTITION ...] select_statement2] ...;
15FROM from_statement
16INSERT INTO TABLE tablename1 [PARTITION (partcol1=val1, partcol2=val2 ...)] select_statement1
17[INSERT INTO TABLE tablename2 [PARTITION ...] select_statement2] 
18[INSERT OVERWRITE TABLE tablename2 [PARTITION ... [IF NOT EXISTS]] select_statement2] ...;
19	
20from big_data_table
21insert overwrite table table1 partiton (ds=2000)
22select * where employeeId>0 && employeeId<101>
23insert overwrite table table2 partition (ds=4000)
24select * where employeeId>=101&&employeeId<=600
25	
26CREATE TABLE emp_temp (employeeId INT, employeeName STRING,employeeSalary INT ) stored as text;
27	
28INSERT OVERWRITE TABLE employee partition(employeeSalary) 
29   SELECT employeeId , employeeName , employeeSalary 
30   from emp_temp