You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Nemon Lou (JIRA)" <ji...@apache.org> on 2017/06/15 08:18:00 UTC
[jira] [Created] (HIVE-16907) "INSERT INTO" overwrite old data
when destination table encapsulated by backquote
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)