[
https://issues.apache.org/jira/browse/HIVE-16907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bing Li reassigned HIVE-16907:
------------------------------
Assignee: Bing Li
> "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
>
> 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)
