[ 
https://issues.apache.org/jira/browse/HIVE-16907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16726353#comment-16726353
 ] 

Hive QA commented on HIVE-16907:
--------------------------------

| (/) *{color:green}+1 overall{color}* |
\\
\\
|| Vote || Subsystem || Runtime || Comment ||
|| || || || {color:brown} Prechecks {color} ||
| {color:green}+1{color} | {color:green} @author {color} | {color:green}  0m  
0s{color} | {color:green} The patch does not contain any @author tags. {color} |
|| || || || {color:brown} master Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  7m 
44s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  
0s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
42s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  3m 
43s{color} | {color:blue} ql in master has 2310 extant Findbugs warnings. 
{color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  0m 
53s{color} | {color:green} master passed {color} |
|| || || || {color:brown} Patch Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  1m 
21s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  
2s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green}  1m  
2s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
43s{color} | {color:green} ql: The patch generated 0 new + 862 unchanged - 2 
fixed = 862 total (was 864) {color} |
| {color:green}+1{color} | {color:green} whitespace {color} | {color:green}  0m 
 0s{color} | {color:green} The patch has no whitespace issues. {color} |
| {color:green}+1{color} | {color:green} findbugs {color} | {color:green}  3m 
48s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  0m 
53s{color} | {color:green} the patch passed {color} |
|| || || || {color:brown} Other Tests {color} ||
| {color:green}+1{color} | {color:green} asflicense {color} | {color:green}  0m 
13s{color} | {color:green} The patch does not generate ASF License warnings. 
{color} |
| {color:black}{color} | {color:black} {color} | {color:black} 22m 30s{color} | 
{color:black} {color} |
\\
\\
|| Subsystem || Report/Notes ||
| Optional Tests |  asflicense  javac  javadoc  findbugs  checkstyle  compile  |
| uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 
3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux |
| Build tool | maven |
| Personality | 
/data/hiveptest/working/yetus_PreCommit-HIVE-Build-15412/dev-support/hive-personality.sh
 |
| git revision | master / e103abc |
| Default Java | 1.8.0_111 |
| findbugs | v3.0.0 |
| modules | C: ql U: ql |
| Console output | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-15412/yetus.txt |
| Powered by | Apache Yetus    http://yetus.apache.org |


This message was automatically generated.



