[
https://issues.apache.org/jira/browse/HIVE-25579?focusedWorklogId=658898&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-658898
]
ASF GitHub Bot logged work on HIVE-25579:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 01/Oct/21 11:41
Start Date: 01/Oct/21 11:41
Worklog Time Spent: 10m
Work Description: anuragshekhar2020 commented on a change in pull request
#2687:
URL: https://github.com/apache/hive/pull/2687#discussion_r720174703
##########
File path: ql/src/java/org/apache/hadoop/hive/ql/parse/LoadSemanticAnalyzer.java
##########
@@ -518,7 +518,12 @@ private void reparseAndSuperAnalyze(Table table, URI
fromURI) throws SemanticExc
// Step 2 : create the Insert query
StringBuilder rewrittenQueryStr = new StringBuilder();
- rewrittenQueryStr.append("insert into table ");
+ if (isOverWrite) {
+ rewrittenQueryStr.append("insert overwrite table ");
+ } else {
Review comment:
LGTM
Excellent catch.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 658898)
Remaining Estimate: 0h
Time Spent: 10m
> LOAD overwrite appends rather than overwriting
> ----------------------------------------------
>
> 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
> Labels: pull-request-available
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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)
