蜂巢 - 分区表(hive - partitioning table)

 我用查询创建了一个配置单元表 - 
 
create table studpart4(id int, name string) partitioned by (course string, year int) row format delimited fields terminated by '\t' lines terminated by '\n' stored as textfile;
 
 创建成功。 
 
 使用以下命令加载数据 - 
 
 load data local inpath '/scratch/hive_inputs/student_input_1.txt' overwrite into table studpart4 partition(course='cse',year=2); 
 
 我的输入数据文件看起来像 - 
 
 101    student1    cse 1

 102    student2    cse 2

 103    student3    eee 3

 104    student4    eee 4

 105    student5    cse 1

 106    student6    cse 2

 107    student7    eee 3

 108    student8    eee 4

 109    student9    cse 1

 110    student10   cse 2
 
 但是输出显示为（ select * from studpart4的select * from studpart4 ） - 
 
 101    student1    cse 2

 102    student2    cse 2

 103    student3    eee 2

 104    student4    eee 2

 105    student5    cse 2

 106    student6    cse 2

 107    student7    eee 2

 108    student8    eee 2

 109    student9    cse 2

 110    student10   cse 2
 
 为什么最后一列是全部2.为什么它会被更改并错误地更新。 

I have created a hive table with the query - 
 
create table studpart4(id int, name string) partitioned by (course string, year int) row format delimited fields terminated by '\t' lines terminated by '\n' stored as textfile;
 
Created successfully.
 
Loaded data with below command - 
 
load data local inpath '/scratch/hive_inputs/student_input_1.txt' overwrite into table studpart4 partition(course='cse',year=2);
 
And my input data file looks like - 
 
 101    student1    cse 1

 102    student2    cse 2

 103    student3    eee 3

 104    student4    eee 4

 105    student5    cse 1

 106    student6    cse 2

 107    student7    eee 3

 108    student8    eee 4

 109    student9    cse 1

 110    student10   cse 2
 
But output is displayed as (of select * from studpart4) -- 
 
 101    student1    cse 2

 102    student2    cse 2

 103    student3    eee 2

 104    student4    eee 2

 105    student5    cse 2

 106    student6    cse 2

 107    student7    eee 2

 108    student8    eee 2

 109    student9    cse 2

 110    student10   cse 2
 
Why does the last column is all 2. Why did it get changed and updating wrongly.

原文：https://stackoverflow.com/questions/39057380