hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nemon Lou (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-16907) "INSERT INTO" overwrite old data when destination table encapsulated by backquote
Date Thu, 15 Jun 2017 08:18:00 GMT
Nemon Lou created HIVE-16907:
--------------------------------

             Summary:  "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: 2.1.1, 1.1.0
            Reporter: Nemon Lou


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
(v6.4.14#64029)

Mime
View raw message