[ 
https://issues.apache.org/jira/browse/HIVE-25579?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ayush Saxena reassigned HIVE-25579:
-----------------------------------


> LOAD overwrite appends rather than ovewriting
> ---------------------------------------------
>
>                 Key: HIVE-25579
>                 URL: https://issues.apache.org/jira/browse/HIVE-25579
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Ayush Saxena
>            Assignee: Ayush Saxena
>            Priority: Critical
>
> The overwrite query gets converted to append.
> {noformat}
> 7b6-4b43-8452-52c44e8a2f71): LOAD DATA INPATH 
> 'hdfs://ayushsaxena-1.ayushsaxena.root.hwx.site:8020/warehouse/tablespace/external/hive/test_ext/000000_0'
>  OVERWRITE  INTO TABLE test_spark
> 2021-09-30 03:30:23,033 INFO  org.apache.hadoop.hive.ql.lockmgr.DbTxnManager: 
> [db2ab9c9-bf54-4304-bc06-e3bef76f2e79 HiveServer2-Handler-Pool: Thread-2600]: 
> Opened txnid:15
> 2021-09-30 03:30:23,035 INFO  
> org.apache.hadoop.hive.ql.parse.LoadSemanticAnalyzer: 
> [db2ab9c9-bf54-4304-bc06-e3bef76f2e79 HiveServer2-Handler-Pool: Thread-2600]: 
> Starting caching scope for: 
> hive_20210930033023_bb1f6dc4-d7b6-4b43-8452-52c44e8a2f71
> 2021-09-30 03:30:23,042 INFO  
> org.apache.hadoop.hive.ql.parse.LoadSemanticAnalyzer: 
> [db2ab9c9-bf54-4304-bc06-e3bef76f2e79 HiveServer2-Handler-Pool: Thread-2600]: 
> Load data triggered a Tez job instead of usual file operation
> 2021-09-30 03:30:23,042 INFO  
> org.apache.hadoop.hive.ql.parse.LoadSemanticAnalyzer: 
> [db2ab9c9-bf54-4304-bc06-e3bef76f2e79 HiveServer2-Handler-Pool: Thread-2600]: 
> Going to reparse <LOAD DATA INPATH 
> 'hdfs://ayushsaxena-1.ayushsaxena.root.hwx.site:8020/warehouse/tablespace/external/hive/test_ext/000000_0'
>  OVERWRITE  INTO TABLE test_spark> as
> <insert into table `default`.`test_spark` partition (`col2`) select * from 
> test_spark__temp_table_for_load_data__>
> {noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to