>  "INSERT INTO"  overwrite old data when destination table encapsulated by 
> backquote 
> ------------------------------------------------------------------------------------
>
>                 Key: HIVE-16907
>                 URL: https://issues.apache.org/jira/browse/HIVE-16907
>             Project: Hive
>          Issue Type: Bug
>          Components: Parser
>    Affects Versions: 1.1.0, 2.1.1
>            Reporter: Nemon Lou
>            Assignee: Zoltan Haindrich
>            Priority: Major
>         Attachments: HIVE-16907.02.patch, HIVE-16907.03.patch, 
> HIVE-16907.03.patch, HIVE-16907.03.patch, HIVE-16907.03.patch, 
> HIVE-16907.1.patch
>
>
> A way to reproduce:
> {noformat}
> create database tdb;
> use tdb;
> create table t1(id int);
> create table t2(id int);
> explain insert into `tdb.t1` select * from t2;
> {noformat}
> {noformat}
> +---------------------------------------------------------------------------------------------------------------------------------------------------+
> |                                                                      
> Explain                                                                      |
> +---------------------------------------------------------------------------------------------------------------------------------------------------+
> | STAGE DEPENDENCIES:                                                         
>                                                                       |
> |   Stage-1 is a root stage                                                   
>                                                                       |
> |   Stage-6 depends on stages: Stage-1 , consists of Stage-3, Stage-2, 
> Stage-4                                                                      |
> |   Stage-3                                                                   
>                                                                       |
> |   Stage-0 depends on stages: Stage-3, Stage-2, Stage-5                      
>                                                                       |
> |   Stage-2                                                                   
>                                                                       |
> |   Stage-4                                                                   
>                                                                       |
> |   Stage-5 depends on stages: Stage-4                                        
>                                                                       |
> |                                                                             
>                                                                       |
> | STAGE PLANS:                                                                
>                                                                       |
> |   Stage: Stage-1                                                            
>                                                                       |
> |     Map Reduce                                                              
>                                                                       |
> |       Map Operator Tree:                                                    
>                                                                       |
> |           TableScan                                                         
>                                                                       |
> |             alias: t2                                                       
>                                                                       |
> |             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column 
> stats: NONE                                                             |
> |             Select Operator                                                 
>                                                                       |
> |               expressions: id (type: int)                                   
>                                                                       |
> |               outputColumnNames: _col0                                      
>                                                                       |
> |               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column 
> stats: NONE                                                           |
> |               File Output Operator                                          
>                                                                       |
> |                 compressed: false                                           
>                                                                       |
> |                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE 
> Column stats: NONE                                                         |
> |                 table:                                                      
>                                                                       |
> |                     input format: 
> org.apache.hadoop.hive.ql.io.RCFileInputFormat                                
>                                   |
> |                     output format: 
> org.apache.hadoop.hive.ql.io.RCFileOutputFormat                               
>                                  |
> |                     serde: 
> org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe                          
>                                          |
> |                     name: tdb.t1                                            
>                                                                       |
> |                                                                             
>                                                                       |
> |   Stage: Stage-6                                                            
>                                                                       |
> |     Conditional Operator                                                    
>                                                                       |
> |                                                                             
>                                                                       |
> |   Stage: Stage-3                                                            
>                                                                       |
> |     Move Operator                                                           
>                                                                       |
> |       files:                                                                
>                                                                       |
> |           hdfs directory: true                                              
>                                                                       |
> |           destination: 
> hdfs://hacluster/user/hive/warehouse/tdb.db/t1/.hive-staging_hive_2017-06-15_15-52-34_017_849305017872068583-1/-ext-10000
>   |
> |                                                                             
>                                                                       |
> |   Stage: Stage-0                                                            
>                                                                       |
> |     Move Operator                                                           
>                                                                       |
> |       tables:                                                               
>                                                                       |
> |           replace: true                                                     
>                                                                       |
> |           table:                                                            
>                                                                       |
> |               input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat  
>                                                                       |
> |               output format: 
> org.apache.hadoop.hive.ql.io.RCFileOutputFormat                               
>                                        |
> |               serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe   
>                                                                       |
> |               name: tdb.t1                                                  
>                                                                       |
> |                                                                             
>                                                                       |
> |   Stage: Stage-2                                                            
>                                                                       |
> |     Merge File Operator                                                     
>                                                                       |
> |       Map Operator Tree:                                                    
>                                                                       |
> |           RCFile Merge Operator                                             
>                                                                       |
> |       merge level: block                                                    
>                                                                       |
> |       input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat          
>                                                                       |
> |                                                                             
>                                                                       |
> |   Stage: Stage-4                                                            
>                                                                       |
> |     Merge File Operator                                                     
>                                                                       |
> |       Map Operator Tree:                                                    
>                                                                       |
> |           RCFile Merge Operator                                             
>                                                                       |
> |       merge level: block                                                    
>                                                                       |
> |       input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat          
>                                                                       |
> |                                                                             
>                                                                       |
> |   Stage: Stage-5                                                            
>                                                                       |
> |     Move Operator                                                           
>                                                                       |
> |       files:                                                                
>                                                                       |
> |           hdfs directory: true                                              
>                                                                       |
> |           destination: 
> hdfs://hacluster/user/hive/warehouse/tdb.db/t1/.hive-staging_hive_2017-06-15_15-52-34_017_849305017872068583-1/-ext-10000
>   |
> |                                                                             
>                                                                       |
> +---------------------------------------------------------------------------------------------------------------------------------------------------+
> {noformat}
> Note that  'replace: true'  in move operator



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to