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)
