hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hive QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-16907) "INSERT INTO" overwrite old data when destination table encapsulated by backquote
Date Wed, 19 Dec 2018 16:47:00 GMT

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

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 56s{color}
| {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  2s{color} |
{color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 41s{color}
| {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  3m 38s{color} | {color:blue}
ql in master has 2310 extant Findbugs warnings. {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  0m 50s{color} |
{color:green} master passed {color} |
|| || || || {color:brown} Patch Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  1m 20s{color}
| {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  1s{color} |
{color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green}  1m  1s{color} | {color:green}
the patch passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 42s{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 50s{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 12s{color}
| {color:green} The patch does not generate ASF License warnings. {color} |
| {color:black}{color} | {color:black} {color} | {color:black} 22m 34s{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-15385/dev-support/hive-personality.sh
|
| git revision | master / 1020be0 |
| 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-15385/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.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)

Mime
View raw message