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 Tue, 11 Jul 2017 17:32:00 GMT

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

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



Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12876643/HIVE-16907.1.patch

{color:red}ERROR:{color} -1 due to no test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 5 failed/errored test(s), 10838 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[llap_smb] (batchId=143)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] (batchId=232)
org.apache.hive.hcatalog.api.TestHCatClient.testPartitionRegistrationWithCustomSchema (batchId=177)
org.apache.hive.hcatalog.api.TestHCatClient.testPartitionSpecRegistrationWithCustomSchema
(batchId=177)
org.apache.hive.hcatalog.api.TestHCatClient.testTableSchemaPropagation (batchId=177)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/5960/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/5960/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-5960/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 5 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12876643 - PreCommit-HIVE-Build

>  "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: Bing Li
>         Attachments: 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
(v6.4.14#64029)

Mime
View raw message